Francisco Tapia
fhtapia at gmail.com
Fri Nov 5 10:24:53 CDT 2010
are you trying to select an even number of records within the 540k? or is the order fulfilled if the first group of records hits 540k? -Francisco http://bit.ly/sqlthis | Tsql and More... On Thu, Nov 4, 2010 at 7:51 AM, jwcolby <jwcolby at colbyconsulting.com> wrote: > I have a query where I need to select sets of records: > > (Children_0_3 and income in(XYZ)) > (Children_4_7 and income in(XYZ)) > . > . > etc. > (Age in (1,2) and income in (ABC)) > > I need to select the first group, then the next etc until I total 540K > records. > > Basically I need to select the records with something in any of the > Children_X_Y fields > and after that select from the last group. > > Is there a way to do that directly in SQL? > > > -- > John W. Colby > www.ColbyConsulting.com > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >