Stored procedure for calculating time for every 5min

Posted by Vijay.Kumar under Sql Server on 9/5/2012 | Points: 10 | Views : 1102 | Status : [Member] | Replies : 1
hi i want procudure where i can count no times
using for loop that for every 5min
and having starttime and endtime

ex:- 10to11am
no of records and time

output willbe

10-11pm 20 trucks


Posted by: Vasanthmvp on: 9/6/2012 [Member] Starter | Points: 25

If im not wrong.. You can a do this by writing procedure to just select the values what ever you want.
Include Sql cache dependency,
Web.config file:

<sqlCacheDependency enabled="true">
<add name="DatabaseSample" connectionStringName="connstring" pollTime="500"/> // In poll time you can specify the time in milli seconds
Include an ajax control with update panel and timer set as 5 min.

If im wrong, please correct me.


Awesome Coding !! :)

Vijay.Kumar, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response