Home Forums SQL Server 2008 T-SQL (SS2K8) Simple derived table with multiple rows RE: Simple derived table with multiple rows

  • May 10, 2013 at 9:39 am

    #1614233

    Two possibilities, I'm sure there are more

    SELECT 1 AS col

    UNION ALL

    SELECT 2

    UNION ALL

    SELECT 3

    SELECT col

    FROM (VALUES (1), (2), (3)) x(col)

    ____________________________________________________

    Deja View - The strange feeling that somewhere, sometime you've optimised this query before

    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537