Advertisement

09.25.2008 at 09:08PM PDT, ID: 23765052 | Points: 500
[x]
Attachment Details

Basic Trigger

Asked by styleteks in MS SQL Server, SQL Server 2005

Tags:

Greetings,

I need to perform an insert based on another tables specific update.

The trigger:  lead.convert is set to equal 1

The insert (shortened for simplicity): set lead.name = customer.name, lead.company = customer.company, etc, etc.

Thanks in advance for your help!Start Free Trial
[+][-]09.25.2008 at 09:14PM PDT, ID: 22576553

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.25.2008 at 09:38PM PDT, ID: 22576628

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.25.2008 at 09:46PM PDT, ID: 22576649

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.25.2008 at 09:55PM PDT, ID: 22576678

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.25.2008 at 10:03PM PDT, ID: 22576710

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.26.2008 at 01:33AM PDT, ID: 22577601

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 - Hierarchy / EE_QW_2_20070628