Home Forums SQL Server 2008 T-SQL (SS2K8) how to get current year RE: how to get current year

  • September 18, 2012 at 5:36 pm

    #1539328

    John Mitchell, I see that the solution works. It's nice. I understand CTE and 'PARTITION BY YEAR(OrderDate)' etc., but will you please explain why 'PARTITION BY 1'?

    --Quote me