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
yes the issue is "Not started to take pension" use 'Not started to take pension'
else "Not started to take pension"
declare @lastPensionMonth varchar(50) SET @lastPensionMonth='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)