Monday, May 17, 2010

Increasing value as Serial number in sql

select ROW_NUMBER () OVER (ORDER BY min([Date])) AS rowNum, FiscalMonthName from bom_calendar where FiscalYear=2010 Group by FiscalMonthName Order by min([Date])