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