Subselect with inline comma delimited query result

Categories: Development, Transact SQL
Comments: 1 Comment
Published on: August 31, 2010

I needed to write a query that would output a list of entities, with a subselect containing all of it’s related entities (could be multiple) in a comma separated list. This was for a one time report, so performance was not a concern, just simplicity. This post has a solution that dominated my task, check it out!

1 Comment - Leave a comment
  1. Joe Banken says:

    Just tried it out and it was handy. Nice post.

Leave a comment

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>