It isn't redundant; the difference is t_mitm vs. t_sitm.

Put your query in a stored procedure, call the stored procedure from asp.net.

Follow the tips in this article to avoid parameter sniffing:

http://www.sommarskog.se/query-plan-mysteries.html