How update conditionbased column name in sql server?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

SQL

declare @Qtr int =1;
 update Appraisal_QtrUsers_Details  set ( case when @Qtr=1 then Q1AppseKRA_SubDate
 when @Qtr=2 then Q2AppseKRA_SubDate
  when @Qtr=3 then Q3AppseKRA_SubDate
  when @Qtr=4 then Q4AppseKRA_SubDate else null end )= null
  where user_id=9177

Posted 4-Aug-15 20:53pm

sushil7350

Add a Solution

Comments

Maciej Los 5-Aug-15 3:12am

?Could you be so kind and provide more details about your issue...
At this moment we have no idea about your issue.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suvendu Shekhar Giri · Answer 1 · 2015-08-04T21:45:00

Corrected sql is-

SQL

declare @Qtr int =1;
update Appraisal_QtrUsers_Details  
set  Q1AppseKRA_SubDate=(case when @Qtr=1 then null else Q1AppseKRA_SubDate end),
     Q2AppseKRA_SubDate=(case when @Qtr=2 then null else Q2AppseKRA_SubDate end),
     Q3AppseKRA_SubDate=(case when @Qtr=3 then null else Q3AppseKRA_SubDate end),
     Q4AppseKRA_SubDate=(case when @Qtr=4 then null else Q4AppseKRA_SubDate end)
where user_id=9177

The logic behind this query is if the column is not supposed to be updated with NULL value then just update it with the its current value and will not result in any value change.

Note: It would be better if you can share some business logic for this query so that it would be easier to suggest you more correct solution.

Thanks :)

How update conditionbased column name in sql server?

1 solution

Solution 1

Add your solution here

Preview 0

How update conditionbased column name in sql server?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us