Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to insert data from SQL server 2005 table into another table
0 views
Skip to first unread message
N.Ordiers
Apr 24, 2009, 1:28:11 PM4/24/09
to
I have the following problem. I am trying to insert data from one table into
another within the same database but keep getting errors. I not sure that my
code is correct, both table are identical as to field names, only the table
name is different. All the help is greatly appreciated! Here is the code I am
using:
--
INSERT INTO dbo.tbl_Diaz (BIC, Sample, SIC, Reviewer)
SELECT C.BIC, C.Sample, C.SIC, C.Reviewer
FROM dbo.SampleFetch_TAR AS C
WHERE C.Reviewer LIKE 'Diaz%';
--
--Error message--
Msg 8152, Level 16, State 14, Line 2
String or binary data would be truncated.
The statement has been terminated.
--end message
Thanks in advance
--
Error message
--
another within the same database but keep getting errors. I not sure that my
code is correct, both table are identical as to field names, only the table
name is different. All the help is greatly appreciated! Here is the code I am
using:
--
INSERT INTO dbo.tbl_Diaz (BIC, Sample, SIC, Reviewer)
SELECT C.BIC, C.Sample, C.SIC, C.Reviewer
FROM dbo.SampleFetch_TAR AS C
WHERE C.Reviewer LIKE 'Diaz%';
--
--Error message--
Msg 8152, Level 16, State 14, Line 2
String or binary data would be truncated.
The statement has been terminated.
--end message
Thanks in advance
--
Error message
--
0 new messages