Conditional SQL Server query

Question

I need to move some data from one DB to another but as the layout is not the same, I need a to add a condition to this:

If Genderbit == 1 (from CRM.dbo.Person), a string 'M' should be inserted into ewa.Ansprechpartner.Gender, else a string 'F' should be used.

USE easyWinArtTest
GO

INSERT INTO ewa.Ansprechpartner(Vorname, Nachname, Email, Telefon, Telefax, Gender)
   SELECT Forename, Surname, EMailAddress, Phone, Fax, [genderbit]
   FROM CRM.dbo.Person

How is this done with SQL Server?

marc_s · Accepted Answer · 2014-05-21 07:47:20Z

3

Try this:

INSERT INTO ewa.Ansprechpartner(Vorname, Nachname, Email, Telefon, Telefax, Gender)
   SELECT 
       Forename, Surname, EMailAddress, Phone, Fax,
       CASE [genderbit]
          WHEN 1 THEN 'M'
          ELSE 'F'
       END
   FROM 
       CRM.dbo.Person

Use a CASE statement, based on the Genderbit column - if it's 1 then use M to be inserted, else F

answered May 21, 2014 at 7:47

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

marc_s Over a year ago

@861051069712110711711710997114: decades of practice :-)

shree.pat18 · Accepted Answer · 2014-05-21 07:53:37Z

0

You can use a case statement in the select query to do the conditional substitution like so:

USE easyWinArtTest
GO

INSERT INTO ewa.Ansprechpartner(Vorname, Nachname, Email, Telefon, Telefax, Gender)
SELECT Forename, Surname, EMailAddress, Phone, Fax,Case when genderbit = 1 then 'M' else 'F' end
FROM CRM.dbo.Person

edited May 21, 2014 at 7:53

answered May 21, 2014 at 7:48

shree.pat18

21.8k3 gold badges45 silver badges65 bronze badges

Collectives™ on Stack Overflow

Conditional SQL Server query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related