Ok, thanks for your help.

Thanks Gail. Didn't notice that.

Would you agree that the query I posted is suitable for querying plans in the cache and then seperating the statements using the offsets please?

thanks.

This is a similar version which I use. It removes the join to Requests and Sessions, and uses sys.dm_exec_query_stats to retrieve all plans from the cache.

Please let me know if...