LOL.

Microsoft have made it such a long winded process for BI developers to set up a local environment. I have recently bought a new laptop and it took me...

Very simple example of how to use the OVER clause:

SELECT

Year(OrderDate),

ROW_NUMBER() over(Partition By Year(OrderDate)order by OrderDate) as RowNum,

*

FROM [Northwind].[dbo].[Orders]

ORDER...