[X] My Assistant

[gurpreetwalia]

create procedure sp_fetch
as
begin
select * from tablename
end
go

[gurpreetwalia]

I m firing a querry which executes in app. 20 minutes

how can i get the resultset in shortest time

Thanks in advance.

[PsychoCoder]

Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Please post like this:

Thank you for helping us helping you.

[Jayman]

Do you have a question relating to the stored procedure you posted?