Write recursive t-sql code to fill missing Salary for employee using Average for the Department.

There’s a table with below data

Write a query which will give below output.

Query:

Declare

@v_Employee as table(DeptID int, EmpNo int, Salary decimal(18,2))

Insert into @v_Employee values(1,1,1000)

Insert into @v_Employee values(1,2,null)

Insert into @v_Employee values(1,3,3000)

Insert into @v_Employee values(2,4,4000)

Insert into @v_Employee values(2,5,null)

Insert into @v_Employee values(2,6,6000)

Insert into @v_Employee values(2,7,7000)

Select * From @v_Employee

Select

T.DeptID,

EmpNo,

Case when Salary is not null then Salary else AvgSalary end

From

(

 select
 DeptID,
 avg(Salary) as AvgSalary
 from
 @v_Employee
 Group By
 DeptID
) T
inner join @v_Employee E on E.DeptID = T.DeptID