?
You can run it in 2 QA windows because those are 2 different connections to the database.
In a SPROC you have the same connection...
?

-----Original Message-----
From: Singh Kanwar
[mailto:mssqldba-ezmlmshield-x34974712.[Email address protected]
Sent: 28 October 2004 14:53
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]


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept for the presence of computer viruses but this in no way indicates that the message is virus free.
**********************************************************************


MS Sql Server LazyDBA home page