Home Forums SQL Server 2005 SQL Server 2005 General Discussion create table valued function RE: create table valued function

  • July 28, 2013 at 1:46 pm

    #1636490

    SQL_Surfer (7/28/2013)

    Can you give me some pointers of rewriting this query? Can data be grabbed at 1 shot instead of doing UNION ALL.

    I think so. Post the whole query and we'll see.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]