Re: Re: [firebird-support] How To Get Entire Linked Group Details

groups.com Objet : Re: Re: [firebird-support] How To Get Entire Linked Group Details    Hi Norbert,  Thank You So Much, I got exactly the same result what I was expecting.  Thank You So much.  Are you aware of any documents which are avaialble in english, so I could learn this recirsive SQL ?    Wi

Re: Re: [firebird-support] How To Get Entire Linked Group Details

firebird-support@yahoogroups.com Objet : Re: Re: [firebird-support] How To Get Entire Linked Group Details    Hi Norbert,  Thank You So Much, I got exactly the same result what I was expecting.  Thank You So much.  Are you aware of any documents which are avaialble in english, so I could learn t

Re: Re: [firebird-support] How To Get Entire Linked Group Details

Oy   Bergantie 69, FI-02540 Kylmälä   Tel. : +358 (0) 400 27 25 18   E- mail : n...@tetrasys.fi  De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Envoyé : vendredi 2 octobre 2015 15:24 À : firebird-support@yahoogroups.com Objet : Re: Re: [firebird-support] How To G

RE: Re: [firebird-support] How To Get Entire Linked Group Details

ova...@tetrasys.eu> De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Envoyé : lundi 5 octobre 2015 11:15 À : firebird-support@yahoogroups.com Objet : Re: Re: [firebird-support] How To Get Entire Linked Group Details Hi Norbert, The SQL you have

Re: Re: [firebird-support] How To Get Entire Linked Group Details

. : +358 (0) 400 27 25 18   E- mail : n...@tetrasys.fi  De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Envoyé : lundi 5 octobre 2015 11:15 À : firebird-support@yahoogroups.com Objet : Re: Re: [firebird-support] How To Get Entire Linked Group Details    Hi Norbe

Re: [firebird-support] How To Get Entire Linked Group Details

Hi SET, Could you please help me ? With Best Regards. Vishal On Friday, 2 October 2015 10:11 AM, "Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]" wrote:  In tree format, the logical structure looks like as below: Vishal

Re: Re: [firebird-support] How To Get Entire Linked Group Details

Is it available in Engilsh ? so would be easy to learn for me. I am very much interested to learn recursive SQL. Karol, but please help me in getting base leaf also in the output. Thank You to both of You. With Best Regards. Vishal On Friday, 2 October 2015 5:55 PM, "'Walter R. Ojeda

RE: Re: [firebird-support] How To Get Entire Linked Group Details

rebird-support@yahoogroups.com Objet : Re: Re: [firebird-support] How To Get Entire Linked Group Details Hi Karol Bieniaszewski, You are passing "Vishal Group1" in condition, I need to pass "Vishal Group" (i.e. base leaf for perticular group), because in the sql you

Re: Re: [firebird-support] How To Get Entire Linked Group Details

Hi,   i do not know if you describe your problem precisely. But i understand it like this: looks like you need all leaf from same parent (with parent included) as is for "Vishal Group1" and all its childs   try this    WITH RECURSIVE  G1_PARENT AS  (  SELECT MGP.DESCRIPTION FROM MYGROUP MG INNER

Re: Re: [firebird-support] How To Get Entire Linked Group Details

 Hi Karol Bieniaszewski, You are passing "Vishal Group1" in condition, I need to pass "Vishal Group" (i.e. base leaf for perticular group), because in the sql you provided if I put  'Test1', it gives entire structure details, one way that is correct, but only i need is to pass required base

Re: Re: [firebird-support] How To Get Entire Linked Group Details

No, sorry, just in Spanish. You can use some translation software, maybe Google translator, and if you have some doubts just ask for help. Greetings. Walter. On Fri, Oct 2, 2015 at 8:33 AM, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > >

Re: Re: [firebird-support] How To Get Entire Linked Group Details

If you want to learn about recursivity with Firebird and you can read Spanish, there are several articles that can teach you: https://firebird21.wordpress.com/2015/08/22/usando-recursividad-con-cte/ https://firebird21.wordpress.com/2015/08/25/entendiendo-la-recursividad-en-los-select/

Re: Re: [firebird-support] How To Get Entire Linked Group Details

Hi Karol Bieniaszewski, Yess, YOU ARE THE MAN OF THE MOMENT.  Your SQL just ROCKS, JUST ROCKS. AWESOME KAROL, JUST AWESOME. I am going to next level of my code where I need to find out that the deepest leaf, if it is not used in certain table then I would like to delete it. For

[firebird-support] How To Get Entire Linked Group Details

Hi All,  I have attached a table DDL and Insert  record script in "Table Script.txt" text file. And also attached a snap of how data looks in the table in the file "Entire Table Data.png" I need to get all the details for the main group called "Vishal Group1", please refer "Expected

Re: [firebird-support] How To Get Entire Linked Group Details

Hi, this group does not support attachments regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Thursday, October 01, 2015 2:59 PM To: Yahoo! Inc. Subject: [firebird-support] How To Get Entire Linked Group Details Hi All, I have attached a table DDL

Re: [firebird-support] How To Get Entire Linked Group Details

Hi All, There is some change in my previous SQL. Please consider below SQLs. CREATE TABLE MYGROUP (  PK_GROUP GUID DEFAULT 'newid()' NOT NULL,  DESCRIPTION Varchar(255),  LINKED_TO_GROUP GUID,  PRIMARY KEY (PK_GROUP)); COMMIT; INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES

Re: [firebird-support] How To Get Entire Linked Group Details

In tree format, the logical structure looks like as below: Vishal Group||---Vishal Group1| |Vishal Group1.1| |--Vishal Group1.1.1||---Vishal Group2| |Vishal Group2.1| |--Vishal Group2.1.1||---Vishal