Hi All
We have an issue with Atrium Impact Simulator basically crashing doing nothing and BMC support says that it is because of the circular relationships which are not allowed. Example: Considering the following as relationship records Record # Source Recon Destination Recon 1 A1.ReconID A2. ReconID 2 A2. ReconID A3. ReconID 3 A3. ReconID A4. ReconID 4 A3. ReconID A1. ReconID 5 A4. ReconID A5. ReconID 6 A5. ReconID A4. ReconID 7 A5. ReconID A6. ReconID 8 A7. ReconID A8. ReconID 9 A9. ReconID A11. ReconID 10 A5. ReconID A3. ReconID here is an example of circular relationships Record # Source Recon Destination Recon 1 A1.ReconID A2. ReconID 2 A2. ReconID A3. ReconID 4 A3. ReconID A1. ReconID 5 A4. ReconID A5. ReconID 6 A5. ReconID A4. ReconID Now I am working on a SQL query to extract those circular relations from “BMC.CORE:BMC_BaseRelationship” but cannot seem to get the right logic. Any help is greatly appreciated, Thanks in advance Mahesh _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"