Home Forums SQL Server 7,2000 T-SQL stored procedure running slower than sql query RE: stored procedure running slower than sql query
kvishu83
SSC Eights!
Points: 848
More actions
November 3, 2016 at 1:35 pm
#1910463
This worked for me!
Added OPTION(Recompile) at the end of query in stored procedure.
Thanks
Vishwanath