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.
Author |
Topic |
Karim174
Starting Member
5 Posts |
Posted - 2013-04-19 : 05:07:57
|
I'm trying to make that I have in my What'up. A hierarchical syntaxI have the following;I have the following tables that I use for making a hierarschische group syntax; ndevicegroupID, nparentgroupID and Sgroupname. These can be found in Device Group.Main has the following IDndevicegroupID nParentGroupID sgroupname192 0 EnvironmentThe next customer RB has a nparentgroupID and ndevicegroupID;ndevicegroupID nparentgroupID sgroupname45 192 RBAnd the customer also has locations;sgroupname nparentgroupid ndevicegroupidAPL 45 565and the location has sub locations;sgroupname nparentgroupID ndevicegroupIDSer1a 565 566I hope I can give to clarify enough information.Hope that this SQL syntax to make it right.SQL GETTING A DREAM |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-04-19 : 05:32:50
|
Hi, Duplicate thread : (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=184695)Can you post sample data of tables and also expected output (Expalin the logic for output)--Chandu |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
|
|
|