Inserting recurring dates into a MSSQL database.

Reply

Join Date: Apr 2009
Posts: 1
Reputation: kujoy is an unknown quantity at this point 
Solved Threads: 0
kujoy kujoy is offline Offline
Newbie Poster

Inserting recurring dates into a MSSQL database.

 
0
  #1
Apr 15th, 2009
Hiya,

Im looking to set up an events schedule, and i'm unsure where to start. Basically this will take a Startdate then insert a row in a table then a add 7 days to the inserted row date and insert another row etc until a specified date. I've looked at a lot of forums etc and can't find anything definitive. I'm not sure whether its best to do this in the asp code or use a stored procedure to do it. Once i've got the basics i should be able to flesh it out into something bigger. I need a system thats going to use minimal system resources because its going to get used a lot an enter a large volume of dates.

Any help or pointers in the right direction would be appreciated.
Reply With Quote Quick reply to this message  
Join Date: Jun 2008
Posts: 133
Reputation: vicky_rawat is an unknown quantity at this point 
Solved Threads: 17
vicky_rawat's Avatar
vicky_rawat vicky_rawat is offline Offline
Junior Poster

Re: Inserting recurring dates into a MSSQL database.

 
0
  #2
Apr 18th, 2009
Hi,

This can be done directly in stored procedure.
Vivek Rawat
Keep solving complexities.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the ASP Forum
Thread Tools Search this Thread



Tag cloud for ASP
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC