Posts
Sort by recent activity
GROUP BY suggestion incorrect for query containing FIRST_VALUE
CREATE TABLE #deleteme (
id INT
,value1 INT
)
SELECT
id
,FIRST_VALUE(id) OVER (ORDER by value1 DESC) AS foo
FROM #deleteme
GROUP BY FIRST_VALUE(id) OVER (ORDER BY value1 DESC), id -- what S...
Problems installing to IIS 8
I get a 404 when attempting to connect to localhost:8081; here's some error info:
Module: IIS Web Core
Notification: MapRequestHandler
Handler: StaticFile <-- isn't that wrong?
Error Code: 0x80070...