16 Table query limit 
Author Message
 16 Table query limit

I get the message:

Msg 4408, Level 19, State 1
The query and the views in it exceed the limit of 16 tables.

Is there any way of increasing this limit?  If not, what is the best way to
handle large queries?

Tim Anderson




Fri, 10 Mar 2000 03:00:00 GMT
 16 Table query limit

There's no way to increase it.  Pre-join some tables into a temp table &
then join into the temp table.
--
Richard Waymire, MCT, MCSE, MVP (SQLServer)
Principal Engineer, ARIS Corp.
President, Pacific NW SQLServer Users Group (http://www.pnwssug.org)
Visit us at http://www.aris.com



Quote:
> I get the message:

> Msg 4408, Level 19, State 1
> The query and the views in it exceed the limit of 16 tables.

> Is there any way of increasing this limit?  If not, what is the best way
to
> handle large queries?

> Tim Anderson





Fri, 10 Mar 2000 03:00:00 GMT
 16 Table query limit

May I suggest that you re-organise your tables in the database, so that you
will never need to join more than 16 of them.

GWA



Fri, 17 Mar 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. 16 Tables involved in query Limit

2. Q: Limit of 16 tables in a query

3. 16 Table limit in Query

4. 16-table Limit in SQL Queries

5. 16 table limit in queries

6. 16 table limit in a query

7. Query limit of 16 tables

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