Trigger in a certain period of time of day

[User 4700810]

Hi all, I have two tables A(a1,a2,a3), B(b1,b2,b3) and a period of time Delta t [t1,t2]. When it is between t1 - t2 of time, if there is a row inserted in table A, the field b1 of table B will be updated such as b1=b1+1. Moreover, I also have a web application which can assign value for t1, t2 through an aspx page. Could you tell me how to do that? Thank kiu so much.

[_Damian S_]

If you are using SQL Server, you could set up a trigger on table a, so when a row is inserted it checks if the time is between t1 and t2, and if so update table b.

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

[User 4700810]

Could you give me an example because I do not know how to assign value for t1 & t2? Thank kiu!