I am using a Stored Procedure. I tried modifying it as you suggested and it updated the row and inserted the new ones correctly. Thanks for the help.

Here's the updated...

Scott,

Thanks for the help. That's exactly what I needed. Now I just have to find out why there's so many NULLs in my source tables. There's always something...

Scott,

I get no values returned from either of the other tables even though I do when I query each separately...

I do get both sets if I change the Query to:

SELECT...

• This reply was modified 3 years, 4 months ago by  tim8w.

I am always not sure what additional info you guys are looking for.

Main Table tblJDEWOData2

BusinessUnit char(30)

PartNum char(30)

WONum int

TransDate datetime

TransQty int

Table 1 tblHistory

HistoryID int

WONum int

WOQty int

Table 2 tbl WONumWOQty

WONum int

WOQty int

Output

BusinessUnit ...

Brian,

OperatorID is the PK and it is unique, but the same Operator can work in multiple areas, which is why I need DISTINCT somehow. For this select, I don't care...

Brian,

OperatorBadgeID are only used by one Operator, not shared. Some do work in more than one area of the plant, so, yes, there can be duplicate entries, one for each...

Awesome! I like the last one. Thanks for the examples. I'm pretty sure I can use all of them in the future...

As I explained in my post, our users login to their PCs by either using a Generic Account Name or if they have their own login, by their BadgeID. If...

Same SELECT that I am using. Ending up being that the Record that contained 'PREC' in Table B somehow had some non-visible character in it. I deleted the value and...

Thanks! That helps a lot

Ended up being in my ConnectionString. Once I ended up removing the "Integrated Security=SSPI;" everything worked correctly.

SqlConnection myConnection = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=FPY;Data Source=MyServer;User ID=PartsetupUser;Password=MyPassword");

 

Hi,

Thanks for all the help. I ended up doing this after I received some suggestions:

USE [FPY]

GO

/****** Object: StoredProcedure [dbo].[MergeTables] Script Date: 1/3/2021 6:17:56 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROC...

SSCrazy,

The VB6 I had no choice about. It is legacy software that the company wanted to update from Access to SQL. Anyway, I tried the Refresh command as you suggested....