HELP!! Column names form a query 1

[sto]

Is there a way to return the column names from a dynamic query?

 

[cLFlaVA]

What do you mean?

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?

 

[amorous]

Did you mean this:

select *
from information_schema.columns
where TABLE_CATALOG = 'yourdatabasename'

-VJ

 

[sto]

I am building a stored procedure to produces canned email with form letters. I want the to be dynamic enough that I can use this in other areas of the database. So the recordset will be dynamic. Because of this I need to extract the field names from a select statement so I can use it to build a letter.