Can you isolate the contract ids that have been added/modified since the last run, and process them as a set?
P
-----Original Message-----
From: Singh Kanwar
[mailto:mssqldba-ezmlmshield-x33555071.[Email address protected]
Sent: Friday, October 29, 2004 9:27 AM
To: LazyDBA Discussion
Subject: SUSPECT: RE: parallel execution of query
i do not know all the contractIDs in the advance, it has to be picked up from other table at the time of execution, because the contractids keep changing. because of nature of work, DTS is not feasable.
Thanks
KP
________________________________
From: Vonesh John [mailto:mssqldba-ezmlmshield-x36647980.[Email address protected]
Sent: Fri 10/29/2004 5:16 AM
To: LazyDBA Discussion
Subject: RE: parallel execution of query
How would that help???
Scheduling an agent job has nothing to do with concurrent processes, it only
starts a job!
The original author is looking for a way to start several instances of a
stored procedure concurrently and the best solution for that is DTS. It will
take some work tho, because I am guessing that in order to have your process
work for a given contract, you have to pass the contract ID in some way.
Still it is doable as long as you know the metrics up front.
John
-----Original Message-----
From: Entena Raymond
[mailto:mssqldba-ezmlmshield-x78106217.[Email address protected]
Sent: Friday, October 29, 2004 5:49 AM
To: LazyDBA Discussion
Subject: RE: parallel execution of query
or maybe you can create an SQL server agent job and schedule it in the
time that you need them to run.
-----Original Message-----
From: Vonesh John
[mailto:mssqldba-ezmlmshield-x61344429.[Email address protected]
Sent: Thursday, October 28, 2004 10:01 PM
To: LazyDBA Discussion
Subject: RE: parallel execution of query
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]
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
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