DonlSimpson (12/10/2014)
Matt Miller (#4) (12/10/2014)
sqldriver (12/9/2014)
Grant Fritchey (12/9/2014)
doesn't everything in sql server? 😉
Still trying to figure out what the use-case for multi-statement table-valued user-defined functions is. But, other than that, yes!
Their one use is for people to demonstrate why they're bad.
Let's not confuse the *need* or usefulness with the quality of the execution.
I'd think that there is a tremendous need to have a way to save a set of parameterized statements whose results can be invoked within SELECT statements. A "saved parameterized multi-statement query" would be a damn nice feature especially if it can be used inline. The piss-poor performance issue makes a FUNCTION unattractive for that purpose, but that doesn't negate the usefulness.
+1
Don't disagree, but as things stand they seem to just be consultant fodder.