Thanks, Joe!

It's not... but the attitude that will cause everything to be written in such a fashion, or...

Thanks for the confirmation on that, Joe.  Do you happen to have a link for that or...

The way I write such  code is to ...

1.  Write it like normal, properly indented code.
2.  Test the dickens out of it to make sure it works.
3. Doe a search...

You code appears to be a part of Dynamic SQL.    If so, then replace each single quote with two single quotes.

I found an update by someone that I personally trust on the subject (to be sure, I also trust Michael but the link below has a "chart" on the subject...

BWAAA-HAAA!!!!  I wonder how that happened. 😀 😀 😀

And, not to worry... you're not the only one...

I would ask THEM (your Help Desk people) to contact Microsoft and for THEM to take full responsibility if the proverbial poo hit's the fan because of such an upgrade. ...

You should have posted those here back in 2009. 😀

I also noticed the note at the bottom of your post... why not write those functions as iTVFs instead of...

Using indices is not necessarily the same as having...

Using indices is not necessarily the same as having better performance,...

Yeah... he came back with an "I got this" post with an embedded link.  Took that one out.

What I've found is that a lot of employees have the proverbial 9-to-5- attitude and only want to improve their skills on the company nickel and on company...

Problem with learning on one's own [dt]ime is you can really only barely scrape the surface of all these techs going through books and training courses. The ecosystem is...

Not sure if anyone is ever coming back to this thread but having just worked on migrating JDE data out and found the above useful - here is the...