ETL Vendors by popularity

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for programmers

-- ETL Vendors by popularity

SELECT  TagName AS Tags,
        cnt AS [Questions Tagged],
        ROUND(100.0 * cnt / SUM(cnt) OVER (), 2) AS [Ratio, %]
FROM    Tags t
CROSS APPLY
        (
        SELECT  COUNT(*) AS cnt
        FROM    PostTags pt
        WHERE   pt.TagId = t.id
        ) q
WHERE   t.TagName IN ('pentaho','informatica','datastage','owb')
ORDER BY
        cnt DESC

created jul 29 10