Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Apr 26, 2012 01:38 PM|LINK
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: