How Do I Set Trigger For Reminder.. Suppose Tax Invoice Date Is 1/1/2014 And After 10 Days I Get Reminder From System/

Question

0.00/5 (No votes)

See more:

Posted 19-Feb-14 19:02pm

Member 10610791

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sohail awr · Answer 1 · 2014-02-20T03:29:00

Solution 1

First you create a reminder table here you can insert the records for reminder on Insertion of each record in your master table. The reminders you can call on timer so it will populate.

SQL

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER Trigger1 --This is your trigger name
   ON  sales  --This is your master table
   AFTER INSERT --DELETE/UPDATE (Anyone action you can choose)
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for trigger here
insert into table_2(test1) values(dateadd(day,10,getdate())) -- The reminder table where you can insert your message
END
GO

Posted 20-Feb-14 3:29am

sohail awr

Updated 20-Feb-14 3:30am

v2

Comments

Member 10610791 21-Feb-14 1:12am

its not working yaar..
Can u please briefly describe that code.
i cant understand which field i take in reminder table?

Member 10610791 21-Feb-14 1:28am

And i can also not understand that line:"insert into table_2(test1) values(dateadd(day,10,getdate()))"

sohail awr 21-Feb-14 8:19am

First Select your table from your database in which you want to set trigger.

--- Trigger works on each record

I have defined Trigger Name as Trigger1
My Master table is Sales (You can use your master table)
Event I have used (AFTER/BEFORE) any one you can use.
Make a new Reminder Table as Table_2 or any name you can give, Entity Name I have given as 'test1' you can use any other name.
In values I have used DateAdd function. 1 parameter is Day , how much day you want to add, your invoice date I used default system date