sql - Select random rows and stop when a specific sum/total is reached -

it asked compcobalt (for sql server 2012) via thread : select random rows , stop when specific sum/total reached

detail:

---

i'm using sql server 2012 , i'm trying this:

select sum(miles) tblname  mdate > = '03/01/2012' ,  mdate <= '03/31/2012'  -- and... /*     want add here until sum of miles     equal or greater '3250' ,     results rows randomly */ 

so in other words, want select random rows table have specified , date , stop when sum of miles @ or on number: 3250

---

but question how sql server 2000 ? thanks

this tricky question , can done. idea 1.give row number table. 2.then generate random numbers. 3.select rows of row_number , randomly generated number. 4. keep doing till sum with.

but issue sql server 2000 doesn't have row_number function take http://forums.asp.net/t/1630106.aspx/1

for generating random number plz see

"generate x digit random number in sql server 2008 r2"

good luck

please update me if of help

regards

ashutosh arya