SQL equivalent of MS Access Partition function

Question

I use Partition function lot for Report in MS Access 2003. I need equivalent of this function for MS SQL.

Here is link about Partition function http://office.microsoft.com/en-us/access/HA012288921033.aspx (registration required)

Thanks

Answer 1

The closest thing I can see is the NTILE function, though without a little more context on how you use it, I can't offer anything in the way of a code sample.