ConCat DateTime

select FullDateAlternateKey,

str(YEAR(FullDateAlternateKey))+
RIGHT('00' + (CAST(datepart(mm, FullDateAlternateKey)AS NVARCHAR(2))), 2)+
RIGHT('00' + (CAST(datepart(dd, FullDateAlternateKey)AS NVARCHAR(2))), 2)from DateWorkingDimension