caper11752
IS-IT--Management
Hello,
Let's say I have a table called tblMyTable and it has 3 columns, MyId,FirstName,LastName. Is it possible to build a query that would return the column names as row values under a new column? Something like this:
MyNewColumnName
MyId
FirstName
LastName
I've done plenty of searching but couldn't find anything that actually worked. I need this query to populate values for a parameter in Report Builder. Thanks in advance.
Let's say I have a table called tblMyTable and it has 3 columns, MyId,FirstName,LastName. Is it possible to build a query that would return the column names as row values under a new column? Something like this:
MyNewColumnName
MyId
FirstName
LastName
I've done plenty of searching but couldn't find anything that actually worked. I need this query to populate values for a parameter in Report Builder. Thanks in advance.