Heh... no... it's more like the "bored". 😛

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.

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?

Thanks folks.

Heh... see? 😛

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...

Sorry, Lynn... I should have used a different word for "extremely lengthy". I agree... this thread has been both fun and educational.

Michael Earl (2/23/2009)

---

Jeff - I think you have an error in your outer REPLACE - it should be a / rather than a *.

You are going to have trouble if...

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...

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.

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)....

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...

That's definitely on my wish list to Steve to fix. In the meantime, I run...

Ya gotta be sneaky...

Drop table #mYhead

CREATE TABLE #MyHead

(

RowNum INT IDENTITY(1,1),

...

What is "contig.exe" and does it come with Windows or SQL Server for free?

Also, on a crowded disk, will it move...