David,

 I had also being in that boat quite a bit. For example a person can be in more than one department, with more than one position, belong to more than...

stax68,

I understand that you can divide the association table further until you get never more than 2 FK per association. In your case it was splitted in two. I was...

This method is also known as the asossiation table. It helps maintain many to many relations. You can split the association table into several but the effect is the same.

you some...

can you explain what's repeated ?

1. Make sure they are set up as System DSN  not User DSN

2. Create a linked server as expressed above by John Zacharkan

3. see if you can connect

Maybe  something like:

Table Departments

pk_DepID

Table Positions

Pk_PosID

Table Phones

Pk_PhoneID

Table_Pos_Dep_Phone

fk_PosID,fk_DepID,fk_PhoneID, Pk_Association

How did you tested the ODBC DSN ?

ok, if that is your only option :

1. READ the article that Frank posted!

2. besides trying to do all in one procedure with one single query sometimes it makes sense to...

With a view

1. you don't have to use dynamic sql.

2. you don't have to grant direct access to the tables

3. you can create the statements on the client against...

can't you use a view ?

Frank,

I didn't posted on the forums for the price, you can keep it. I think that it was a great learning experience for me! and I value that more than any...

if your login is not the owner the (dbo) will come up. if the login is the owner the (dbo) will not!

declare @Julian_Date int

declare @Year int

set @Year = 2004

set @Julian_Date = 60

Select DateAdd(dd,@Julian_DAte, Cast( @Year - 1  as char(4)) +'-12-31')  as CalendarDay

When you use truncate, ALL records are gone. Should you have a table with child records (meaning an fk from this one(Parent)) you get the error beause if the system...

carmines,

ThomasH has explained very well the use of that handy table which by the way has been around since the sybase times....