This will match SQL Server statements to the appropriate portion of the execution plan based on the query_plan_hash

match_queries_by_hash.sql

 SELECT QueryPlanHash,
        CASE WHEN QueryType LIKE '%Stored Procedure%' THEN 
             QueryPlan.value('declare namespace p="http://schemas.microsoft.com/sqlserver/2004/07/showplan";
                              sum(//p:StmtSimple/@StatementSubTreeCost)', 'float')
             ELSE  
            QueryPlan.value('declare namespace p="http://schemas.microsoft.com/sqlserver/2004/07/showplan";
                             sum(//p:StmtSimple[xs:hexBinary(substring(@QueryPlanHash, 3)) = xs:hexBinary(sql:column("QueryPlanHash"))]/@StatementSubTreeCost)', 'float') 
             END AS cost, *
  FROM #procs