Viewing 15 posts - 41,176 through 41,190 (of 59,069 total)
Hugo Kornelis (11/10/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 5:29 pm
Alexander Kuznetsov-291390 (11/10/2009)
Looks like I should write up another blog post demonstrating how to add multiple rows at a time...
That would be very cool especially if it used neither RBAR...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 4:02 pm
Jeff Moden (11/6/2009)
Simon Parry (11/6/2009)
i have tried using BULK INSERT
using
set @string ='BULK INSERT CSVTest FROM ''\\10.1.2.107\rp_uploaded_files\'+@file+''' WITH (FIELDTERMINATOR = '','',ROWTERMINATOR = '''')'
exec (@string)
but this requires the destintation table to...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 3:53 pm
You have to observe all the rules at once, Hugo. I said in the rules that you can't use a JOIN in conjunction with the "Quirky Update" and an...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 3:49 pm
Alexander Kuznetsov-291390 (11/10/2009)
In my experience, if we need running totals, then we have some unique order of rows to calculate those totals with respect to. Because we know the running...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 3:02 pm
Hugo Kornelis (11/10/2009)
... and shaved off another half a mintue - 3:58.
Heh... very cool optimization of the cursor, Hugo. You've managed to upgrade it to only being 33...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 2:59 pm
Alexander Kuznetsov-291390 (11/10/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 1:31 pm
talltop-969015 (11/10/2009)
Alexander Kuznetsov-291390 (11/10/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 9:33 am
Alexander Kuznetsov-291390 (11/10/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 9:22 am
suresh.theyyath (11/10/2009)
Hope this will works for you!
Heh... I wrote such a function earlier in my SQL career... it's a fun function to write because it creates a huge understanding of...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 7:23 am
Hugo Kornelis (11/10/2009)
Thanks for doing a rewrite of this article.
Just a few comments before I start really reading the article:
1) Being one of the people who tried to grill...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 6:54 am
ta.bu.shi.da.yu (11/10/2009)
Now if only I could work out how to run a query that traverses a directed graph with cycles - but where there is...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 6:46 am
dm_unseen-571460 (11/10/2009)
For Running total see: http://shahamishm.blogspot.com/2009/04/how-to-do-running-sum-using-cte-sql.html
For finding previous row ordered by key_nr and...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 6:43 am
ben.mcintyre (11/10/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 6:37 am
peter-757102 (11/10/2009)
Thank you for the very clear article and all the testing done to make sure that what you claim is 100% correct. But I wouldn't be me...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 10, 2009 at 6:33 am
Viewing 15 posts - 41,176 through 41,190 (of 59,069 total)