|
|
|
Help with Current DATE in Query
Mon, 10 Sep 2007 06:16:00 -0700
Hello, I have a table that lists my bank transactions. I have a uniqueid in
the first field and several other fields....one of which is DATE.... now, I
want to run a query where my view is based upon the DATE. however I want to
only show transactions that are the same date as the system date (this is to
se ...
|
SQL Query return different result for different user
Tue, 4 Sep 2007 02:58:02 -0700
Hi,
I have a query who returns different result for different user.
This query is just a "SELECT" from a view (or a function), like this:
Select * From MyList('12345', '67890')
When I logged in as "sa", it returns > 3000 lines (this is the number
expected)
When I logged in as "BUILTIN\Administrator", it ...
|
Syntax for query to another SQL-Server-Instance
Wed, 22 Aug 2007 14:38:03 -0700
Hi,
what is the correct syntax to execute a query to a table on another
SQL-Server-Instance.
For example:
dbo.table on Server1 with Instance2 (Server1\Instance2)
Thanks in advance
F. L. ...
|
Help with missing data in query
Tue, 14 Aug 2007 20:08:01 -0700
Hello and thanks for your efforts,
I have a table with Part, MonthSold, ItemsSold
i need to generate a view comparing this years sales to lastyears sales and
their differences by month.
this was my first shot at it:
SELECT DATENAME(month, inv_Monthly_Sales.MonthSold) AS Month,
SUM(inv_Monthly_Sale ...
|
Conditional query criteria in Access 2003 with SQL Server BE
Sat, 10 Mar 2007 07:26:03 -0800
Hello:
I just upsized an Access 2003 application to a SQL Server 2000 back end.
There is a query that worked fine before the upsize, but does not work now.
The purpose of the query is to give me a list of employees that are
scheduled to work today. The employee master row has 7 checkboxes for the
day ...
|
"Order by" clause
Fri, 2 Mar 2007 15:16:50 -0800
I run the script below in sql2005 and am receiving the error msg 209. Do I
need a prefix to order by either STATE, TAXAMNT, or SUBTOTAL because I want
them displyed in front.
Thank you.
Charlie
select STATE, TAXAMNT, SUBTOTAL, *
from sop30200
where state in('NJ','NY','WA','CO','CA','ME','OK','VA ...
|
Returning Value to Web App via Stored Procedure
Wed, 14 Feb 2007 05:52:07 -0800
I am trying to run an update stored procedure that will add 1 revision to the
rev field and return the Value back to my Application. My number is
incrementing by 2 and not 1.
Here is my Stored Procedure
CREATE PROCEDURE dbo.sp_Update_file
@kbid big,
@filename nvarchar(50),
@rev big OUTPUT,
@moddate ...
|
|
|
days between dates from a list
Tue, 13 Feb 2007 13:53:00 -0800
Hi,
I am trying to perform an interpolation of counts between event dates...my
data looks like this:
Event Date Count
1/1/06 13
1/17/06 9
2/3/06 7 etc...
The spacing of event date is not always equal thus I need to be able to do
something like this: (date1-nextdat ...
|
How To Pick Winning Stocks
Thu, 15 Jun 2006 08:25:32 GMT
To pick winning stocks, you need the tools to separate
the companies with superior sales and profit growth from
the ones who are just making a lot of noise. Besides
choosing the right companies to invest in, you must
learn how to read the market's trend so that your timing
is right.
And picking the next ...
|
Crosstab in SQL 2000
Mon, 12 Jun 2006 10:04:02 -0700
I need some assistance, i have this Stored Procedure that will take my table
and create a cross tab. Unfor, I am getting duplicate value from the output,
when checking table1, there are no dups, i dont' know what i am doing wrong.
Please help
below, code that I am using. thaks
=========================== ...
|
|
|
