This would sound rather strange to you guys but here it is.
I have this sql that I execute in query analyzer and it takes about 4 sec to return 55 records. Now when I wrap this sql in a stored procedure it takes close to about 5 min to execute. I dont understand this and has been driving most of us crazy.
Did someone in this discussion board encounter a similiar problem and what they did to resolve the problem.
Thanks for any help.