Your question is not about splitting column, rather it is about generating the 3-letter month name that are 6 months away from the current month values in the month column.
first, take a month string, e.g. 'Jan', turn it into month number => 1 and add 6 to it => 7 like this:
select (DATEPART(MM, 'Jan' + ' 01 2008') + 6)
next, convert the month number into some old date => July, 01 2008 00:00:00+0000, like this:
select DATEADD(MONTH, (DATEPART(MM, 'Jan' + ' 01 2008') + 6) - 1, CAST('2008-01-01' AS datetime))
Finally, we are only interested in the new 3-letter month of the date, so do this:
SELECT Convert(char(3), DATEADD(MONTH, (DATEPART(MM, 'Jan' + ' 01 2008') + 6) - 1, CAST('2008-01-01' AS datetime)))
Understand this then you should be able to work out the solution to your question yourself using simple select query.
Submit an article or tip