Kanwar,

No, you cannot execute concurrent processes within a stored procedure.
But SQL Server does have a solution to your problem, DTS.

Build a package that has as many concurrent tasks as you need and have each
task execute your stored proc.

John

-----Original Message-----
From: Singh Kanwar
[mailto:mssqldba-ezmlmshield-x34974712.[Email address protected]
Sent: Thursday, October 28, 2004 9:53 AM
To: LazyDBA Discussion
Subject: RE: parallel execution of query


My process takes a long time to run and needs to be run for every
contract and can be run at the same time using diff query analyzer
window at the same time, I was thinking of automating this within the
same proc.

Kanwar

-----Original Message-----
From: Pollock Kirsty
[mailto:mssqldba-ezmlmshield-x16411753.[Email address protected]
Sent: Thursday, October 28, 2004 7:31 AM
To: LazyDBA Discussion
Subject: RE: parallel execution of query

What do you mean by this?

Do you mean you want to execute 2 queries asynchronously from with the
same sp?

I curious as to why.

Kirsty

> -----Original Message-----
> From: Singh Kanwar
> [mailto:mssqldba-ezmlmshield-x10766619.[Email address protected]
> Sent: 28 October 2004 05:19
> To: LazyDBA Discussion
> Subject: parallel execution of query
>
> Hi All,
>
> I need to run more than one query at the same time within
> same stored proc.
>
> Thanks in advance
>
> Kanwar
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]

MS Sql Server LazyDBA home page