General information
Forum:
Microsoft SQL Server
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only