I want to get the previous row value in a particular column if it is blank. How can I do this may be using lag function. create table [test].[dbo].[test]( CusName nvarchar(50) NULL, Value INT NULL) -- Insert some data insert [test].[dbo].[test] (CusName, Value) values ('CustomerA', 151), (''…

As mike01 noted, we must know the order of data. I've added an identity column to the table to provide an order. I also added more rows so that the same cust name appearing multiple times could be tested. create table [dbo].[test]( id int identity(1, 1) NOT NULL, CusName nvarchar(50) NULL, Value …

Get data from previous row if a particular column is blank

Transact-SQL

Ifor January 31, 2020, 5:22pm 10

What makes you think a relation/table has an order?

Showing results of one column into two columns