Hi All,
Below is the table data
ID
122013
112013
102013
92013
82013
72013
62013
52013
42013
32013
12014
i tried with the below code but its not working
Declare @input int
select @input =ID from @tableVar
IF(COUNT(@INPUT) > 6)
BEGIN
SELECT LEFT(CONVERT(VARCHAR(10),ID), 2) AS MONTH , RIGHT(CONVERT(VARCHAR(10),ID), 4) AS YEARS FROM @TABLEVAR
END
ELSE
BEGIN
SELECT LEFT(CONVERT(VARCHAR(10),ID), 1) AS MONTH , RIGHT(CONVERT(VARCHAR(10),ID), 4) AS YEARS FROM @TABLEVAR
END
Am Getting the output as:
1 2013
1 2013
1 2013
9 2013
8 2013
7 2013
6 2013
5 2013
4 2013
3 2013
1 2014
please suggest me with better answer.