>Hi Cetin,
>
>for me GETDATE(),NEWID() is good, but RAND() no.
>
>Example:
>
>On MSQL:
>
>Table ( id INT IDENTITY, Name VARCHAR(50), dateStart DATETIME )
>
>no index on dateStart and 1 Million of rows.
>
>I want 5, flat random id, valid today ( i can insert future valid name ).
>
>The query run at 23:59:59.5 ( i am a night worker )
>
>SELECT TOP 5 * FROM Table WHERE dateStart< =GETDATE() AND id=CONVERT(INT,RAND(1)*1000000)
>
>GETDATE() is good but RAND() no;
>convert NEWID() to integer flat random is not simple.
>
>Fabio
I surrender. Having a hard time to understand.
Cetin