Could you point me in the direction on how to do that is SSIS?

I have two servers, one is a production server one is used by customers. They can not talk to each other for security reasons. Meaning I can't link...

Here is the table with the PKey, a combination of PartNumber and Location would also work, but I like having int's for pkeys. Thanks for your help and patience.

CREATE...

Yes we would need to assign a pkey, it would not be PartNumber or location because those are not always unique.

great thanks for the extra clarification.

awesome thanks

yes i went back and uncommented it in my example. thanks for your help

currently they were commented out for testing purposes, because i testing the if statements.

Ok here is what i belive you want.

Create Tables and Data:

CREATE TABLE [dbo].[InventReorder](

[Location] [nvarchar](50) NOT NULL,

[PartNumber] [nvarchar](50) NOT NULL,

[Quantity] [int] NOT NULL,

[DistribQoh] [int] NOT NULL

) ON [PRIMARY]

GO

INSERT INTO InventReorder

...

Adding the Begin/End worked.

Sorry I didn't copy my exact code over i apologize, I did have some of the things in my original that were missed. What...

Here's another question, not sure if its possible. I can write this code without a problem in asp. My problem is this code needs to run without anyone...

David or someone,

Could you help break this down for me

MERGE INTO InventoryThatNeedsReorders I

USING

(SELECT A.PartNumber, A.AlternatePart

FROM AlterNateParts A

JOIN CurrentInventoryTable C

ON A.PartNumber = C.PartNumber) P

ON I.PartNumber = P.PartNumber

OR I.PartNumber = P.AlternatePart

WHEN MATCHED...

Ok I think i know what you want now so let me try this again.

This is the select statement before the logic:

Select PartNumber, Location, Quantity from InventoryThatNeedsReorders Where ((Quantity-ReorderPoint)>=1)

Which would...

Results of

SELECT * FROM InventoryThatNeedsReorders

PartNumber LocationQuantityReorderPoint

Widget 123 GrandRapids 2 1

Widget 456 Chicago ...

Guess I'm a bit unclear about what your asking, do you want to know what I would expect the results of SELECT * FROM InventoryThatNeedsReorders before or after the logic...