我是否需要使用可怕的sql server loop / cursor来获取我需要的结果集？

I need a sql server result set that "breaks" on a column value, but if I order by this column in a ranking function, the order I really need is lost. This is best explained by example. The query I'm currently experimenting with is:I need a sql server result set that "breaks" on