SQL Query asked by moazzam

select A.bundleid,B.featureid,B.featurecount from (SELECT p1.bundleid,

      cast( ( SELECT featureid + ','

           FROM kepmax_bundlefeature p2

          WHERE p2.bundleid = p1.bundleid

          ORDER BY featureid

            FOR XML PATH('') ) as varchar(8000)) AS featureid, max(cast(FeatureCount as decimal)) as FeatureCount

      FROM kepmax_bundlefeature p1

      GROUP BY bundleid) A
inner join
(select featureid, max(cast(FeatureCount as decimal)) as featurecount from (
    SELECT p1.bundleid,

      cast( ( SELECT featureid + ','

           FROM kepmax_bundlefeature p2

          WHERE p2.bundleid = p1.bundleid

          ORDER BY featureid

            FOR XML PATH('') ) as varchar(8000)) AS featureid, max(cast(FeatureCount as decimal)) as FeatureCount

      FROM kepmax_bundlefeature p1

      GROUP BY bundleid) as T
group by featureid ) B
on A.featureid = B.featureid and A.FeatureCount = B.FeatureCount
order by cast(bundleid as decimal)