dalmat36/ROW_NUMBER

## ROW_NUMBER
/*ROW_NUMBER() Window function assigns
unique incrementing integers to rows */
SELECT orderid, custid, val, ROW_NUMBER() OVER (PARTITION BY custid ORDER BY val) AS rownum
FROM Sales.OrderValues
ORDER BY custid, val;

## TSQL Fundamentals 2012 CH2
stuff
	/*ROW_NUMBER() Window function assigns
	unique incrementing integers to rows */
	SELECT orderid, custid, val, ROW_NUMBER() OVER (PARTITION BY custid ORDER BY val) AS rownum
	FROM Sales.OrderValues
	ORDER BY custid, val;