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: Requery Parent Form
    ... The approach I would try would be to create an update query that would write ... customer ID, delete the record in the subform, then requery the subform. ... thought I might be able to do an After Update event on the void checkbox ...
    (microsoft.public.access.formscoding)
  • 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)
Loading