I made following stored procedure;
CREATE PROCEDURE [dbo].[BR1]
select substring([Tele No],2,7)as 'Phone No.', [Subscription Name], [Billing Month] from BR
ON BR.[Billing Month]= mn.mn
where [Tele No] like @phone
order by mn.Status ;
when i called this "BR1" stored procedure through my report project, it is taking 7 to 8 mins to retrieve records from SQL server, although when i called BR1 from Management studio it is retrieving within seconds.
Could you please help me in this matter.