Viewing 15 posts - 8,731 through 8,745 (of 10,144 total)
Do you get a similar error if you run the corresponding simple select?
SELECT [Last run]
FROM [SQLSERVER\SQLINSTANCE].[Database].dbo.[UploadStatus]
WHERE [Upload job] = @UploadJob
AND Store = @ID
AND [CashDesk] = @CashDesk
March 5, 2009 at 3:58 am
Michael Valentine Jones (3/4/2009)
I know what a number table is.
Yeah I know Michael, just joshing mate, I've learned tons of stuff from you over the years. Thanks for...
March 5, 2009 at 1:26 am
Bob Hovious (3/4/2009)
21. In case using GROUP BY without an aggregate function try using DISTINCT instead
What you have to love...
March 4, 2009 at 10:37 am
Derek Dongray (3/4/2009)
It seems Mangal Pardeshi is an MVP in SQL Server
http://www.microsoft.com/india/mvp/indiamvp.aspx#MangalPardeshi
Mangal is an E&TC Engineer from Pune University. He started his career as an ERP Technical Consultant in 2007....
March 4, 2009 at 9:13 am
GilaMonster (3/4/2009)
Chris Morris (3/4/2009)
..you're not going to ask the business reason then? 😉Free beer means no questions asked.
Aw Gail, beer for you too!
Blimey, one day I'll get around to saying...
March 4, 2009 at 8:56 am
joao.rolo.sa (3/4/2009)
of Using an extra column with ID from our Data from 1 to NROWS and processing the row with ID equal to
current row number,...
March 4, 2009 at 8:51 am
JJSJ (3/4/2009)
Totals
5
5
4
5
5
4
As these are the totals of columns populated with figures other than zero.
SELECT 10.1, 11.1, 12.1, 13.1, 14.1 UNION ALL
SELECT 10.1, 11.1, 12.1,...
March 4, 2009 at 7:48 am
JJSJ (3/4/2009)
Hi,I don't think I have been clear in what I require. I will use your example.
.
.
.
Sorry I hope this makes sense???
Not yet. Can I suggest you use the following...
March 4, 2009 at 7:02 am
Grant Fritchey (3/4/2009)
Chris Morris (3/4/2009)
Wipe yer eyes mate, here's a Fuller's ESB, probably the best beer in the world.Ooohhh... Beer! And an ESB. I'm happy again. Cheers!
Welcome! ...you're not going...
March 4, 2009 at 6:57 am
GilaMonster (3/4/2009)
19 threads in total (including the Answered posts one), mostly a single post per thread. Ok solutions, little explanation and once or twice a link to the person's blog.
......
March 4, 2009 at 6:53 am
Grant Fritchey (3/4/2009)
jcrawf02 (3/4/2009)
Grant Fritchey (3/4/2009)
March 4, 2009 at 6:23 am
Mangal Pardeshi (3/4/2009)
DECLARE @T Table (Id INT, COL1 INT, COL2 INT,Val int)
INSERT INTO @T SELECT
1,2,3,10 UNION...
March 4, 2009 at 5:06 am
Try this. The DISTINCT is replaced by a GROUP BY which for this example does the same thing but is more deliberate. Run the inner select to see what it...
March 4, 2009 at 4:33 am
Michael Valentine Jones (3/3/2009)
The code you posted doesn't work, unless you happen to have a table named Numbers in the current database.
March 4, 2009 at 3:05 am
Yep that works, Lynn:
DROP TABLE #Dates
CREATE TABLE #Dates (aDate DATETIME)
INSERT INTO #Dates
SELECT TOP 100 DATEADD(dd,DATEDIFF(dd, 0, getdate()),50-number)
FROM Numbers
SELECT aDate, DATENAME(dw,aDate) AS [Day],
datediff(dd, aDate, SergiyStart) AS DaysToStartweek,
SergiyStart,...
March 3, 2009 at 10:55 am
Viewing 15 posts - 8,731 through 8,745 (of 10,144 total)