This makes no sense right now. Please provide sample data for the second table.

Change this:

SELECT WarehousePickingGroup.PickingGroupDescription, SalesTransactionDtl.Transaction_No, SalesTransactionDtl.Line_No

FROM SalesTransactionDtl

INNER JOIN WarehousePickingGroup

ON SalesTransactionDtl.PickingGroup_ID = WarehousePickingGroup.PickingGroup_ID

To this:

SELECT WarehousePickingGroup.PickingGroupDescription, SalesTransactionDtl.Transaction_No, SalesTransactionDtl.Line_No

FROM SalesTransactionDtl

INNER JOIN WarehousePickingGroup

ON SalesTransactionDtl.PickingGroup_ID = WarehousePickingGroup.PickingGroup_ID

AND SalesTransactionHdr.Warehouse_No...

Try this:

SELECT * FROM WarehousePickingGroup WHERE PickingGroup_ID = X and make X some pickingGroup_ID that is returning duplicates. Post the results here.

ericb1 (3/8/2012)

---

Thanks. I've tried that as well, and it didn't work either. If I put in my login or use "domain\Administrator" (which is a valid login on both...

I am assuming that you do not know the difference between an INNER JOIN and a LEFT JOIN. Inner join only returns rows where there is a match for...

Go to the server objects\linked Servers and right-click on this object and select properties. Then click save or ok (I forget which one it is) to close it. ...

MyDoggieJessie (3/8/2012)

---

If you run a snapshot via the GUI (which is what I always use) it immediately places table/object locks on the tables being bcp'd. This works okay for...

sqlfriends (3/8/2012)

---

I would like to ask expert on this forum a question that has been a puzzle for me for a long time.

Although I did a lot of research and...

Post the error you are receiving. Probably has to do with the linked server configuration or the permissions on the remote server. Also, assigning a domain user to a...

MyDoggieJessie (3/8/2012)

---

If the database is too large and/or there are way too many transactions/minute we do not use snapshot, but sync manually, start replication, then sync again for info that...

nobking (3/7/2012)

---

SQLKnowItAll (3/7/2012)

---

You don't partition for performance, you partition for data management and because it makes sense logically.

How much...

MysteryJimbo (3/8/2012)

---

Unless you do...

Maybe I am misunderstanding... If you don't initialize with a snapshot, the tables have to be manually synced for all data before replication began. Otherwise you must push a snapshot....

We don't even know what performance the OP is talking about. I suspect that...

Matt Miller (#4) (3/7/2012)

---

SQLKnowItAll (3/7/2012)

---

Since you know that the view will change definition and want it to pick up the changes, I would stick with the select * and add...