----- Original Message -----
From: Jeremy Brodie
To: CF-Talk
Sent: Friday, February 13, 2004 9:04 AM
Subject: Re:OT- Sort of Loop in SQL
Could you tell us what database you are using? There are major differences between Oracle and SQL Server for the strategy and syntax to use in this case.
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]
