-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Star_Venkat
Message 1 in Discussion
Problem statement: I want to fetch 10 rows( specifically 10th to 20th
row) in the result set irrespective of the query and irrespective of the where
condition. Possible answer to achieve this in sql server 2000: In sql
server 2000, we used to fetch all the rows in the table and insert the same in
a new table with an additional identity column. Afterwards, i can fetch the
specific rows using identity column values. Possibility with sql server 2005:
Its not the case in sql server 2005, we can achieve it using rownumber()
function. Please check my blog for more information on Rownumber() function.
Provide me your valuable feedback too :-) Regards, Venkatesan Prabu . J
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_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]
