Re: Re:Newbe question

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

Date: Wed, 30 Apr 2003 16:17:48 +0200

Perfect.
Just what I was looking for.

Thank you.
"Vishal Parkar" <vgparkar@hotmail.com> wrote in message
news:080901c30f1a$5dbcb380$a101280a@phx.gbl...
> basically you'll have to fire an update query to achieve
> desired result set
>
> eg
> update table set col3=col2
>
> --above update will copy content of the column col2 to col3
> --now to empty column col2 you'll have to fire following
> --update statement
>
> update table set col2=null
>
>
> --Vishal
>
> >-----Original Message-----
> >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:Newbe question
    ... basically you'll have to fire an update query to achieve ... --above update will copy content of the column col2 to col3 ... >The second column contains data that I want to move to ...
    (microsoft.public.sqlserver.security)
  • Re: Update - fill blank fields based on match
    ... I understand this is a bad design, ... update query rather than troll through the data manually and update it. ... UPDATE Table1 ... the second column only has data in the ...
    (microsoft.public.access.queries)
  • Re: Update - fill blank fields based on match
    ... Presumably you substituted your actual table name for Table1. ... update query rather than troll through the data manually and update it. ... > If you want to do it anyway, you could use a subquery to look up the> first ... the second column only has data in>> the ...
    (microsoft.public.access.queries)
  • Re: Update - fill blank fields based on match
    ... you would not want to design a table this way. ... If you want to do it anyway, you could use a subquery to look up the first non-blank DESC for the CODE, and use that in an Update query. ... UPDATE Table1 ... then look at the first rown in the second column then update the blank rows. ...
    (microsoft.public.access.queries)
  • Re: Update - fill blank fields based on match
    ... update query rather than troll through the data manually and update it. ... If you want to do it anyway, you could use a subquery to look up the first ... UPDATE Table1 ... the second column only has data in the ...
    (microsoft.public.access.queries)