We are using this very thing on SQL Server 2000 (Microsoft SQL Server  2000 - 8.00.760) to do a join on two "Hash" keys that we use to query based...

What a great discussion...Here is my take.

At my last company (around 100 IS staff), the DA (Data Architect), DBA and developer duties

were done by sperate groups. ...

How about this?

Anton

-- Create Tables

create table tblComp (CompId int, compName varchar(100), dateCreat datetime)

create table tblContact (contId int, compId int, Name varchar(100), MemoCount int, dateEnter datetime)

create table tblMemo (memoId int, contId...

Nto sure if this is the correct direction. Take a look at the "EXPLICIT mode" topic in the "SQL Server Books On-Line". I will try to follow up...

David,

This is great....I guess I need to brush up on my queries when dealing with sets of data.

Thanks a bunch. This will be a big help on our project....