Dear all,

i have a database full of Tips and Tricks.

each subject in my database has one or more related rows in the tips tbl.

on my application startup i need to show a random tip each time.

if i have a resultset of 8 rows for a defined subject, how can i make my application randomely choose one row to display.

The solution must retrieve the data of one row only , because it is a web application so it will be very slow to retrieve the whole tips rows in order to select one.

also i need it as i mentioned before to display random tip each time it starts.


just like the Visual studio AD Rotator but in access of database and not different files.

this is challenging, isn't it ??

inlight me Experts ....


thx in advance