Antares686 - it looks like that did the trick! This is great! Thank you all for your help!

I've said it before and I'll say it again - this site...

The invoices numbers pose a bit of a problem at the moment as we just migrated data from one an old business application to a new one and the invoice...

I realized I can just replace cs.* with any of the p21_view_customer columns I want - which is great! 😀

Now I just need to figure out how to add the...

Ramesh, I ran the modified query and it returned:

Msg 102, Level 15, State 1, Line 12

Incorrect syntax near ')'.

Also, what would be the proper way to add the INVOICE_DATE column from P21_view_invoice_hdr and the DATE_ACCT_OPENED column from P21_view_customer ?

Thanks in advance for your help guys!

Andras - that worked, thanks

Rameesh - I tried the query but it failed with this error:

Msg 156, Level 15, State 1, Line 6

Incorrect syntax near the keyword 'OVER'.

Msg 102, Level...

Perfect! Thanks for your help!

^ I ran the first part of this and it only returned 679 rows - much nicer than the 220,000 I first saw. 😀

One advantage I can see to this...

Lowell (11/5/2007)

---

i should have explained...that is not for a trigger!

run that in QA...it should find the sample record you said you created.

if it works, then you can throw away the...

No luck - that actually kinda freaked the app out a little. All of the sudden the other email alert trigger stopped working and I was getting hourglasses when I...

Ok, I think I understand what you are saying - so (remember, baby steps for the newb :blush:) how would I re-structure the trigger to accommodate that?

You guys are all fast! It's only been about 30 minutes and you've helped me fix the problem with creating the trigger!

So, the trigger did execute and was created...

^ thanks for catching that!

That fixed one error but I'm still getting the:

Msg 156, Level 15, State 1, Procedure Zero_Commission_Cost_Notification, Line 28

Incorrect syntax near the keyword 'select'.

For the SELECT...

I just tried executing the script on a dev dbase and received this error:

Msg 156, Level 15, State 1, Procedure Zero_Commission_Cost_Notification, Line 28

Incorrect syntax near the keyword 'select'.

Msg 102, Level...