Like starting from 200 and going to 300. ~Lori ----- Original Message ----- From: "Eric Creese" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, January 18, 2005 1:54 PM Subject: RE: MySql to Sql Server Convert LIMIT
> LIMIT like the number of records you return???? If so SQL server has TOP [number of records]. Not sure if that is what you are looking for? > > -----Original Message----- > From: Lori [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 18, 2005 12:51 PM > To: CF-Talk > Subject: MySql to Sql Server Convert LIMIT > > > Anyone have any ideas of the best way to do a LIMIT in Sql Server? I know > sql server does not have an equivalant. I have an idea of what I want to do > but wanted to get other ideas too. > > ~Lori > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190971 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
