De-normalizing query

I have this table...

CREATE TABLE #Test (ID char(1), Seq int, Ch char(1))
INSERT #Test SELECT 'A',1,'A'
INSERT #Test SELECT 'A',2,'B'
INSERT #Test SELECT 'A',3,'C'
INSERT #Test SELECT 'B',1,'D'
INSERT #Test SELECT 'B',2,'E'
INSERT #Test SELECT 'B',3,'F'
INSERT #Test SELECT 'B',4,'G'

....and am searching for this query....

SELECT ID, Pattern=...?? FROM #Test....??

....to give this result, where Pattern is the ordered concatenation of
Ch for each ID:

ID Pattern
A ABC
B DEFG

Thanks for any help!

Jim

.

Relevant Pages

  • Re: Is abstract test pattern also stairway to heaven pattern?
    ... >An abstract test suite ABC' targets an abstract base class ABC. ... >Concrete classes A, B, and C derive from ABC. ... This is a pattern that I called Intelligent Children once a long time ...
    (comp.object)
  • Re: searching for a pattern for multiple matches
    ... abc 234.45.68.91 xyz ... pattern found? ... Now read both perlre and perlretut. ...
    (comp.lang.perl.misc)
  • Re: pattern serach over many files
    ... pattern "abc" and print the number of lines not containing the pattern ... How should the code change if I ... want to print the number of lines of each file containg the pattern ...
    (comp.lang.perl.misc)
  • Re: pattern serach over many files
    ... pattern "abc" and print the number of lines not containing the pattern ... 'def abc', 'dadq aft', `abc ttsg' are its contents. ... Tie::File (comes with Perl distro now) will ...
    (comp.lang.perl.misc)
  • Re: greedy v. non-greedy matching
    ... > Would anynoe care to enlighten me as to why the pattern ... > xyz 12345 abc ... matches the *first occurrence* of the pattern. ...
    (comp.lang.perl.misc)