16 Table limit in Query 
Author Message
 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
 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
 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
 
 [ 3 post ] 

 Relevant Pages 

1. 16 table limit in queries

2. 16 Tables involved in query Limit

3. Q: Limit of 16 tables in a query

4. 16-table Limit in SQL Queries

5. 16 table limit in a query

6. Query limit of 16 tables

7. 16 Table query limit

8. Check if query exceeds 16 table limit

9. 16 tables involved in a query limit

10. sybase limit of 16 on queries /tables

11. SQL Server 6.5 and 16 Table Limit

12. 16 table limit


 
Powered by phpBB® Forum Software