how can i insert values into table only a prticular dates of each month?

Posted by Jahi under ASP.NET on 3/4/2011 | Points: 10 | Views : 1374 | Status : [Member] | Replies : 10
Hi,


how can i insert values into table only a particular date of every month?


Please help me.


Thanks

Jaheena




Responses

Posted by: Madhu.b.rokkam on: 3/4/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
You mean you want to insert into table on a particular date only ???
If you mean something else .. Be little clear to help you on this ..

Thanks and Regards
Madhu

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

Posted by: Jahi on: 3/4/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Madhu sir,

I mean, When a person who registered in this particular website . Then next month, same date he will get particular amount of money . same like each month that particule date only.


Please help me

Thanks and Regards
Jaheena

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

Posted by: Madhu.b.rokkam on: 3/4/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Then lets say we have registered date as one field then
fetch all the users ids whose registered date is one month behind put it into temp table and then loop thru that and insert record for those registered userids as required. If you want to automate then you can use SQL JOBS and schedule it to run accordingly.

Select columnlist from yourtable where datediff(month, registereddate, getdate()) = 1


Thanks and Regards
Madhu

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

Posted by: Jahi on: 3/4/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Madhu sir,


Sorry sir.. Please explain it more clearly. I don't understand what you say.



Thanks & Regards
Jaheena

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

Posted by: Madhu.b.rokkam on: 3/4/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
pun in your complete requirement we will try to help you out on that ...

Thanks and Regards
Madhu

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

Posted by: Jahi on: 3/4/2011 [Member] Starter | Points: 25

Up
0
Down
Sir,

When a person registered in this company, he will get a certain amount of money to that person on a particular date that who registered date on next month. this process will continue for one year.
ie, He will get certain amount of money to that person in every month for that particular date.


please help me

Thanks & Regards
Jaheena

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

Posted by: Karthikanbarasan on: 3/4/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
Hi Jaji,

Your requirement is more confusing... can you please put in a right direction...

Thanks
Karthik
www.f5Debug.net

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

Posted by: Madhu.b.rokkam on: 3/4/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Be more technical in the sense that when you want to insert a row, whether its manually or automated .. and all that since we are bit confused ...

Thanks and Regards
Madhu

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

Posted by: Jahi on: 3/5/2011 [Member] Starter | Points: 25

Up
0
Down
sir,

A certain amount of money will insert to a person automatically after 30 days of registration and after that each month will insert same amount to him.


Thanks and Regards
Jaheena

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

Posted by: Madhu.b.rokkam on: 3/6/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
You can do this using SQL Server JOBS where you can schedule them to execute your queries at specified time..

Thanks and Regards
Madhu

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

Login to post response