desiredforsome
asked on
SQL QUery Error string or binary data would be truncated
Here is my query -
Here is what it is outputting and I cant find my error.
INSERT OUTLOOKREPORT.DBO.loanselect
( Borrower
, [address]
, [status]
, xrefid
)
SELECT a.BorrowerFirstName + ' ' + a.BorrowerLastname
, a.Address1
, a.CurrentMileStoneName
, a.xrefid
FROM emdb.emdbuser.loansummary a
LEFT
JOIN OUTLOOKREPORT.DBO.loanselect b ON a.XREFID = b.XREFID
WHERE b.XREFID IS NULL
--Inserts xrefid from Encompass into Interface
INSERT OUTLOOKREPORT.DBO.xrefidtable
( xrefid
)
SELECT a.xrefid
FROM emdb.emdbuser.loansummary a
LEFT
JOIN OUTLOOKREPORT.DBO.xrefidtable b ON a.XREFID = b.XREFID
WHERE b.XREFID IS NULL
Here is what it is outputting and I cant find my error.
Msg 8152, Level 16, State 4, Line 1
String or binary data would be truncated.
The statement has been terminated.
(0 row(s) affected)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!!!