Jeff Moden (12/29/2012)

Heh... it's when your cataracts make you see double out of one eye. Younger folks can experience the...

Jeff Moden (12/28/2012)

While it is true that a...

If you can post some ddl, sample data and desired output you will find lots of people diving in to this one. Please see the first article in my signature...

No offense Joe but I think you have lost your mind if you actually think that Amazon uses the customer email as part of the primary key. How many supporting...

You have a lot questions in there. You certainly have the right attitude to learn this stuff. I have no idea what PluralSight is but if it is helping you...

TRY/CATCH sounds like the exact thing you need.

begin transaction

begin try

-- PART 1 --

Insert into first table

Delete from first table

-- PART 2 --

Insert into a second table

Update my second table

Delete from...

It was by no means a dumb question!!! It is just hard to provide much help because of so many unknowns. I wouldn't begin to know how you could scratch...

Joe I certainly understand your position but I do have a question. You continually refer to Cindy Lou Who as employee #42. In a Joe Celko database what would be...

Not only is Bhuvnesh absolutely correct about not using a loop for this but what are you going to do when there are nulls in some rows and not in...

As Amazon if 3k requests per second is too much. 😀

There are way too many factors and too little information for anybody to be able to give you an answer.

You also might want to read up on the NOLOCK hint. It can produce all sorts of really difficult to replicate bugs. It can (and will) miss some rows and...

Please stop. You have been told repeatedly to not post so many threads and just continuing to beg for help is...

For anybody just stumbling in here, this was a response posted in another thread. http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D

For the sake of anybody else coming here please see the link I referred to above....

Did you read the whole article and look at the performance comparisons? This style of xml splitter was on the list and it was not as fast.

As...

Ni!