>Thanks Sergey.
>
>This has come in from a spreadsheet and its in (I guess) row number order
>
>>You have to define row ordering in terms of data first. Right now I don't see one.
>>
>>>I've imported a table and some of the rows have blank values
>>>
>>>I want to update the empty values of CaseID with the preceding value so in this example all the NULL CaseID will be 122303.
>>>I don't mind about the other columns its just the CaseID I want
>>>
>>>
>>>INC CaseID Status
>>>N 122303 Open: Investigation
>>>NULL NULL NULL
>>>NULL NULL NULL
>>>NULL NULL NULL
>>>N 122331 Open: Investigation
>>>
>>>
>>>Any suggestions on some SQL to do that ?
>>>
>>>Thanks
>>>
>>>Nick
There is no such thing as Row number in SQL Server.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.