A very simple way to select top X random rows from a table/query or select rows in a truly random order. The key is using a GUID. SELECT TOP X * FROM SomeTable ORDER B Y NewID () That Simple!
Two Plus One Is Us! Initially started out as a title for our family blog, it didn't take long to realize that when you blog, other person reads and a third person comments you essentially have a small group that is contributing to a meaningful discussion resulting in enrichment of minds and problem solving. That small group is Us.