select cast(
(
left(('2012-05'),4)
+right(('2012-05'),2)
) as int
)
SELECT CAST(LEFT(CONVERT(VARCHAR(8),GETDATE(),112),6) AS INT)
(
left(('2012-05'),4)
+right(('2012-05'),2)
) as int
)
SELECT CAST(LEFT(CONVERT(VARCHAR(8),GETDATE(),112),6) AS INT)