Posted - 04/19/2013 : 05:09:08
| I'm trying to make that I have in my What'up. A hierarchical syntax
I 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 ID
ndevicegroupID nParentGroupID sgroupname
192 0 Environment
The next customer RB has a nparentgroupID and ndevicegroupID;
ndevicegroupID nparentgroupID sgroupname
45 192 RB
And the customer also has locations;
sgroupname nparentgroupid ndevicegroupid
APL 45 565
and the location has sub locations;
sgroupname nparentgroupID ndevicegroupID
Ser1a 565 566
I hope I can give to clarify enough information.
Hope that this SQL syntax to make it right.
SQL GETTING A DREAM