Hi Chris,

' Select......... into #Trades' is returning 29,287 rows

and Select .......... from #Trades is...

1)dbo.fn_ProfileWareHouse

------------------------------

ALTER FUNCTION dbo.fn_ProfileWareHouse

(

@ProfCode int,

@whcode varchar(10)

)

RETURNS @Warehouse TABLE (WHCode varchar(10) COLLATE DATABASE_DEFAULT not...

These are the functions which takes the parameters from the tables and returns the selected rows only.actually these functions have improved the performance instead of using original tables .

sorry to reduce it to one sec.

Hi chris by deploying your change the performance has improved from 1 min 33 secs to 56 sec. Can you pls give me some other suggestions to reduce it to...

Hi Chris, The prev one is the Gilamonster thread I had tried. The below one is yours I had tried.

DECLARE @ERROR INT

DECLARE @Profile...

I have tried like this but after running 2 to 3 times Proc is executing in 1 Min 33 secs.

alter ...

Please ignore the previous thread

Proc is returning 685 rows only for 5 days

279 was for 1 day

Sorry, I am actually fresher on this site. I thought sending threads to other sections will provide me more options.

Earlier Proc was returning 279 rows in 1 min 25 secs for 5 days.

Now it is returning 685 rows in 56 secs.

Hi Gail,

Can you pls give me the syntax for creating index on temp in the proc?

Hi Chris,

Thanks for your response. I tried with your scenarios(Select ...into #trades).

Now...

Thanks for the replies.

Actually 'select' is the slowest.