Is it possible to have a cell in table1 "point to" a cell in table2?

Posted by Lewray on Server Fault See other posts from Server Fault or by Lewray
Published on 2010-11-22T09:50:42Z Indexed on 2010/12/22 18:56 UTC
Read the original article Hit count: 197

Filed under:

I have a hierarchical structure in a database driven software application.

Each row in parentTable 'owns' a number of rows in childTable.

If the childTable does not have a value set in columnA then it should return the value specified in the appropriate row of parentTable columnB.

Is it possible to implement a pointer or cell reference somehow so that I do not have to copy values from parent to child.

(A change in parent could result in a large number of changes in child).

If this is not possible, could anyone suggest a different approach?

© Server Fault or respective owner

Related posts about sql-server-2008