Proving a query is inefficient can be hard, but with solid numbers to back you up, you’ll be able to prove that a huge query should be made into an SP.
SSMS: Client Stats

Proving a query is inefficient can be hard, but with solid numbers to back you up, you’ll be able to prove that a huge query should be made into an SP.