Information générale
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement