Using Data As Column Aliases

Hi,

I’m working with a really old design migrated to SQL 2005, in which I basically have two tables…

Table 1 contains all the “proper” data, and has columns called: col_1, col_2, col_3

Table 1’s data is something like:

col_1, col_2, col_3
Jack,jack@yahoo.ca,Toronto
Jill,jill@hotmail.com,Montreal

Table 2 contains meta-data for Table 1, specifically, it has two columns: column, meta-data

Table 2’s data is something like:

column,metadata
col_1,name
col_2,email
col_3,city

(Hopefully, my description of the design makes sense….basically; Table 2’s data describes what’s in each column of Table 1).

So, the question, if I want to write a ‘SELECT’ on Table 1, how can I use the data in Table 2 as aliases (or column) headers.

I’m currently going down the path of building dynamic SQL statements in T-SQL….but before I get too far, wanted to vet this idea here (it’s always been a fantastic resource for me)

Thanks in advance!