Apart from the absence of referential integrity (in long form for newbies), are your prod and arch table structures identical? Are you copying across all the data or filtering it...

I had in mind this particular para from BOL:

Before you use Microsoft Distributed Transaction Coordinator (MS DTC) with a SQL Server 2000 Meta Data Services repository, you must install the...

I do not claim any expertise but your question intrigued me so I searched BOL and this is what I found, so please eliminate them as possible causes.

Meta Data Services...

A few questions first, to help us understand what you are trying to do:

1- Which columns make your PK? (Or, what is the purpose of the id column?

2- Why...

Starts making sense, but only so much, because it is still poor logic (and bad ethics).

Next question: why does one user need multiple passwords? Why can't you implement user rights...

Jeff: Thanks for illuminating.

JP: Again, I need to ask you: WHY on earth would you want UNIQUE passwords? How would you deal with this situation: if by a fluke of...

Now that makes a lot of sense, maybe i was just too narrowly focused!

Thanks all who helped and Chris esp for bearing with me so far.

I sure have made great...

A UNIQUE constraint is theoretically no different from a PRIMARY KEY, since a KEY has to be UNIQUE in order to retrieve records, and a UNIQUE column will do just...

Chris, I think I have not been very lucid, sorry:

What I want is:

WHERE (IM.TYPENAME = 'BAR'

OR IM.TYPENAME = 'RESTAURANT')

AND IM.TAX_DATE BETWEEN @FDT AND @tdt

-- I want to be...

If I understand you correctly you want (USERID+PWD) to be unique instead of USERID being unique by itself. Is that right? Or did you intend that NEITHER USERID NOR PWD...

Yes, Chris, have made much progress, thank you very much.

ISNULL won't help me because I want to bypass the filter if the argument is not passed in, as below:

INSERT INTO...

No, I am afraid it's neither - it's just the SQL requirements which make life tuff. Nonetheless, I managed to modify my last SELECT statement as below:

SELECT V.PROD, V.QTY, U.UNIT

FROM...

Hi, all, and thanks for all your help.

Chris, thanks again. I tried your query, the end result is a detailed breakdown of all the columns once again. I played around...

Thanks, Chris, for taking the effort. Muchos appreciados. And your liberties are welcome, no use being rigid with data values, is there?

I checked your last two queries, and I see...

I have tinkered around and come up with these three disparate queries. The question is how to integrate them.

SELECT DISTINCT P.PRODUCT, ID.ITEMNO, F.NAME

INTO #DETAILS

FROM INVOICEMASTER IM

INNER JOIN...