@fn is being defined within the Dynamic SQL itself. You were trying to put the VALUE of @fn into the string, before it has been defined. ...

Listen to Lynn. A recursive CTEs is going to run slowly.

When you DO use recursive CTE, as in any Union ALL, the number and type of columns must...

Thanks for letting us know what the resolution was, KT.

Please share with us what error you are getting, the table schema(s), and perhaps a sample of data.

A lot of our developers just LOVE "NOLOCK".

If you ask them what it means, they usually respond that it means you want to go fast....

As long as there is going to be carnage, would you also add to the victims' list the names of those who say "Choose your answer", instead of "Choose all...

Make up your mind, Metro.

First I give you the parser code. Then you said one value.

I...

Make up your mind, Metro.

First I give you the parser code. Then you said one value.

I...

Abby see the puppies? (Or I be see the puppies.)

Well (or hell), them no puppies.

Yes they are. See 'em peein' ??

Hey Roy, I will translate the Arkansian for you.

Arkansas is infamous for bad grammar and promiscuous former presidents.

Them are ducks.

No them are not.

Yes them are. ...

M R Ducks.

No M R not.

S M R. Look at M webbed feet.

L I B !! M R Ducks.

I haven't thought about that since I lived...

Some of the questions of the day wind up being just trivia, not suggested best practices. But sometimes you stumble across some code that needs fixing and knowing...

Chris #2 is right. I've begun to rewrite some multiline functions as inline table functions and the difference in performance for large batches is astounding. ...

I'm just waiting for it to be listed in BOL. 😉

Easier than I thought it would be !!

Thanks, Simon.