Re: Update query SQL2000

From: Newbie (noidea_at_nospam.com)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 09:12:49 -0000

Never mind - I've worked it out
"Newbie" <noidea@nospam.com> wrote in message
news:elVEc2U%23EHA.2016@TK2MSFTNGP15.phx.gbl...
> Hi
> I am trying to write an update query that update the BG1 field in the
> Customer table with the BG value in the Agreements Table from a different
> database.
>
> Here is what I have so far . . . but it doesn't work - I get the error
>
> Server: Msg 8152, Level 16, State 2, Line 1
> String or binary data would be truncated.
> The statement has been terminated.
>
> UPDATE tblCustomer SET BG1 = A.BG From tblCustomer C, MIS.dbo.Agreements A
> WHERE C.Customer = A.Customer
>
> What am I doing wrong?
>

Relevant Pages

  • Re: REPLACING BLANK FIELDS WITH DATA BASED ON ANOTHER FIELD
    ... Bear in mind: ... I'm sure an Update query ... will do the trick but can't begin to suggest how to create it. ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Reverse True/False
    ... "Chris" wrote in message ... Bear in mind that this method may require you to rename some items accordingly. ... Run an update query on the table and update the new field to "Not ". ...
    (microsoft.public.access.queries)
  • Re: Design advice, please.
    ... > your update query. ... Opps. ... Never mind. ... Mis-interpreted method one. ...
    (microsoft.public.access.gettingstarted)
  • Update Query using an imported table
    ... I am attempting what I thought would be a simple update query between ... UPDATE Persons INNER JOIN Students ON Persons.= ... a newbie who should be asleep ...
    (microsoft.public.access.queries)
  • Update query SQL2000
    ... I am trying to write an update query that update the BG1 field in the ... Customer table with the BG value in the Agreements Table from a different ...
    (microsoft.public.sqlserver.mseq)