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
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