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