I am new to Dynamic SQL so please bear with me. I know am trying to
make a dynamic query of a database. Let's say I one time might have
three benefits and another time four. I just don't know.
Consequently, when I make my dynamic query up I do a SELECT Column 1,
Column 2, Column 3 . I must also Define columns afterwards. This is
part of the problem. Since I don't know until I make up the dynamic
SQL, how many columns there will be, how can I Define Columns
afterwards? Even if this can be done, how may I return this resultset
to an ASP or ColdFusion page? Thanks for any help.
Greg
Received on Thu Feb 28 2002 - 21:29:41 CST
