rlevasseur
Programmer
I'm not sure if anyone can help me on this, and have not been able to find an example anywhere. I will give an oversimplified example here
TestTbl
Region State
---- ----
NEA CT Select Region, State
NEA MA From TestTbl
NEA ME Where Region = 'NEA'
NEA NH
NEA RI
NEA VT
What I would like the output to look like would be 1 record per region, with state values strung into a varachr column
Region States
NEA 'CT MA ME NH RI VT'
Some users have asked for a small enhancement to a report I have developed. WHat they woul like is a fotter line with children rolling up to level for report they selected.
The stored proc I wrote is dynamic and allows then to summarize data at any level. I want to tack on a column
containing the lower level child info.
Any help much appreciated
Tanks, Ray
TestTbl
Region State
---- ----
NEA CT Select Region, State
NEA MA From TestTbl
NEA ME Where Region = 'NEA'
NEA NH
NEA RI
NEA VT
What I would like the output to look like would be 1 record per region, with state values strung into a varachr column
Region States
NEA 'CT MA ME NH RI VT'
Some users have asked for a small enhancement to a report I have developed. WHat they woul like is a fotter line with children rolling up to level for report they selected.
The stored proc I wrote is dynamic and allows then to summarize data at any level. I want to tack on a column
containing the lower level child info.
Any help much appreciated
Tanks, Ray