slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Database Administration | New Thread

View: Search:

Author

Thread: Circular joins

Michael Litman
Posts: 94

Circular joins Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Oct 06 7:52 PM

I was once sent a t-sql script that checked for circular joins in the database does anyone have or know of this script. Thanks ML

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Circular joins Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Oct 06 9:12 PM

Here you go:

select j1.fromtable fromtable1, j1.fromfield fromfield1, 
       j1.totable totable1, j1.tofield tofield1
FROM sysdba.joindata j1, sysdba.joindata j2
WHERE j1.fromtable = j2.totable
AND j1.totable = j2.fromtable
AND j1.fromfield = j2.tofield
AND j1.tofield = j2.fromfield

[Reply][Quote]

Michael Litman
Posts: 94

Re: Circular joins Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Oct 06 9:26 PM

thank you kindly ML

[Reply][Quote]

Jeremy Brayton
Posts: 491

Re: Circular joins Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Oct 06 5:11 PM

I believe 6.2's Integrity Checker includes this as one of the Other tests. You only need to keep the t-sql handy if you're on an earlier version or like checking it outside of the Administrator.

[Reply][Quote]

Michael Rogers
Posts: 70

Re: Circular joins Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Nov 06 4:24 PM

and these should be avoided, correct?

Especially if Global joins?

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/26/2024 5:45:07 AM