16 tables limitgreenspun.com : LUSENET : SQL Server Database Administration : One Thread |
Eric,I was wondering if this is a bug in SQL Server6.5. I run a query from my PeopleSoft application and I get this error . It says:
"SQL error. Stmt #: 4192 Error Position: 0 Return: 8601 - [Micosoft] [ODBC SQL Server Driver][SQL Server] The query and the views in it exceed the limit of 16 tables. (SQLSTATE S1000) 4408"
If this is a bug, is there any patchwork or a workaround? Please advice. Thank you for your time. Praveer
-- Anonymous, December 14, 1998
Praveer,The best thing to do in this case is to use temporary intermediate tables. If you look at the SELECT statement grammar in Books Online, it accepts a maximum of 16 tables.
Eric
-- Anonymous, December 15, 1998