Leifa and David hit the nail on the head... well done.

Unless you want the log to remember that you deleted 200 million rows, DELETE is NOT the way to go...

TRUNCATE is absolutely the fastest way to empty a table, without...

Sounds a little whacked but with 250 columns, might not be as whacked as you think... copy the columns in the SELECT list...

Just a reminder to everyone that may try... ISQL is deprecated when compared to OSQL.  OSQL gives you the full functionality of SQL Server... ISQL does not.  Recommend that you...

CS,

Post the table schema and some example data (hopefully in the form of INSERTs) and I'll give you a dog'n'pony...

The problem is that carriage returns mean nothing in HTML... your app has to capture user induced line breaks as <br> in order for them to mean anything in HTML.

Michael,

That means that, using Sreejith's fine example, your code should look something like this...

I'm just gonna take a guess and say that you didn't actually try it Gopi... works fine from what I can see...

stor_id stor_name             stor_address          city         state zip  

-------...

Sorry... missed the fact that you used "9" as the starting point in the CHARINDEX...

Works great if the prefix is always "Watch" or some other combo of 5 letters... if...

Shoot... these type of paging routines are so much easier in 2005 with TOP @variable...

I see what you mean, now... I gotta do some tweekin' because page 0 now sets ROWCOUNT = 0 and the last page takes forever... I'll let you know what...

Haven't tried any of this using a temp table... what changes do you suggest?

Almost forgot... the routine starts with PAGE 0... you can certainly "fix" that by subtracting 1 for the page parameter or by passing in a pre-decremented page number.

Not sure about the performance of your proc but the following will return the first page of 100 almost instantly and returns the 12,000th page of a 40 column, 1.2 million...

One measurement is worth a thousand words... also I tried to make some unique table names, be careful folks... this test does delete some tables... didn't want to run anyone's...