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...

OK, now I know why, there are more than 1 records in the #PMARevenueTemp with the same fsono, fpartno, and frev. But how do I get around that? I only...

Can you take a look at this for me? Maybe I am over seeing something.

This is the offending code:
Select Distinct fsono, fprodcl, fpartno, frev, fccompany, lstclassify,

I found the code that is offending.  It is a select statement. Within the select statement there is a select statement to a very very large table. I know a...

a bit over my head but I will try to get through it.

Connection strings are the same in other programs See below:
Dim constring As String = "Data Source=" + Server + ";Initial Catalog=" + _
                  database + ";Integrated Security...

Well they are of no help. They can't even understand what I want. I think they are Russian.