how to insert data into other table from subquery..?

See more:

SQL

i want to insert some data into other table but facing error..

insert into tbl_bank_mst
select CONVERT(varchar,'100'+ROW_NUMBER() over(order by t.a)) h,t.a,t.b,t.c,0,GETDATE(),null,'admin'  from
(
select distinct c_branch_name a,LEFT(c_branch_name,4) b,c_branch_name c from Tbl_Emp_Mst
where c_branch_name is not null and c_branch_name<>''
)t

error is like this ..pls tell me fast since it is very urgent

Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated.