Ok I've added a complaintID column so now I've got

complaintID INC CaseID Status
1 N 122303 Open: Investigation
2 NULL NULL NULL
3 NULL NULL NULL
4 NULL NULL NULL
5 N 122331 Open: Investigation

Thanks



>you have to add a column when importing that include that, IDENTITY for example. Otherwise there is no row order in SQL Server
>
>>
>>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