>Here's the SQL
>
>insert into StudentLookup
> Select SCN, Sname = (SLastName + ', ' + SFirstName), TCN, TName, chngdate = getdate() from qryICECLExport
>
>
>The error I'm getting is:
>
>Msg 8152, Level 16, State 4, Line 1
>String or binary data would be truncated.
>The statement has been terminated.
>
>I thought perhaps the SName field wasn't long enough, so I expanded it (still in development phase of project), but I'm still getting the error.
>
You need to look at every field in the StudentLookup table and compare with the resulting structure of your Export table.
You may find this blog post helpful to find maximum length of value of every field:
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/maximum-length-of-data-in
If it's not broken, fix it until it is.
My Blog