Thought it was something like that. The DTS solution already mentioned
is the only option that I can think of.

Although, if it were me, I'd be tempted to look at optimising the code

> -----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]
>
>

MS Sql Server LazyDBA home page