Would like to post the data but I have a solution now. This will run once a quarter at night so it is not a huge hit on processing. I...

I finally got it. Here is the select statement.

Select cust.fcustno, fcompany, fcreated, cust.fsalespn, Sum(fnamount) as Sales from slcdpmx cust
inner join (select fcustno, fnamount, finvdate 
from armast where...

OK, but I still can not figure this out. OR does not work. What I need to find out is to gather data for customers who had invoices before a...

OR  Crap, sorry, thanks.

Ah, never thought of a trigger. That would work.

To all, was out sick for a few days. thank you for all your insights, Truly was an education.

A little confused on the schema but will look up more reference on that. Understand on the creation of data. Everyone have a nice weekend. Nocking off for the day...

Jeff, you are correct. I had the cursor distinction mixed up. it is a dynamic cursor and I have used forward only in the past. The left outer joins are...

I guess you may be correct, an application programmer. That is what I have done for a very long time. For data manipulation, I guess, I would not know how...

OK, I love to learn new things. Thought I posted code yesterday but possibly

declare @partno char(35)
declare @rev char(3)
declare @id numeric(15)
declare @id2 numeric(15)
declare @std numeric(1)
declare @prc numeric(1)
--Get list...

@Mr. Gale - No only when debugging in VS does it take long. When I would debug in SSMS it would not do that.  I like to step though my...

How do you union the blank rows on fquantity?  I have search and searched and have not found anything.

Thanks

I renamed them for now and will see what happens over the coarse of a few months.

I found some articles using msiexec /x GUID and that seemed to work. Thanks for the reply.

I got around it by selecting a 0 as the field name then doing an update to the table setting the field to a select statement value. Runs lickidy split...