Table Relations +CLOSED+ - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Table Relations +CLOSED+

Author

Topic

emmim44
Yak Posting Veteran

65 Posts

Posted - 2012-07-12 : 07:04:18

Hi guyzz.
I am trying to find a direct or indirect table relationship using a query. I need some help with that...I need to know the direct/indirect relationship between tbl unsaccountB and dialogwatchoperation and dialogwatchproperty.

Relationship tbl: select * from DialogTableRelation
Sample output:


RelationID	ParentTable	ChildTable
R/1438	Person	UNSAccountB
R/1445	UNSGroupB	UNSAccountBInUNSGroupB
R/1446	UNSAccountB	UNSAccountBInUNSGroupB
R/1447	UNSGroupB	UNSAccountBInUNSGroupBTotal
R/1448	UNSAccountB	UNSAccountBInUNSGroupBTotal

emmim44
Yak Posting Veteran

65 Posts

Posted - 2012-07-12 : 08:06:31

quote:
Originally posted by emmim44

Hi guyzz.
I am trying to find a direct or indirect table relationship using a query. I need some help with that...I need to know the direct/indirect relationship between tbl unsaccountB and dialogwatchoperation and dialogwatchproperty.

Relationship tbl: select * from DialogTableRelation
Sample output:

RelationID ParentTable ChildTable
R/1438 Person UNSAccountB
R/1445 UNSGroupB UNSAccountBInUNSGroupB
R/1446 UNSAccountB UNSAccountBInUNSGroupB
R/1447 UNSGroupB UNSAccountBInUNSGroupBTotal
R/1448 UNSAccountB UNSAccountBInUNSGroupBTotal

This thread is closed.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources