SQL Server - Multiple Plans

multiplePlans.sql

SELECT TOP 100
       query_hash        AS [Query Hash]
     , COUNT(query_hash) AS [Plan Count]
     , (
           SELECT TOP 1 text
             FROM sys.dm_exec_query_stats qs
             CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
            WHERE pc.query_hash = qs.query_hash
       ) AS [Query Text]
  FROM sys.dm_exec_query_stats pc
 GROUP BY query_hash
HAVING COUNT(1) > 1
 ORDER BY [Plan Count] DESC