Stored procedure for calculating time for every 5min

Posted by Vijay.Kumar under Sql Server on 9/5/2012 | Points: 10 | Views : 1812 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts