StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PORetrieve column names from a different table?
primarykey
Id
518012
data
AcceptedAnswerId
0
AnswerCount
4
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-02-05T21:25:48.157
FavoriteCount
0
LastActivityDate
2009-02-06T00:46:14.117
LastEditDate
LastEditorUserId
0
OwnerUserId
21398
ParentId
0
PostTypeId
1
Score
0
ViewCount
845
LastEditorDisplayName
text
Body
I have a "datadump" table that has a bunch of mixed performance-related data. Something like: <pre><code>MachID TestDate MachType Value1 Value2 ... 00001 01/01/09 Server 15 48 00001 01/02/09 Server 16 99 19999 01/01/09 Switch 32 4.9880 19999 01/02/09 Switch 32 5.8109 </code></pre> The trick is that the "values" columns MEAN different things for different types of machines. So we have a "xRef" table that looks like: <pre><code>MachType Column Description Server Value1 Users Connected Server Value2 % CPU _total Switch Value1 Number of Ports Switch Value2 packets/ms ... </code></pre> I know, weird structure, but I didn't make it, and can't change it. I'd like to somehow "inner join" these so I can query the appropriate column headers based on the type of data. Something like this for the servers: <pre><code>MachID TestDate MachType Users Connected % CPU _total Total RAM 00001 01/01/09 Server 15 48 4096 00001 01/02/09 Server 16 99 4096 </code></pre> and this for the switches: <pre><code>MachID TestDate MachType Number of Ports packets/ms Total Cumulative kb 19999 01/01/09 Switch 32 4.9880 1024547 19999 01/02/09 Switch 32 5.8109 1029450 </code></pre> Is there a way to do this without doing individual hard-coded queries for each type? Note: I will only need to query one type of object at a time. Most likely, I'll only be looking at all results between particular dates for a single MachID, if that helps. This is MS SQL 2000. Thanks!
Tags
<sql><sql-server><pivot>
Title
Retrieve column names from a different table?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USBradC
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.