Viewing post 1 (of 1 total)
The Cursor has massive overhead.
Have you considered CTE and Ranking functions in a set based operation:
Ideally have an Index:
CREATE CLUSTERED INDEX idx_ID ON MyDB.dbo.Employees(ID);
Create a CTE that assigns...
May 22, 2012 at 3:18 am
#1490938