Help with random - sql server 2008 query

Posted by Gold on Stack Overflow See other posts from Stack Overflow or by Gold
Published on 2010-05-02T14:08:38Z Indexed on 2010/05/02 14:17 UTC
Read the original article Hit count: 154

Filed under:
|

hi

i have 4000 records, and i need to pick randomize 500 records.

i need that 500 records will insert to GoodTable

and the rest 3500 records will insert to BadTable

how to do it using sql-server 2008 query ?

thank's in advance

© Stack Overflow or respective owner

Related posts about sql-server-2008

Related posts about query