Dynamic SQL w/in a Table Valued Function?

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Sergiy SSC Guru Points: 110208 More actions · Answer 1

Read BOL topic "CREATE FUNCTION".

The only EXECUTE statement allowed inside of UDF is "EXECUTE statements calling an extended stored procedures".

"Statements not in this list are not allowed in the body of a function"

Sorry, you cannot have any dynamic SQL inside of a function.

_____________
Code for TallyGenerator

Robert Szymanski-440859 SSC Eights! Points: 957 More actions · Answer 2

Whoa, bummer.

Thanks for your response.

Bob

Regards,
Bob Szymanski
Blue Mule Software