palotaiarpad (4/26/2015)
If we assume, that we have the latest SQL Server Version (2014), then an over by is required according to BOL (I can't try it yet)
Others have shown BOL to be incorrect, so I'll just address the version question. If you remove the FORMAT function, you should be able to run the queries in SQL 2008.
Nice question. Thanks.