Find the cost and memory grant of queries in the plan cache

find-the-cost.sql

SELECT  qs.query_plan_hash ,
        query_plan.value('declare namespace p="http://schemas.microsoft.com/sqlserver/2004/07/showplan";
                             sum(//p:StmtSimple[xs:hexBinary(substring(@QueryHash, 3)) = xs:hexBinary(sql:column("qs.query_hash"))]/@StatementSubTreeCost)',
                         'float') AS cost ,
        query_plan.value('declare namespace p="http://schemas.microsoft.com/sqlserver/2004/07/showplan";
                            sum(//p:StmtSimple[xs:hexBinary(substring(@QueryHash, 3)) = xs:hexBinary(sql:column("qs.query_hash"))]/p:QueryPlan/p:MemoryGrantInfo/@SerialDesiredMemory)', 'float') AS serial_desired_memory,
        query_plan.value('declare namespace p="http://schemas.microsoft.com/sqlserver/2004
/07/showplan";
                            sum(//p:StmtSimple[xs:hexBinary(substring(@QueryHash, 3)) = xs:hexBinary(sql:column("qs.query_hash"))]/p:QueryPlan/p:MemoryGrantInfo/@SerialRequiredMemory)', 'float') AS serial_required_memory,
        *
FROM    sys.dm_exec_query_stats qs
        OUTER APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
ORDER BY 3 DESC

Updated the formatting and stuff.