Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts

Monday, December 8, 2008

Random results

This is related to sqlserver.
Our team recently completed a project for a Real estate company, for which we received thank-you letters and e-mails from very happy customers.we have stored this in a table.
we want to show this on page. We chose to display 10 notes, but we didn't want a fixed display because it would be boring and require maintenance. So, we opted to display 10 notes selected at random.

To do this just we have used a simple query which displays
different result at diffent times.

select top 3* from table name order by newid()