Lowell,

Using your script, I found that some of the CRM telephone numbers were NULL. I forgot to check if there were values there. Thanks so much!

AdvertiserName is the primary key on the Advertiser table.

Jeffrey,

I made the changes you suggested and tested the report - it works perfectly!. Thanks so much.

Pat

Jeff and Jeffrey,

Thanks to both of you. That seems like a very doable solution that will avoid the duplication. I really appreciate your help.

Pat

Thanks, Jeff.

Jeff,

Thanks for responding. We run this report daily for the previous day, and then weekly for the previous week. Once a week is run, we never run that week again....

Hi Jeff,

I read and replied to Jack's response before I saw yours, but thanks for explaining it in such detail. That was very helpful. However, I like the idea of...

Thank you for your detailed reply. I think I understand what you are saying when you say that I am thinking procedurally and not terms of sets. I am an...

Sorry, I missed one of your questions. I do not want to load duplicates - I just want to ignore them and move on with the rest of the script.

The primary key is EmpName and PTODate. Ignore error is simply a label to allow me to continue on with the code. What I'm trying to do is to ignore...

Problem solved. Thanks so much!

No, there are no quotes within the name; the name is surrounded by quotes. When I changed the code to WHERE (SUBSTRING(cust_name, 1, 3) <> 'ABC')), that worked, but I...