Query Design using nTile(x)

Question

Post reply

Query Design using nTile(x)

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SwePeso SSC-Dedicated Points: 39758 More actions · Answer 1

SELECT TOP 50 PERCENT ?

N 56°04'39.16"
E 12°55'05.25"

noeld SSC Guru Points: 96590 More actions · Answer 2

There have been several post lately identifying poor performance with the ntile feature and some alternate methods have been proposed

ex: http://sqljunkies.com/WebLog/sqlbi/archive/2006/04/19/20482.aspx

Give that a shot!

Cheers,

* Noel

Glenn Wellington Grasshopper Points: 10 More actions · Answer 3

Yeah I just found that. tweaked it to what I want and I got buckets. Thanks a bunch. Was working on this for about a week and kind of sad that after 30 minutes of searching I found a solution.