jwcolby
jwcolby at colbyconsulting.com
Fri Nov 5 13:04:35 CDT 2010
The order is fulfilled as soon as I get 540K, from wherever they might come from. John W. Colby www.ColbyConsulting.com On 11/5/2010 11:24 AM, Francisco Tapia wrote: > 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 >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >