LOL! I should have known Paul would show a CROSS APPLY.

I HAVE to start thinking... can this be done with a CROSS APPLY? I just don't consider it.

I also...

Instead of passing all those dates to the database to be added in one at a time, why don't you make a stored procedure and pass just the starting and...

see http://msdn.microsoft.com/en-us/library/ms186734.aspx

and http://www.sqlservercentral.com/articles/T-SQL/69717/

lmu92 (5/14/2010)

krenshau (5/14/2010)

Try this link.

Since you're...

elutin (5/14/2010)

SELECT *

FROM (SELECT ROW_NUMBER() OVER (PARTITION BY PropID

ORDER BY LatestApptDate desc ) AS PARowNumber

,PrevApptID

...

I like Manu's suggestion.

Doing something like this, deleting large # of records without affecting up-time or users, is one of the few things that are best done in a loop,...

I think it was just right, Gail!

Here's two methods to accomplish this:

-- See how you start off by actually creating a table

-- and then inserting the data into it? Doing this really

-- makes things a...

Stefan Krzywicki (5/14/2010)

Maybe if there were another page that lists more of the...

Check out ROW_NUMBER().

And read my article[/url] on how to use the row_number ranking function.

Mine is similar to Goldie's. Main difference is that the IncidentType column has the desired text (instead of the column name), and it is sorted according to the sort order...

WayneS (5/12/2010)