General information
Forum:
Microsoft SQL Server
Hi All:
I have a view containing numerous rows. One of the fields in my view is called ACCT. Some rows contain NULL value in the ACCT field. I need to know how to replace the NULL value with the previous row's value in the ACCT field in a reslut set of my view?
I.E
ACCT Order
---- -----
123 Shoes
876 Shirts
NULL Thread
I need to replace Null with 876.
Thanks for all of your help!!
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