Just another small advice:
Don't use stored proc input parameters directly in the WHERE clause of query, copy them into the local variables first and use the local variables instead.
It will prevent performance problems due to parameter sniffing.
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]