Nasty Fast PERCENT_RANK

Alan Burstein discusses a better performning alternative to PERCENT_RANK that works on SQL Server versions 2005+

NTILE

SQL Server Ranking Functions

A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.

Exploring SQL 2005’s Ranking Functions – NTILE() and ROW_NUMBER()

Part 20 of the "SqlCredit – Developing a Complete SQL Server OLTP Database Project" examines SQL 2005’s NTILE() and ROW_NUMBER() Ranking Functions.

RE: composite rights using msas dimension security

To clarify, is this only one user who needs to be looking at all stores but only two vendors, but when focusing on vendors he/she can see them all but only two stores? Or is it two different users, one of which can see all stores but only two vendors; the other can see all […]

RE: Help us Improve our Logo

I'm sorry - they're all bad.  The 3D graphics thing is old, outdated, a fad passed by, etc.Get rid of the cube, whatever it's supposed to be - stick with flat text and the arch, but maybe update the color-scheme and definitely the fonts.While you're changing the logo, go ahead and change the font of […]

RE: Job fails because remote server insert fails. Need testing method.

Any other ideas folks? Thanks in advance.

RE: Need syntax help

OK, I'll try It is this what you are looking for?SELECT h.ItemNo, l.MaxOH - SUM(ISNULL(p.PQty,0)) AS QtyReq, 'Rush - 4 Weeks' AS TimeFrame FROM ITEM_H h LEFT JOIN INV i ON h.ItemNo = i.ItemNo  LEFT JOIN PID p ON i.PID = p.PID  LEFT JOIN INV_LVLS l ON h.ItemNo = l.ItemNo WHERE h.ItemCat = 'RM' GROUP […]

RE: Column name lookup

Oops - went horizontal when you wanted vertical DECLARE @colName VARCHAR(30) DECLARE enabledCol CURSOR FOR SELECT columnname from TABLE WHERE ENabled OPEN enabledCol FETCH NEXT FROM enabledCol INTO @colName WHILE @@FETCH_STATUS = 0 BEGIN SET @selSQL = 'SELECT ''' + @colName + ''' ColName, ' + @colName + ' colValue FROM <sourcetable> where <condition> EXEC […]

RE: Effecient decimal precision and storage

Reaction time does not matter as their other tecnologies act on a lag that my Grandmother couldn't stand - so it's free form. However, My current system runs like the wind and can calculate and serve formatted HTML for 20 funds, 9 time series(Daily, Week To date, Month to date...), for a five year period […]