MS SQL Server, 16 Table limit in Query

16 Table limit in Query

Author	Message
David Bratto #1 / 3	16 Table limit in Query Quote: > One of our developer is using a query which uses more than 16 > tables(some are views). He get a error message that the max limit of 16 > table exceeded. Does anyone ran into this problem ? > -Guna You can get around the 16 table limit by using temporary tables for intermediate result sets.
Fri, 05 Nov 1999 03:00:00 GMT

Guna Govindaswam #2 / 3	16 Table limit in Query One of our developer is using a query which uses more than 16 tables(some are views). He get a error message that the max limit of 16 table exceeded. Does anyone ran into this problem ? -Guna
Fri, 05 Nov 1999 03:00:00 GMT

Tony Scandora 630-252-75 #3 / 3	16 Table limit in Query Quote: >One of our developer is using a query which uses more than 16 >tables(some are views). He get a error message that the max limit of 16 >table exceeded. Does anyone ran into this problem ? >-Guna 16 is really the max, and you can not use views of views to beat the limit. You can use temporary tables within SQL Server, or if you are using Access, you can define lower level views using <= 16 tables in SQL Server, and then define Access queries joining SQL Server views. It's not pretty, but it works for me. Tony Scandora, Argonne National Lab, 630-252-7541
Sun, 07 Nov 1999 03:00:00 GMT

Page 1 of 1

[ 3 post ]