Home Forums SQL Server 2008 SQL Server 2008 - General Weird Requirement... Multiple Left Joins? Am I missing something? RE: Weird Requirement... Multiple Left Joins? Am I missing something?

  • August 28, 2012 at 1:23 pm

    #1531043

    GSquared (8/28/2012)

    CptCrusty1 (8/28/2012)

    Laurie,

    Thanks for your reply. The "Values" reserved word didn't fly in 2005. Is that a 2008+ term?

    Thanks

    Crusty

    That's what's called a "Table Values Function", and it's 2008+. It will also only work with data that's limited to no more than 9 values per set.

    Just for the record, this example is limited to 9, but you can code the numbers table up to any number.