You add an identity column to hold ordering in the same positions they're already stuck in. Then you modify a few things like maxdop to make sure you don't shoot your ordering in the foot.
Then you would do a 'running totals' trick to get the last value to the next row. See this article for some details:
What it basically does is carry the previous entry to the next line, allowing you to transfer it over. So you'll end up with a statement (this is psuedocode) like this:
DECLARE @carryme VARCHAR(1000)
@carryme = NullableCol = @carryme
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]