I'm creating a few SQL reports and i am currently looking at the Events table.
In there is a column named NetObjectType with values like N, HWHT, SMSA etc.
I would like to join the events to a table that has the definitions of all of these codes but i am yet to find the correct one.
Also the database hasn't got any Constraints to point me in the correct direction.
I have worked out that N is for Nodes but i don't want to go through them all manually and create my own table.
Any help is greatly appreciated.
What exactly are you trying to accomplish ? I don't think I've ever built any reports that reference that column.