Jeremy Brodie
Edgewater Technology
web: http://www.edgewater.com
phone:(703) 815-2500
email: [EMAIL PROTECTED]
>What are cursors? Could you show me some sample code?
> ----- Original Message -----
> From: MILAN MUSHRAN
> To: CF-Talk
> Sent: Friday, February 13, 2004 8:30 AM
> Subject: RE: OT- Sort of Loop in SQL
>
>
> You can use cursors.
>
> >From: "Mickael" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: OT- Sort of Loop in SQL
> >Date: Fri, 13 Feb 2004 08:23:04 -0500
> >
> >Hi All,
> >
> >I know how complete the following task in CF and SQL but I was wondering if
> >there is a way to do it with only SQL. What I am trying to do is modify
> >records sequentially in my database.
> >
> >I have a field in my database called destination, this is an office
> >location. And I have many records in my database that I would like to
> >assign 1/3 of the records to each of the three offices. I don't want to
> >just do an update top (then 1/3) and set the office to each of the office
> >ids. I was wondering if there is a way in SQL to update the first record
> >to the first office ID, then the second record to the second office id,
> >then the third to the third office id, then the forth record to the first
> >office id and continue that way.
> >
> >Is this possible in SQL? There are Network security issues that won't let
> >me connect to this database with CF.
> >
> >Mike
> >
> >
> >
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
