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:09:08
|
| 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 |
|
|
|
|
|
How to make this a Hierarchy syntax?