Viewing 2 posts - 1 through 2 (of 2 total)
Would love a copy of the book!
SELECT ROW_NUMBER() OVER(ORDER BY SalesYTD DESC) AS Row,
FirstName, LastName, ROUND(SalesYTD,2,1) AS "Sales YTD"
FROM Sales.vSalesPerson
WHERE TerritoryName IS NOT...
December 5, 2013 at 12:47 am
#1670932
How does the optimiser handle these querys/techniques vs standard methods?
December 2, 2013 at 4:48 am
#1670069