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 and Insert
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
('
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 Gro
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 Group||---Vishal Group1| |V
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 J
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
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 group
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/
https://fi
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 Valie
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:
>
>
> Is it available in Engilsh ? so w
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
antie 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 Get E
:taru.kaukova...@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
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
Norbert, The SQL you hav
antie 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é : lundi 5 octobre 2015 11:15
À : firebird-support@yahoogroups.com
Objet : Re: Re: [firebird-support] How To Get Entire Link
I-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é : lundi 5 octobre 2015 11:15
À : firebird-support@yahoogroups.com
Objet : Re: Re: [firebird-support] How To Get Entire Linked Group
16 matches
Mail list logo