for xml path concatenation ordered by seqno Xml Shredding First Query generate-data-combinations-for-a-column-dynamically-based-on-another-column-sql sum vs count with multiple options in group by clause How to find 2nd highest salary Kill all connections to given database ms sql where ,like testing sarthak rana