INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('ED ERROR'

,15453

,78798

,4

,'ED_THREE'

,5

,9

, 'UPDATE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('ED ERROR'

,13245

,5676

,4

,'ED_FOUR'

,5

,9

, 'UPDATE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('ED ERROR'

,3245

,9603

,4

,'ED_FOUR'

,5

,9

, 'DELETE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('HL ERROR'

,43543

,12324

,4

,'HL_FOUR'

,2

,4

, 'DELETE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('HL ERROR'

,15453

,78798

,4

,'HL_FIVE'

,5

,9

, 'UPDATE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('HL ERROR'

,4566

,42178

,4

,'HL_THREE'

,5

,9

, 'DELETE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('ED ERROR'

,15453

,78798

,4

,'ED_FIVE'

,5

,9

, 'DELETE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('ED ERROR'

,34320

,56896

,21345

,'ED_FIVE'

,5

,9

, 'UPDATE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('ED ERROR'

,565433

,78798

,4

,'ED_FIVE'

,5

,9

, 'DELETE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('O14 ERROR'

,45O43

,23452

,4

,'Q1_5'

,5

,9

, 'UPDATE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('O14 ERROR'

,1324

,23492

,4

,'Q1_7'

,5

,9

, 'UPDATE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('O14 ERROR'

,34954

,56766

,4

,'Q1_5'

,5

,9

, 'DELETE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('ED ERROR'

,45323

,67567

,4

,'ED_THREE'

,5

,9

, 'UPDATE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('ED ERROR'

,42543

,78454

,4

,'ED_FOUR'

,5

,9

, 'DELETE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('ED ERROR'

,32445

,58763

,4

,'ED_FOUR'

,5

,9

, 'DELETE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('HL ERROR'

,79985

,36743

,4

,'HL_FOUR'

,2

,4

, 'UPDATE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('HL ERROR'

,57972

,25654

,4

,'HL_FIVE'

,5

,9

, 'UPDATE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('HL ERROR'

,65776

,23634

,4

,'HL_THREE'

,5

,9

, 'DELETE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('ED ERROR'

,67898

,14365

,4

,'ED_FIVE'

,5

,9

, 'UPDATE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('ED ERROR'

,46765

,56543

,25

,'ED_FIVE'

,5

,9

, 'DELETE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('ED ERROR'

,36545

,67567

,4

,'ED_FIVE'

,5

,9

, 'DELETE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('O14 ERROR'

,56546

,65456

,4

,'Q1_5'

,5

,9

, 'UPDATE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('O14 ERROR'

,35657

,99674

,4

,'Q1_7'

,5

,9

, 'UPDATE')

INSERT INTO [janinetestdata].[dbo].[TEST]

([ERRORMESSAGE]

,[BATCH_NO]

,[zBarcode]

,[Incorrect_Value]

,[Columns_To_Fix]

,[Person_No]

,[Corrected_Value]

,[Command]

)

VALUES

('O14 ERROR'

,23455

,67563

,4

,'Q1_5'

,5

,9

, 'DELETE')

INSERT INTO [janinetestdata].[dbo].[HH_LISTING]([ERRORMESSAGE],Command,[Person_No]

,[HL_THREE]

,[HL_FOUR]

,[HL_FIVE]

,[HL_SIX]

,[HL_SEVEN]

,[HL_SEVENB]

,[zBarcode]) VALUES('HL', 'INSERT','1' , 3 , 4 , 6 , 8 , 6 , 8 , 15011 )

INSERT INTO [janinetestdata].[dbo].[HH_ALL]([ERRORMESSAGE],Command,[BATCH_NO]

,[Cluster]

,[HHNUM]

,[zBarcode]

,[District]

,[URBAN_RURAL]

,[Final_Result_Code]

,[Person_No])VALUES('HH', 'INSERT',36157 , 2 , 3 , 5678 , 5 , 6 , 8 , 1 )

INSERT INTO [janinetestdata].[dbo].[EDUCATION]([ERRORMESSAGE],Command,[ED_THREE]

,[ED_FOUR]

,[ED_FIVE]

,[ED_SIX]

,[Person_No]

,[zBarcode]) VALUES('ED', 'INSERT',2,3,7,5,3,4237)

INSERT INTO [janinetestdata].[dbo].[FOURTEEN_ALL]([ERRORMESSAGE],Command, [BATCH_NO]

,[zBarcode]

,[HHBarcode]

,[Person_No]

,[District]

,[URBAN_RURAL]

,[Cluster]

,[HHNUM]

,[Final_Result_Code]

,[Q1_5]

,[Q1_5_DKNS]

,[Q1_7]

,[Q1_8]

,[Q1_9]

,[Q1_9_2]

,[Q1_10a]

,[Q1_10b]

,[Q1_10c]

,[Q1_10_Total]

,[Q1_11]

,[Q1_12]

,[Q1_13]

,[Q1_14]

,[Q1_15]

,[Q1_15a]

,[Q1_16]

,[Q1_17]

,[Q1_18]

,[Q1_19]

,[Q1_20]

,[Q1_21]

,[Q1_22]

,[Q1_23]

,[Q1_24]

,[Q1_25]

,[Q1_26]

,[Q1_27]

,[Q1_28_MAIN]

,[Q1_28_OTHER]

,[Q1_28_PREVIOUS]

,[Q1_29_SEASONAL]

,[Q1_29_YEARROUND]

,[Q1_30_MAIN]

,[Q1_30_OTHER]

,[Q1_30_PREVIOUS]

,[Q1_31_MAIN]

,[Q1_31_OTHER]

,[Q1_31_PREVIOUS]

,[Q1_32_MAIN]

,[Q1_32_OTHER]

,[Q1_32_TOTAL]

,[Q1_33_MAIN]

,[Q1_33_OTHER]

,[Q1_33_TOTAL]

,[Q1_35]

,[Q1_37]

,[Q1_38]

,[Q1_39]

,[Q1_40]

,[Q1_41]

,[Q1_41_DKNS]

,[Q1_41a]

,[Q1_41b]

,[Q1_41b_DKNS]

,[Q1_42]

,[Q1_42_DKNS]

,[Q1_43]

,[Q1_44])

VALUES('O14', 'INSERT',36122 , 21593 , 3 , '1' , 4 , 4 , 7 , 9 , 3 , 4 , 5 , 5 , '5' , 5 , 5 , 5 , 5 , 5 , 5 , 5 , 5 , 5 , 5 , 5 , 5 , 5 , '5' , 5 , 5 , 5 , 5 , '5' , '5' , 5 , 5 , 5 , 5 , 5 , 5 , 5 , 5 , 5 , '5' , '5' , '5' , '5' , '5' , '5' , 5 , 5 , 5 , 5 , 5 , 5 , 5 , 5 , 5 , '5' , '5' , 5 , 5 , 5 , 5 , 5 , 5 , 5 , 5 , 5)