How do you write an IF ELSE inside a SELECT statement in MSSQL 2008?

Question

Here is what I am trying to do:

SELECT iif(d.ItemType = 'INVOICE', 0, iif(d.ItemType = 'PACKING', 0, 1)) AS MissingDocuments FROM dbo.DocumentDetails AS D

Unfortunately realized this is not compatible with MSSQL2008. So tried writing an IF ELSE but that also is not working.

SELECT  IF d.ItemType = 'INVOICE'
   0
ELSE 
   BEGIN
      d.ItemType = 'PACKING'
      0
   ELSE
      1
   END  AS MissingDocuments
FROM  dbo.DocumentDetails AS D

can you please tell me what am I doing wrong here ?

use CASE. CASE WHEN d.ItemType IN ('INVOICE','PACKING') THEN 0 ELSE 1 END — ughai
– ughai, Commented May 19, 2015 at 5:39
you're missing if statement in your else block. There is no corresponding if for your nested else — Sachin
– Sachin, Commented May 19, 2015 at 5:41
possible duplicate of stackoverflow.com/questions/4622/sql-case-statement-syntax — ughai
– ughai, Commented May 19, 2015 at 5:42
@ughai You should have posted an answer...those points could have been yours! — Tim Biegeleisen
– Tim Biegeleisen, Commented May 19, 2015 at 5:47
@TimBiegeleisen - As long as OP gets an answer and the question gets closed, it's all good. :) — ughai
– ughai, Commented May 19, 2015 at 5:52

StuartLC · Accepted Answer · 2015-05-19 05:41:17Z

7

Use CASE ... WHEN. The most concise logic seems to be:

SELECT 
  CASE WHEN d.ItemType IN ('INVOICE', 'PACKING') THEN 0 ELSE 1 END
     AS MissingDocuments 
FROM dbo.DocumentDetails AS d

i.e. the Document is missing if it isn't 'Invoice' or 'Packing'

answered May 19, 2015 at 5:41

StuartLC

108k18 gold badges225 silver badges295 bronze badges

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

Comments

Dhaval · Accepted Answer · 2015-05-19 05:41:45Z

2

I think You Looking For Case When Try This..

SELECT 
 case when d.ItemType = 'INVOICE' or d.ItemType = 'PACKING'
 then  0
 ELSE
  1
 END  AS MissingDocuments
FROM  dbo.DocumentDetails AS D

answered May 19, 2015 at 5:41

Dhaval

2,3791 gold badge15 silver badges16 bronze badges

Collectives™ on Stack Overflow

How do you write an IF ELSE inside a SELECT statement in MSSQL 2008?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related