• Dear all,

    According to j.summers in http://www.sqlservercentral.com/Forums/Topic618362-32-1.aspx#bm841385

    Books OnLine for 2008:

    Tables per SELECT statement : Limited only by available resources

    More details on "Maximum Capacity Specifications for SQL Server" can be found here:

    http://msdn.microsoft.com/en-us/library/ms143432.aspx

    So now we could skip the UDF solution, and use nested views instead.

    Nice to know we have more options now.

    Best regards,

    Henrik