Newbe question

From: Wayne Gore (wayne.gore_at_spray.se)
Date: 04/30/03 

Date: Wed, 30 Apr 2003 14:47:04 +0200

Hi

I have a table with 3 columns.
The first column is an ID column with identity on (seed 1).
The second column contains data that I want to move to the third column.
The data that is moved should be in the same row as before.
When the data has been moved then the second column should not contain any
data at all (but still exist).

Any ideas?

Regards
Rickard

Relevant Pages

  • Re: Help with chart
    ... Any idea on how to incorporate that into the chart? ... and datediff) as a second column. ... the third column would contain any field which would have non- ... You can also add a criteria to the first column with the ...
    (comp.databases.ms-access)
  • Re: Finding Max of a DB field and then return whole record grouping on one column
    ... I am trying to group on the first column and then find the Max of the second column, and where this is equal, to use the record which has the Max of the third column. ... can you ensure the order of the records is consistent? ...
    (microsoft.public.access.queries)
  • Re: please review my code
    ... thus spoke david: ... (setf (first column) ... (setf (second column) ... (setf (third column) ...
    (comp.lang.lisp)
  • Re: please review my code
    ... Stanisâaw Halik writes: ... (setf (first column) ... (setf (second column) ... (setf (third column) ...
    (comp.lang.lisp)
  • Re: please review my code
    ... pjb@xxxxxxxxxxxxxxxxx (Pascal J. Bourguignon) writes: ... (setf (first column) ... (setf (second column) ... (setf (third column) ...
    (comp.lang.lisp)