evidently confused on temp table scope

  • 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.

Viewing post 31 (of 30 total)

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