Hello everyone. Here's my dilemma:

I'm creating a stored procedure which gathers data from several tables.
The last few columns however need to be dynamic and taken from rows of
another table. Here's an example:

Table:

Description Value
---------------------
Heading1 1.024
Heading2 2.031
....

Stored Proc.:

Other Columns... Heading1 Heading2 More Dynamic Headings...
-------------------------------------------------------------------------

................. 1.024 2.031
.................................


Is this possible? Any help would be appreciated,

Rick