if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[table_1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[table_1]
insert into table_1
select '1',10,500,'001' union all
select '2',10,200,'002' union all
select '3',10,300,'003' union all
select '4',10,300,'003' union all
select '5',10,500,'001' union all
select '6',10,200,'002' union all
select '7',10,300,'003' union all
select '8',10,300,'003' union all
select '9',10,400,'004' union all
select '12',10,200,'002' union all
select '123',10,200,'002' union all
select '1234',10,300,'003'