General information
Forum:
Microsoft SQL Server
>>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.
If I open the table (edit top 200 rows) its the order I can see the rows in.
Thanks
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