CREATE TABLE [dbo].[test](
        [tran_id] [nvarchar](14) NULL,
        [type] [nvarchar](3) NULL,
        [emp] [nvarchar](5) NULL,
        [action] [nvarchar](4) NULL
) 


select * from test

INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '306', '306', 'PRB', '229', 'IHHE')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '306', '306', 'PRB', '229', 'CEMP')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '306', '306', 'PYN', '885', 'DHKP')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '306', '306', 'PYN', '885', 'INPH')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '314', '314', 'PRB', '881', 'CEMP')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '314', '314', 'PYA', '881', 'INPH')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '316', '316', 'PYN', '338', 'CEMP')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '320', '320', 'MLA', '877', 'CEMP')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '324', '324', 'PYA', '429', 'DHKP')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '334', '334', 'PYA', '906', 'DHKP')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '334', '334', 'CBK', '906', 'CEMP')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '346', '346', 'SHD', '630', 'GECD')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '360', '360', 'PYN', '669', 'CANC')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '360', '360', 'RAE', '669', 'GMVD')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '362', '362', 'PYA', '187', 'DHKP')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '362', '362', 'PYA', '187', 'INPH')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '362', '362', 'PYA', '187', 'DHKP')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '362', '362', 'PYA', '187', 'INPH')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '306', '306', 'PYN', '707', 'DHKP')
INSERT INTO test (  tran_id,tran_id,type,emp,action) VALUES (  '306', '306', 'PYN', '707', 'INPH')