Table relationships

[Paul]

Hi,
Does anyone have any suggestions on the best to go about enforcing a
relationship between two tables that exist within separate databases
on the same SQL Server instance.

[John Bell]

Hi

You could do this using a instead of trigger or using a check constraint and
function. The latter may not perform that well.

John

"Paul" <pa***************@hotmail.com> wrote in message
news:19**************************@posting.google.c om...

Hi,
Does anyone have any suggestions on the best to go about enforcing a
relationship between two tables that exist within separate databases
on the same SQL Server instance.

[John Bell]

Hi

You could do this using a instead of trigger or using a check constraint and
function. The latter may not perform that well.

John

"Paul" <pa***************@hotmail.com> wrote in message
news:19**************************@posting.google.c om...

Hi,
Does anyone have any suggestions on the best to go about enforcing a
relationship between two tables that exist within separate databases
on the same SQL Server instance.

[John Bell]

Hi

The second query should show them, but the problem would be that all
possible combinations will be shown.

As there is not a fixed number of exams that may be either the min or max,
the best solution is to do the transformations on the client.

John

"Paul" <pa***************@hotmail.com> wrote in message
news:19**************************@posting.google.c om...

Hi,
Does anyone have any suggestions on the best to go about enforcing a
relationship between two tables that exist within separate databases
on the same SQL Server instance.

[John Bell]

Hi

The second query should show them, but the problem would be that all
possible combinations will be shown.

As there is not a fixed number of exams that may be either the min or max,
the best solution is to do the transformations on the client.

John

"Paul" <pa***************@hotmail.com> wrote in message
news:19**************************@posting.google.c om...

Hi,
Does anyone have any suggestions on the best to go about enforcing a
relationship between two tables that exist within separate databases
on the same SQL Server instance.

[Paul]

Thanks John,
That's pretty much the kind of response I was expecting.
I just wanted to make sure that I wasn't missing out an alternative
route.

The only draw-back I can see to using triggers is related to
maintenance, but that is a draw-back that I can live with.

Paul

pa***************@hotmail.com (Paul) wrote in message news:<19**************************@posting.google. com>...

Hi,
Does anyone have any suggestions on the best to go about enforcing a
relationship between two tables that exist within separate databases
on the same SQL Server instance.

[Paul]

Thanks John,
That's pretty much the kind of response I was expecting.
I just wanted to make sure that I wasn't missing out an alternative
route.

The only draw-back I can see to using triggers is related to
maintenance, but that is a draw-back that I can live with.

Paul

pa***************@hotmail.com (Paul) wrote in message news:<19**************************@posting.google. com>...

Hi,
Does anyone have any suggestions on the best to go about enforcing a
relationship between two tables that exist within separate databases
on the same SQL Server instance.

[John Bell]

Hi

If you have done the analysis fully I thing trigger code is less
likely to change than any other area. If your documentation is up to
scratch then everyone should realise they are there! The actual coding
of them is not really very different to any stored procedure.
Therefore I would not be too worried about it.
John

pa***************@hotmail.com (Paul) wrote in message news:<19**************************@posting.google. com>...

Thanks John,
That's pretty much the kind of response I was expecting.
I just wanted to make sure that I wasn't missing out an alternative
route.

The only draw-back I can see to using triggers is related to
maintenance, but that is a draw-back that I can live with.

Paul

pa***************@hotmail.com (Paul) wrote in message news:<19**************************@posting.google. com>...

Hi,
Does anyone have any suggestions on the best to go about enforcing a
relationship between two tables that exist within separate databases
on the same SQL Server instance.