I have two tables,

Database 1:

Table 1:

  • Id -001(int)

  • Name -xxx(varchar)

  • Male -0 (bit)

  • Female-1 (bit)

Database 2:

Table 2:

  • Id -1 (int)

  • Ca.Name-yyy (varchar)

  • Gender - M or F (varchar)

These are my tables. I want to update data from database2, Table 2 to database1, table1. So i create update query. But I have problem with Gender field

Select 'UPDATE T1
 SET T1.MALE ='+ CASE WHEN r.Gender = 'M' THEN 0 ELSE 1 END

 FROM T2 As r

In the below code, what I starred I have a doubt how to use if statement here. Any one understand rectify my problem?

Edit
Report