Incremental column in select statement.

SELECT ROW_NUMBER() OVER (ORDER BY [Date] ASC) AS ROWID

,month([Date]) as Dt

FROM [TestChartDB].[dbo].[bom_Calendar]

Where FiscalYear=2010

Order by [Date]