See what I posted here... http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=395869

Then, as Steve suggested, post the code you want to convert (provided it's NOT hundreds of lines long)

The "key" to good, high performance "Set Based" code, is to forget everything you know about programming for row solutions.  Instead, think about what you want to do to an...

Never heard that, Eddie, but I'll be on the lookout for that from now on... one more chip taken from the language barrier.  Thanks.

You're welcome, Zia.  And thank you for taking the time to explain your duplicates.

Looks pretty familiar, huh?

Shamshad,

You forgot to include the offending code like I asked...

We had similar problems finding the CPR (cut, paste, replace) code liberally sprinkled in some of our apps.  It was a bit time consuming and certainly required some regression testing,...

I'm not sure why you have data duplicated in two separate tables... that usually constitutes a violation of 3rd Normal Form... but it's your database...

... something like this will do...

I've got to agree with David... I'm sick and tired of exams that have been written by folks that are simply not qualified to write exams.  That includes the things...

Any of your processes or stored procedures using Cursors, While loops, or other RBAR?

The problem is likely not the Dynamic SQL... nor is it likely the fact that you are joining 6 tables... but it's real hard to figure out what it could...

Now. THAT's what I'm talking about!  Thanks, Colin!

Good information... thanks, Bob.  Tracey may not be acknowledging my requests but I hope (s)he is getting something out of this...

Heh... good catch... I "pasted" the wrong key

Heh... yeah... and I'm still wondering why anyone would even use the term "bashing" in relation to what I posted.  And I certainly wasn't trying to "eat at" anyone.

So, James,...