Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update empty value when preceding row is not empty
Message
De
03/02/2016 08:29:27
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Update empty value when preceding row is not empty
Divers
Thread ID:
01630642
Message ID:
01630642
Vues:
81
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform