Home Forums SQL Server 2005 Business Intelligence Split yearQuarter RE: Split yearQuarter
rxm119528
SSCrazy
Points: 2960
More actions
September 8, 2014 at 9:10 am
#1743891
Add 2 derived columns and use the expressions
RIGHT([yearquarter],2 )
LEFT([yearquarter],4 )
Just realized there is not left function is SSIS
better use the substring
SUBSTRING("2014Q3",5,2)
SUBSTRING("2014Q3",1,4)