I'm having problems using an update query. I get the error: Server: Msg
8152, Level 16, State 9, Procedure SP_MemberUpdate, Line 3
String or binary data would be truncated.
The statement has been terminated.
I have 2 databases that I DTS data out of and create a view for each.
I'm trying to update from each view, but when I try the first update, I
get the error. I have an insert-Into, select query that works fine this
way. Help apprecaitd. Here is the query:
CREATE PROCEDURE [DBO].[SP_MemberUpdate] AS
UPDATE tMembers SET tMembers.CustomerNumber =
tMembers_View.CustomerNumber,
tMembers.CustomerName = tMembers_View.CustomerName,
tMembers.AddressLine1 = tMembers_View.AddressLine1,
tMembers.AddressLine2 = tMembers_View.AddressLine2,
tMembers.AddressLine3 = tMembers_View.AddressLine3,
tMembers.City = tMembers_View.City,
tMembers.State = tMembers_View.State,
tMembers.ZipCode = tMembers_View.ZipCode,
tMembers.CountryCode = tMembers_View.CountryCode,
tMembers.PhoneNumber = tMembers_View.PhoneNumber,
tMembers.FaxNumber = tMembers_View.FaxNumber,
tMembers.EmailAddress = tMembers_View.EmailAddress,
tMembers.URLAddress = tMembers_View.URLAddress,
tMembers.SalesPersonCode = tMembers_View.SalesPersonCode,
tMembers.Active = tMembers_View.Active,
tMembers.Siccode = tMembers_View.Siccode,
tMembers.sic_Description = tMembers_View.sic_Description,
tMembers.Stat = tMembers_View.Stat
FROM tMembers_View
WHERE tMembers.CustomerNumber = tMembers_View.CustomerNumber And
tMembers.CustomerName = tMembers_View.CustomerName
GO
Steve
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!