----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: SriSamp Message 9 in Discussion Hi Srivats, Yes, you can use a CURSOR along with FETCH RELATIVE to work around this problem, but in involves a lot of structured code, which SQL is not good at. SQL is more oriented towards set oriented queries. That said, you could solve this issue by copying over the rows from the required table onto a new temporary table and along the way introduce an IDENTITY column on the same. Then use a function like MOD (as mentioned in the earlier posts) to get the alternate rows. Here is an example from the authors table. -- Drop the temporary table DROP TABLE #tempAuthors GO -- Create the temporary table by inserting the row number SELECT IDENTITY(INT, 1, 1) rowNum, au_id, au_lname INTO #tempAuthors FROM authors GO -- Verify the output SELECT * FROM #tempAuthors GO -- Select the alternate rows SELECT au_id, au_lname FROM #tempAuthors WHERE (rowNum % 2) > 0 HTH, Srinivas Sampath MVP - SQL Server http://www32.brinkster.com/srisamp ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
