Stored procedure for calculating time for every 5min

Posted by Vijay.Kumar under Sql Server on 9/5/2012 | Points: 10 | Views : 1058 | 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




Responses

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

Up
0
Down
Hi,
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">
<databases>
<add name="DatabaseSample" connectionStringName="connstring" pollTime="500"/> // In poll time you can specify the time in milli seconds
</databases>
</sqlCacheDependency>
(OR)
Include an ajax control with update panel and timer set as 5 min.

If im wrong, please correct me.

Regards,

Awesome Coding !! :)

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

Login to post response