I was trying to execute a new query where I need the Row number as a new column on the result itself. I used the SQL Function ROW_NUMBER()
to get the row number.
Following query gives the Report Path with the HitCount along with the added Row Number.
select ROW_NUMBER() OVER(ORDER BY count(ReportPath) DESC) AS 'Row Number', ReportPath,count(ReportPath) as HitCount
FROM [ReportServer].[dbo].[ExecutionLog2]
Group by ReportPath
Order by HitCount desc
Cheers !
Friday, November 18, 2011
Get the Row Numbers as a separate column on MS SQL Query
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment
I love to entertain onymous user Comment !