Asp.Net News
Free Tech Magazines
Asp.Net Web Hosting
Suggest Us
Link to Us
Feeds Subscription
Questions & Answers
Tips & Tricks
 how to write the querry for 6 months or for 1 year
Posted by charan on  3/29/2010 8:57:23 AM Category: ADO.NET
Add to my favorites
Email to friend
hi, iam using with c# with sql server databae

the table fields are

username nvarchar
startdate datetime
enddate datetime
paytype int
reminder int

while registering the user will selects the startdate and enddate and the pay type is 6months or 1year and he will select the reminder before 10days
then if he selects for 6months then before 10days i have to send email. if he selects for 1year i have to send for every 6months before 10 days
then how to write the querry for this condition please give the example which helps me.

Post Your Reply Post New Question

 Viewer's Reply
This Question has 0 replies.

Sponsored by
Simply SQL - Free 111 Page Preview!
Backup and Recovery Best Practices for Microsoft SQL Server 2005
The ASP.NET 2.0 Anthology: 101 Essential Tips, Tricks & Hacks - Free 156 Page Preview