Posted by laurenq uantrell on 12/17/05 09:04

Wondering if there is a physical or realistic limitation to the number
of UNION statements I can create in a query? I have a client with
approx 250 tables - the data needs to be kept in seperate tables, but I
need to be filtering them to create single results sets. Each table
holds between 35,000 - 150,000 rows. Should I shoot myself now?

lq

• Next in forum: Re: Maximum UNION statements in a query
• Prev in forum: Re: SQL Best Practices Analyzer Rule: Use of Schema Qualified Tables/Views
• Thread view: Maximum UNION statements in a query

[Reply to this message]