Viewing 15 posts - 44,986 through 45,000 (of 59,063 total)
The Thread is like the Borg?
Heh... no... it's more like the "bored". 😛
February 23, 2009 at 9:00 am
After another quick look, you still may not need a cursor... but I'm on my way to work and will have to come back to this.
February 23, 2009 at 8:59 am
Looks ok although I'll admit I haven't tried it... I don't have any servers where long periods of blocking occurs.
What's the output look like when there is blocking?
February 23, 2009 at 8:57 am
Sorry... didn't realize that it was a sponsored article in that, if you go directly to the article itself, there's nothing in the article or it's header to indicate that's...
February 23, 2009 at 8:39 am
Sorry, Lynn... I should have used a different word for "extremely lengthy". I agree... this thread has been both fun and educational.
February 23, 2009 at 8:36 am
Michael Earl (2/23/2009)
You are going to have trouble if...
February 23, 2009 at 8:24 am
I haven't tested it, but Jack normally writes code that works especially since you posted some test data. My concern is that of performance... this does have to run...
February 23, 2009 at 8:11 am
The problem is, which BillingID do you want to use for which MemberEventID.
I'm not sure this problem has a solution for the given data.
February 23, 2009 at 8:03 am
Yes, it is possible but not easily in a single query especially since you probably have the clustered index on the IDENTITY column (good idea for this type of table)....
February 23, 2009 at 7:55 am
First thing I do when I learn any new language is to lookup and read about all the functions available. Lookup CONVERT in Books Online (comes free with SQL...
February 23, 2009 at 7:11 am
Jack Corbett (2/23/2009)
Edit: moved the final closing parenthesis so that it was not a smiley.
That's definitely on my wish list to Steve to fix. In the meantime, I run...
February 23, 2009 at 7:07 am
Ya gotta be sneaky...
Drop table #mYhead
CREATE TABLE #MyHead
(
RowNum INT IDENTITY(1,1),
...
February 23, 2009 at 6:52 am
jmoss111 (2/23/2009)
I run contig.exe online, and have had no issuesRegards,
Jim
What is "contig.exe" and does it come with Windows or SQL Server for free?
Also, on a crowded disk, will it move...
February 23, 2009 at 6:48 am
Viewing 15 posts - 44,986 through 45,000 (of 59,063 total)