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

    #1614234

    memymasta (5/10/2013)

    I'm having trouble creating a simple derived table. It is so simple to create a derived table with multiple columns with:

    SELECT 1,2,3

    Feels like it shouldn't be much more difficult to create a derived table with one column and multiple tuples/rows.

    Is there a way to get following result without creating a temp table or specifying the whole DDL:

    derived table

    1

    2

    3

    Thanks

    There is a limit to how many rows you can do this way, but here is one:

    select * from

    (select n from (values (1),(2),(3))dt(n))dt1;