Recent content by jarkkonen

Hello, need advice for adding leading zeros to concatenated ..... CAST(VarastoTapahtumaKk_0.Vuosi as varchar(6)) + CAST(VarastoTapahtumaKk_0.Kuukausi as varchar(6)) AS 'YM' this returns 'YM' as 20109 as I need 201009, if month is 12 it returns allright 201012... below whole sql...