Server Objects, Linked Servers, Providers, SQLNCLI. Right-click and choose Properties...

Be very careful about changing settings.

In that case, take a look at ISNULL() and COALESCE() to be able to go through a list of columns and return the value from the first non-null column.

Take out the DISTINCT from the query -- the GROUP BY is collapsing the non-aggregated rows to their distinct values already. Also, I'm assuming that the difference between "a.pcode" in...

Quote: "In essence what I want is to know when the filler order id is repeated on a different customer."

SELECT a.FillerOrderID, a.Customer, b.Customer

FROM Orders a

INNER JOIN Orders b

...

This is somtimes known as a fishhook join/relation, since the line representing the relation can be shaped like a fishhook. The classic example is:

CREATE TABLE Employee2

(EmpID INT PRIMARY KEY,

...

And yet another reason not to use SELECT * in a view.