Case Statement SQL 2008 Issue

I have the following Case Statement:

Case When PCYTD_1.PC_YTD - PCB_1.PC_Base >= dbo.tblPIF_Size.Goal_PC Then Dense_Rank() Over (partition by PCB_1.Terr Order By PCYTD_1.PC_YTD - PCB_1.PC_Base desc) Else 0 End as Rank

It states that When a total ( PCYTD_1.PC_YTD - PCB_1.PC_Base) is >= to a Goal then Rank that result. Otherwise (Else) show 0.

HOWEVER I do NOT want the 0 I want the 0 to be 'NOT MET'

My problem is that I have a data type issue as the first parts are int and my else would be char. I tried to Cast, but no luck.

Can someone asssit. Thank you.

SeTech

Asked: 2011-09-29

Advertise Here

Microsoft SQL Server 2008

1 Solution

LVL 15

EyalCommented: 2011-09-29

try this

Case When PCYTD_1.PC_YTD - PCB_1.PC_Base >=  dbo.tblPIF_Size.Goal_PC Then  cast(Dense_Rank() Over (partition by PCB_1.Terr Order By PCYTD_1.PC_YTD - PCB_1.PC_Base desc) as nvarchar)     Else 'NOT MET' End as Rank

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Expand your skills with this month's free Premium course.

Case Statement SQL 2008 Issue

Join & Write a Comment Already a member? Login.

Featured Post