According to your comment for Mika I should remind you that you can use also use
functions
and
parameters
in you insert into statement in addition to source table fields :
INSERT INTO [t_attendence] (memcode, m_cardno, t_scantime, t_type, t_del, t_post, create_date, create_by, modify_date, modify_by)
select ([t_attendence_r].[m_memcode], [t_attendence_r].[m_cardno], [t_attendence_r].[t_scantime], 'Y', 'Y', 'Y', GETDATE(), @create_by, GETDATE(), @modify_by)
from [t_attendence_r]
Hope it helps.