You honestly think that is simpler than saying ORDER BY NEWID() ??
On Tue, Sep 21, 2010 at 10:34 AM, Samresh <[email protected]> wrote: > Why get so complicated. The numbers must be unique in the database. > Just get it in a dataset. Generate random number between 0 and the > number of rows in dataset, and select that row. > > On Sep 17, 8:35 pm, Naval sharma <[email protected]> wrote: >> hi >> thanks alot... >> now i have my ans. verry welll... >> really thank u verry much!!!!! >> >> >> >> On Fri, Sep 17, 2010 at 11:52 AM, shini gupta <[email protected]> wrote: >> > Hi Nawal, >> >> > I think it wud help u: >> > http://weblogs.sqlteam.com/jeffs/archive/2004/11/22/2927.aspx >> >> > On Fri, Sep 17, 2010 at 7:23 AM, Nawal <[email protected]> wrote: >> >> >> hi !!! all >> >> plz give me ans ..... >> >> it is related to sql querry. >> >> Question.--> select 10 number randomly in 100 no.'s database ???? >> >> plz give me ans if u know..... >> >> thanks in advance...
