case in joins

[praveen556]

Hi All,

I am trying following case statement in where clause but it shows
line 2:incorrect syntax near"=" state:42000.
Any one please helpme i am trying this from past 2 weeks

CASE 
WHEN 
(Surveillance.dbo.Deal_Hdr.Sector = 'MBS'  OR  (Surveillance.dbo.Deal_Hdr.sector='ABS'  AND  Surveillance.dbo.Deal_Hdr.sic_Secno='HOMEEQUITY'))
THEN 
(dbo.Deal_Underwriting_Info.COLLATERAL_TYPE_ID = dbo.MBS_Collateral_Types.COLLATERAL_TYPE_ID)
WHEN  
Surveillance.Deal_Hdr.sector='ABS' 
THEN  
dbo.Deal_Underwriting_Info.ABS_COLLATERAL_TYPE_ID = dbo.ABS_Collateral_Types.COLLATERAL_TYPE_ID
ELSE
NULL
END
 

Thanks

Praveen.S

[amitpatel66]

Hi All,

I am trying following case statement in where clause but it shows
line 2:incorrect syntax near"=" state:42000.
Any one please helpme i am trying this from past 2 weeks

CASE
WHEN
(Surveillance.dbo.Deal_Hdr.Sector = 'MBS' OR (Surveillance.dbo.Deal_Hdr.sector='ABS' AND Surveillance.dbo.Deal_Hdr.sic_Secno='HOMEEQUITY'))
THEN
(dbo.Deal_Underwriting_Info.COLLATERAL_TYPE_ID = dbo.MBS_Collateral_Types.COLLATERAL_TYPE_ID)
WHEN
Surveillance.Deal_Hdr.sector='ABS'
THEN
dbo.Deal_Underwriting_Info.ABS_COLLATERAL_TYPE_ID = dbo.ABS_Collateral_Types.COLLATERAL_TYPE_ID
ELSE
NULL
END


Thanks

Praveen.S

Try this:

 
CASE 
WHEN 
(Surveillance.dbo.Deal_Hdr.Sector = 'MBS'  OR  (Surveillance.dbo.Deal_Hdr.sector='ABS'  AND  Surveillance.dbo.Deal_Hdr.sic_Secno='HOMEEQUITY'))
THEN 
(dbo.Deal_Underwriting_Info.COLLATERAL_TYPE_ID = dbo.MBS_Collateral_Types.COLLATERAL_TYPE_ID)
CASE WHEN  
Surveillance.Deal_Hdr.sector='ABS' 
THEN  
dbo.Deal_Underwriting_Info.ABS_COLLATERAL_TYPE_ID = dbo.ABS_Collateral_Types.COLLATERAL_TYPE_ID
ELSE
NULL
END
 
 

[praveen556]

HI Amit,

Thanks for your reply.
I had tried that but no use.
It is showing same error.

I had one doubt can i use above query in where clause


Thanks