Careful LinksUp, don't depend on the ID column as there is no guarantee that it is the correct order.
😎
I had fully intended to use the ChangeDate as ordering, but then I had to change some of the dates to get them in MDY format. Like I said before, it was easier to change the date them look up the proper set command!
Your use of Convert was clever!
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/