Update query SQL2000

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

Date: Thu, 13 Jan 2005 08:55:18 -0000

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: Grouping or records
    ... There is no steadfast rule other than the person reding info sent by the ... customer or pulled from our records. ... can not run an UPDATE query to set the group id or even loop ... will release the exclusive lock so other users can get ...
    (microsoft.public.access.modulesdaovba)
  • Re: Grouped by not showing correct no recs
    ... Thanks for your response. ... > It would be helpful to see the SQL of your update query, ... > I want to run an update query to update the price in the customer table ... > I thought that since the original groupings came from the customer table ...
    (microsoft.public.access.modulesdaovba)
  • Re: Update Query question
    ... I wouldn't use an update query for this. ... calculated column whenever you need the customer number ... University of Maryland Baltimore County ...
    (microsoft.public.access.queries)
  • Re: How to "pad" a field
    ... You can create an Update Query and use the following in the Update to: ... Cheryl Fischer, MVP Microsoft Access ... The> customer numbers are either 3- or 4-digit. ...
    (microsoft.public.access.queries)
  • Re: Update query required?
    ... You can't add a field to a table with an update query. ... Can you get into design view and add the field to the customer table? ... customers already existing in my database with following information:- ... The type field doesn't already exist in my table. ...
    (microsoft.public.access.queries)