You mentioned status field explicitly in select query and put * so there is already one status is filed there.so please remove first status.
This query will execute sucessfully
IF EXISTS(SELECT 1 FROM sys.objects where name='NewTable' and type='U')
begin
DROP TABLE NewTable
end
GO
select *
into NewTable from tbl_contract_emp_master TR inner join
TBL_IRIS_IMAGES_MASTER tm on tr.guid=tm.guid
and EP_NO in ('104536884','104541256','104564417','t12035676','104567770','104556221','104567536')
Malleswarareddy
I.T.Analyst
MCITP(70-451)