Link to home
Start Free TrialLog in
Avatar of lapucca
lapucca

asked on

how to fix error with this vague msg?

How can I find out which column to fix?  Thank you.

(58 row(s) affected)
Msg 8152, Level 16, State 4, Line 12
String or binary data would be truncated.
The statement has been terminated.

if exists (
    select  * from tempdb.dbo.sysobjects o
    where o.xtype in ('U') 
   and o.id = object_id(N'tempdb..#tempNonExistDoctors')
)
	DROP TABLE #tempNonExistDoctors;

select * into #tempNonExistDoctors from dbo.Doctors
where personID is null;


INSERT INTO [MedDb].[dbo].[person]
           ([Employee_Last_Name]
           ,[Employee_First_Name]
           ,[Employee_Middle_Name]
           ,[Title]
           ,[Clinical_Narrative]
           ,[Best_Doctor]
			,Web_address
           ,[appt_emails])
Select lastname, First_Name, MiddleName,credentials,bio,best_doctor, links, appt_emails from #tempNonExistDoctors

DROP TABLE #tempNonExistDoctors;

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of _agx_
_agx_
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lapucca
lapucca

ASKER

Understand, thank you