displaying message at certain time

<i><b>Originally posted by : rudi (andyrudolf@hotmail.com)</b></i><br />Hi,<br />I have some messages in my database and I need to show those messages at particular time ( or date) based on the value in the database.<br />How would my query look like in order to start showing the message(s) (Description) on my page at certain time (Starts) and stops at certain time too (Ends).<br /><br />I have the following 4 fields in the database:<br />MessageNo Description StartTime EndTime<br />Thanks a lot,<br />rudi<br /><br />

<i><b>Originally posted by : steve</b></i><br />Look into using the sql web assistant that comes with sql server. This isn't the most hi tech solution but it can push a new page based on a stored proc or a timed job.<br /><br /><br />------------<br />rudi at 8/13/2000 2:19:35 PM<br /><br />Hi,<br />I have some messages in my database and I need to show those messages at particular time ( or date) based on the value in the database.<br />How would my query look like in order to start showing the message(s) (Description) on my page at certain time (Starts) and stops at certain time too (Ends).<br /><br />I have the following 4 fields in the database:<br />MessageNo Description StartTime EndTime<br />Thanks a lot,<br />rudi<br /><br />