G
Guest
Hello;
I have a tranform query which shows:
Row: Col1 Col2 Col3 Col4 [Concatonation]
Fail: Rpt1 Rpt60 RptA Etc. Fail: Rpt1, Rpt60, RptA,
Is there a way to show the data values in a single column, as if
concatenating? I can build the concatenation expression "by hand" (manually
enter each column ref in the concatenation expression) but am looking for
some way to do this in an automated fashion as the columns will vary with
each query run, and I don't want to go in and manually edit the concat
expression. If this can be done in SQL 2005, then that would be better.
thanks, G
I have a tranform query which shows:
Row: Col1 Col2 Col3 Col4 [Concatonation]
Fail: Rpt1 Rpt60 RptA Etc. Fail: Rpt1, Rpt60, RptA,
Is there a way to show the data values in a single column, as if
concatenating? I can build the concatenation expression "by hand" (manually
enter each column ref in the concatenation expression) but am looking for
some way to do this in an automated fashion as the columns will vary with
each query run, and I don't want to go in and manually edit the concat
expression. If this can be done in SQL 2005, then that would be better.
thanks, G