I am using cursor, that is one contract at a time.
Kanwar
-----Original Message-----
From: Mat.Elkington
[mailto:mssqldba-ezmlmshield-x1006649.[Email address protected]
Sent: Friday, October 29, 2004 8:08 AM
To: LazyDBA Discussion
Subject: RE: parallel execution of query
So again, why not use a cursor...?
-----Original Message-----
From: Pollock Kirsty
[mailto:mssqldba-ezmlmshield-x76470629.[Email address protected]
Sent: 29 October 2004 14:56
To: LazyDBA Discussion
Subject: RE: parallel execution of query
I still don't see why that mandates doing one contract at a time as
opposed to a set-based operation.
> -----Original Message-----
> From: Singh Kanwar
> [mailto:mssqldba-ezmlmshield-x33555071.[Email address protected]
> Sent: 29 October 2004 14:27
> To: LazyDBA Discussion
> Subject: 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
---------------------------------------------------------------------
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.
**********************************************************************
---------------------------------------------------------------------
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