This is a very short post. so bear with me. SELECT * FROM Northwind..Orders ORDER BY NEWID()The Magic here is NewID() Flickr Tags: NewID(), Random Records in MSSQL BuzzNet Tags: NewID(), Random Records in MSSQL Technorati Tags: NewID(), Random Records in MSSQL del.icio.us Tags: NewID(), Random Records in MSSQL IceRocket Tags: NewID(), Random Records ......