MS SQL Server 6.5 16-table limit

Article View: bit.databases.mssql-l

Article #235

Back to bit.databases.mssql-l Previous Next

#235

From: Larry Mehl
Date: Fri, 10 Sep 1999 00:00

25 lines
1382 bytes

16-table limit

Our Crystal report is based on a view of 6 queries; the queries are
based on a total of 38 tables.  The report works on the ACCESS and
Oracle implementations of the database, but not on SSrvr 6.5, because
of its 16-table limit.

We can't get around the limit by setting up an ACCESS front-end to the
SQLSrvr database and reporting on ACCESS queries.

A workaround is to INSERT INTO 3 empty 'holding' tables for the query
data, and then INSERT INTO an empty reporting table from those 3
holding tables.

We prefer to have Crystal prompt the user for filters, but that would
come after the reporting table was created, and the resulting
reporting table will become unnecessarily large over time.

Does any reader have a suggestion for dealing with the 16-table limit?
SQLSrvr 7's 32-table limit will present the same problem.

We will appreciate any suggestions.

Larry Mehl
lmehl@goselecttech.com

Technical Details

Message-ID: <37d94031.781318486@news.supernews.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,73de2887ce161e11,start
X-Google-Attributes: gidf6611,public
From: lmehl@goselecttech.com (Larry Mehl)
Subject: MS SQL Server 6.5 16-table limit
Date: 1999/09/10
Message-ID: <37d94031.781318486@news.supernews.com>
X-Deja-AN: 523487505
Organization: Posted via Supernews, http://www.supernews.com
Newsgroups: bit.databases.mssql-l
X-Complaints-To: newsabuse@supernews.com