How do I return an empty result set from a procedure using T-SQL?

If you need column names in the response then proceed with the select TOP 0 * from that table, otherwise just use SELECT TOP 0 NULL. It should work pretty fast 🙂