declare @lastPensionMonth varchar(50) Select top 1 @lastPensionMonth = case when BMT_MONTH= '1' then 'jan' when BMT_MONTH= '2' then 'feb' when BMT_MONTH= '3' then 'mar' when BMT_MONTH= '4' then 'apr' when BMT_MONTH= '5' then 'may' when BMT_MONTH= '6' then 'jun' when BMT_MONTH= '7' then 'jul' when BMT_MONTH= '8' then 'aug' when BMT_MONTH= '9' then 'spt' when BMT_MONTH= '10' then 'oct' when BMT_MONTH= '11' then 'nov' when BMT_MONTH= '12' then 'dec' else 'Not started to take pension' end from Beneficiary_Monthly_Pension_Tran where BMT_Beneficiary_ID='000002316' order by bmt_year desc select @lastPensionMonth
else "Not started to take pension"
declare @lastPensionMonth varchar(50) SET @lastPensionMonth='Not started to take pension'
yes the issue is "Not started to take pension" use 'Not started to take pension'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)