SQL Update Query With inner Join and case — Sql Server — ASP.Net Example
ASP.Net Example-SQL Update Query With inner Join and case

Tuesday, April 5, 2011

SQL Update Query With inner Join and case

tblEMp

EmpID

Name

Salary

DepID

1

Sachin

1000

1

2

Mahora

2000

2

3

Afridi

3000

1

tblDep

DepID

DepName

1

D1

2

D2
Now

Now Question is Update Salary with 10% where DepName is D1.and 20% where DepName is D2. Use Join and Single Query Only.
Ans:-  update tblemp set Salary = Case tbldep.lname
           when 'D1' then Salary +(Salary*0.10)
          when 'D2' then Salary +(Salary*0.20)
          end
           from tblemp join tbldep on tblemp.depid=tbldep.depid

No comments:

Post a Comment

ASPdotNET-Example