Solved

sql 2008 r2 Query problem

Posted on 2014-10-03
10
152 Views
Last Modified: 2014-10-03
Trying to run this query:

USE [Sipco]
GO

BEGIN TRANSACTION

INSERT INTO McCainBurley__Idaho_MISSING_BRUISE_FREE ([Id]
      ,[timestamp]
      ,[Field Number]
      ,[Cellar Number]
      ,[Rock]
      ,[Vegatative Material]
      ,[Contract_Information_Date_Printed_D]
      ,[Contract_Information_Time_Printed_T]
      ,[Contract_Information_Applicant_S]
      ,[Contract_Information_Certificate_No_I]
      ,[Contract_Information_Contract_No_I]
      ,[Contract_Information_Date_Received_D]
      ,[Contract_Information_Date_Inspected_D]
      ,[Contract_Information_Grower_S]
      ,[Contract_Information_Field_No_S]
      ,[Contract_Information_Total_Weight_I]
      ,[Contract_Information_Fee_F]
      ,[Contract_Information_Remarks_S]
      ,[Inspection_Sample_Breakdown_Total_Inspected_I]
      ,[Inspection_Sample_Breakdown_Water_Adjust_I]
      ,[Inspection_Sample_Breakdown_Ungraded_Produce_I]
      ,[Inspection_Sample_Breakdown_Graded_Produce_I]
      ,[Inspection_Sample_Breakdown_Rock_Dirt_Foreign_Material_Weight_I]
      ,[Inspection_Sample_Breakdown_Rock_Dirt_Foreign_Material_Percent_S]
      ,[Inspection_Sample_Breakdown_Rock_Dirt_Foreign_Material_Comment_S]
      ,[Inspection_Sample_Breakdown_Rocks_And_Clods_Weight_I]
      ,[Inspection_Sample_Breakdown_Rocks_And_Clods_Percent_S]
      ,[Inspection_Sample_Breakdown_rock_weight_scale_weight_I]
      ,[Inspection_Sample_Breakdown_rock_weight_scale_percent_S]
      ,[Inspection_Sample_Breakdown_total_dirt_and_foreign_material_weight_I]
      ,[Inspection_Sample_Breakdown_total_dirt_and_foreign_material_percent_S]
      ,[Graded_Produce_Breakdown_UNUSABLE_Weight_F]
      ,[Graded_Produce_Breakdown_UNUSABLE_Percent_S]
      ,[Graded_Produce_Breakdown_SMALLS_Weight_I]
      ,[Graded_Produce_Breakdown_SMALLS_Percent_S]
      ,[Graded_Produce_Breakdown__1_INCENTIVE_Weight_I]
      ,[Graded_Produce_Breakdown__1_INCENTIVE_Percent_F]
      ,[Graded_Produce_Breakdown__1_MINIMUM_Weight_I]
      ,[Graded_Produce_Breakdown__1_MINIMUM_Percent_F]
      ,[Graded_Produce_Breakdown__2_MINIMUM_Weight_I]
      ,[Graded_Produce_Breakdown__2_MINIMUM_Percent_F]
      ,[Graded_Produce_Breakdown__2_INCENTIVE_Weight_I]
      ,[Graded_Produce_Breakdown__2_INCENTIVE_Percent_F]
      ,[Graded_Produce_Breakdown_TOTAL__1_Weight_I]
      ,[Graded_Produce_Breakdown_TOTAL__1_Percent_S]
      ,[Graded_Produce_Breakdown__10_oz____Lgr_Weight_I]
      ,[Graded_Produce_Breakdown__10_oz____Lgr_Percent_S]
      ,[Special_Tests_Bruise_Tests_Bruise_Free_S]
      ,[Special_Tests_Bruise_Tests_Bruised_S]
      ,[Special_Tests_Bruise_Tests_Peel_Loss_F]
      ,[Special_Tests_FRY_COLOR_Strips_I]
      ,[Special_Tests_FRY_COLOR__0_I]
      ,[Special_Tests_FRY_COLOR__1_I]
      ,[Special_Tests_FRY_COLOR__2_I]
      ,[Special_Tests_FRY_COLOR__3_I]
      ,[Special_Tests_FRY_COLOR__4_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_Date_D]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_Date_D]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_Date_D]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_Date_D]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_Date_D]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__1_INCENTIVE_Graded_Weight_I]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__1_MINIMUM_Graded_Weight_F]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__2_MINIMUM_Graded_Weight_I]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__2_INCENTIVE_Graded_Weight_I]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages_UNUSABLE_Graded_Weight_I]
      ,[Worksheet_Detail_Other_Information_Water__1_pct__of_Produce__I]
      ,[Worksheet_Detail_Other_Information_UNUSABLE_F]
      ,[Worksheet_Detail_Other_Information_ROCK_AND_DIRT__as_calculated__I]
      ,[Worksheet_Detail_Other_Information_INT_ADJUSTMENTS_I]
      ,[Worksheet_Detail_Other_Information_ADJUSTED_UNUSABLE_S]
      ,[Worksheet_Detail_Other_Information_BRUISE_FREE_I]
      ,[Worksheet_Detail_Other_Information_BRUISED_I]
      ,[Worksheet_Detail_Other_Information_PEEL_LOSS_F]
      ,[Graded_Produce_Breakdown_UNUSABLE_Weight_S]
      ,[Graded_Produce_Breakdown_ROT_Weight_I]
      ,[Graded_Produce_Breakdown_ROT_Percent_S]
      ,[Graded_Produce_Breakdown_SUNBURN_LIGHT_GREEN_Weight_I]
      ,[Graded_Produce_Breakdown_SUNBURN_LIGHT_GREEN_Percent_S]
      ,[Graded_Produce_Breakdown_USABLE_Weight_I]
      ,[Graded_Produce_Breakdown_USABLE_Percent_F]
      ,[Graded_Produce_Breakdown_Smalls_Percent_F]
      ,[Graded_Produce_Breakdown_TOTAL_INC_Weight_I]
      ,[Graded_Produce_Breakdown_TOTAL_INC_Percent_S]
      ,[Special_Tests_Bruise_Tests_Peel_Loss_I]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages_USABLE_Graded_Weight_I]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages_Smalls_Graded_Weight_I]
      ,[Worksheet_Detail_Other_Information_UNUSABLE_S]
      ,[Worksheet_Detail_Other_Information_PEEL_LOSS_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_Date_D]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__2_INCENTIVE_Graded_Weight_F]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__1_MINIMUM_Graded_Weight_I]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_DISCOLOR_Damage_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_Date_D]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_Date_D]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__1_INCENTIVE_Graded_Weight_F]
      ,[Graded_Produce_Breakdown__2_MINIMUM_Weight_F]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__2_MINIMUM_Graded_Weight_F]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages_UNUSABLE_Graded_Weight_F]
      ,[Graded_Produce_Breakdown__1_INCENTIVE_Percent_I]
      ,[Graded_Produce_Breakdown__2_MINIMUM_Percent_I]
      ,[Graded_Produce_Breakdown__2_INCENTIVE_Percent_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_Date_D]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_Date_D]
      ,[Graded_Produce_Breakdown__1_MINIMUM_Percent_I]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_DISCOLOR_Serious_I]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_DISCOLOR_Serious_I]
      ,[Worksheet_Detail_Other_Information_TOTAL_UNUSABLE_I]
      ,[Worksheet_Detail_Other_Information_TOTAL_UNUSABLE_PERCENT_S]
      ,[Inspection_Sample_Breakdown_vegetative_weight_scale_weight_I]
      ,[Inspection_Sample_Breakdown_vegetative_weight_scale_percent_S]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_HOLLOW_HEART_Serious_I])
SELECT [Id]
      ,[timestamp]
      ,[Field Number]
      ,[Cellar Number]
      ,[Rock]
      ,[Vegatative Material]
      ,[Contract_Information_Date_Printed_D]
      ,[Contract_Information_Time_Printed_T]
      ,[Contract_Information_Applicant_S]
      ,[Contract_Information_Certificate_No_I]
      ,[Contract_Information_Contract_No_I]
      ,[Contract_Information_Date_Received_D]
      ,[Contract_Information_Date_Inspected_D]
      ,[Contract_Information_Grower_S]
      ,[Contract_Information_Field_No_S]
      ,[Contract_Information_Total_Weight_I]
      ,[Contract_Information_Fee_F]
      ,[Contract_Information_Remarks_S]
      ,[Inspection_Sample_Breakdown_Total_Inspected_I]
      ,[Inspection_Sample_Breakdown_Water_Adjust_I]
      ,[Inspection_Sample_Breakdown_Ungraded_Produce_I]
      ,[Inspection_Sample_Breakdown_Graded_Produce_I]
      ,[Inspection_Sample_Breakdown_Rock_Dirt_Foreign_Material_Weight_I]
      ,[Inspection_Sample_Breakdown_Rock_Dirt_Foreign_Material_Percent_S]
      ,[Inspection_Sample_Breakdown_Rock_Dirt_Foreign_Material_Comment_S]
      ,[Inspection_Sample_Breakdown_Rocks_And_Clods_Weight_I]
      ,[Inspection_Sample_Breakdown_Rocks_And_Clods_Percent_S]
      ,[Inspection_Sample_Breakdown_rock_weight_scale_weight_I]
      ,[Inspection_Sample_Breakdown_rock_weight_scale_percent_S]
      ,[Inspection_Sample_Breakdown_total_dirt_and_foreign_material_weight_I]
      ,[Inspection_Sample_Breakdown_total_dirt_and_foreign_material_percent_S]
      ,[Graded_Produce_Breakdown_UNUSABLE_Weight_F]
      ,[Graded_Produce_Breakdown_UNUSABLE_Percent_S]
      ,[Graded_Produce_Breakdown_SMALLS_Weight_I]
      ,[Graded_Produce_Breakdown_SMALLS_Percent_S]
      ,[Graded_Produce_Breakdown__1_INCENTIVE_Weight_I]
      ,[Graded_Produce_Breakdown__1_INCENTIVE_Percent_F]
      ,[Graded_Produce_Breakdown__1_MINIMUM_Weight_I]
      ,[Graded_Produce_Breakdown__1_MINIMUM_Percent_F]
      ,[Graded_Produce_Breakdown__2_MINIMUM_Weight_I]
      ,[Graded_Produce_Breakdown__2_MINIMUM_Percent_F]
      ,[Graded_Produce_Breakdown__2_INCENTIVE_Weight_I]
      ,[Graded_Produce_Breakdown__2_INCENTIVE_Percent_F]
      ,[Graded_Produce_Breakdown_TOTAL__1_Weight_I]
      ,[Graded_Produce_Breakdown_TOTAL__1_Percent_S]
      ,[Graded_Produce_Breakdown__10_oz____Lgr_Weight_I]
      ,[Graded_Produce_Breakdown__10_oz____Lgr_Percent_S]
      ,[Special_Tests_Bruise_Tests_Bruise_Free_S]
      ,[Special_Tests_Bruise_Tests_Bruised_S]
      ,[Special_Tests_Bruise_Tests_Peel_Loss_F]
      ,[Special_Tests_FRY_COLOR_Strips_I]
      ,[Special_Tests_FRY_COLOR__0_I]
      ,[Special_Tests_FRY_COLOR__1_I]
      ,[Special_Tests_FRY_COLOR__2_I]
      ,[Special_Tests_FRY_COLOR__3_I]
      ,[Special_Tests_FRY_COLOR__4_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_1_Date_D]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_2_Date_D]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_3_Date_D]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_4_Date_D]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_5_Date_D]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_MINIMUM_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data__2_INCENTIVE_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_MINIMUM_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_MINIMUM_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__2_INCENTIVE_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__1_INCENTIVE_Graded_Weight_I]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__1_MINIMUM_Graded_Weight_F]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__2_MINIMUM_Graded_Weight_I]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__2_INCENTIVE_Graded_Weight_I]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages_UNUSABLE_Graded_Weight_I]
      ,[Worksheet_Detail_Other_Information_Water__1_pct__of_Produce__I]
      ,[Worksheet_Detail_Other_Information_UNUSABLE_F]
      ,[Worksheet_Detail_Other_Information_ROCK_AND_DIRT__as_calculated__I]
      ,[Worksheet_Detail_Other_Information_INT_ADJUSTMENTS_I]
      ,[Worksheet_Detail_Other_Information_ADJUSTED_UNUSABLE_S]
      ,[Worksheet_Detail_Other_Information_BRUISE_FREE_I]
      ,[Worksheet_Detail_Other_Information_BRUISED_I]
      ,[Worksheet_Detail_Other_Information_PEEL_LOSS_F]
      ,[Graded_Produce_Breakdown_UNUSABLE_Weight_S]
      ,[Graded_Produce_Breakdown_ROT_Weight_I]
      ,[Graded_Produce_Breakdown_ROT_Percent_S]
      ,[Graded_Produce_Breakdown_SUNBURN_LIGHT_GREEN_Weight_I]
      ,[Graded_Produce_Breakdown_SUNBURN_LIGHT_GREEN_Percent_S]
      ,[Graded_Produce_Breakdown_USABLE_Weight_I]
      ,[Graded_Produce_Breakdown_USABLE_Percent_F]
      ,[Graded_Produce_Breakdown_Smalls_Percent_F]
      ,[Graded_Produce_Breakdown_TOTAL_INC_Weight_I]
      ,[Graded_Produce_Breakdown_TOTAL_INC_Percent_S]
      ,[Special_Tests_Bruise_Tests_Peel_Loss_I]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_USABLE_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_Smalls_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_USABLE_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_HOLLOW_HEART_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_HOLLOW_HEART_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INT_DISCOLOR_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INT_DISCOLOR_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INSECT_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INSECT_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_HEAT_IBS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_HEAT_IBS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INT_OTHER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INT_OTHER_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INT_CULLS_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_INT_CULLS_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_NEMATODE_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_NEMATODE_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_VAS_NET_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_VAS_NET_Serious_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_BROWN_CENTER_Damage_F]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight_Smalls_BROWN_CENTER_Serious_F]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages_USABLE_Graded_Weight_I]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages_Smalls_Graded_Weight_I]
      ,[Worksheet_Detail_Other_Information_UNUSABLE_S]
      ,[Worksheet_Detail_Other_Information_PEEL_LOSS_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_6_Date_D]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__2_INCENTIVE_Graded_Weight_F]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__1_MINIMUM_Graded_Weight_I]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_DISCOLOR_Damage_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_7_Date_D]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_8_Date_D]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__1_INCENTIVE_Graded_Weight_F]
      ,[Graded_Produce_Breakdown__2_MINIMUM_Weight_F]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages__2_MINIMUM_Graded_Weight_F]
      ,[Worksheet_Detail_Adjustments_to_Graded_Produce_Based_On_Percentages_UNUSABLE_Graded_Weight_F]
      ,[Graded_Produce_Breakdown__1_INCENTIVE_Percent_I]
      ,[Graded_Produce_Breakdown__2_MINIMUM_Percent_I]
      ,[Graded_Produce_Breakdown__2_INCENTIVE_Percent_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_9_Date_D]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_Grade_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_Air_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_H2O_Wt_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_H2O_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_Pulp_Temp_I]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_Specific_Gravity_F]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_Time_S]
      ,[Special_Tests_Specific_Gravity_Tests_Test_10_Date_D]
      ,[Graded_Produce_Breakdown__1_MINIMUM_Percent_I]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_INCENTIVE_INT_DISCOLOR_Serious_I]
      ,[Worksheet_Detail_Internal_Inspection_Data__1_MINIMUM_INT_DISCOLOR_Serious_I]
      ,[Worksheet_Detail_Other_Information_TOTAL_UNUSABLE_I]
      ,[Worksheet_Detail_Other_Information_TOTAL_UNUSABLE_PERCENT_S]
      ,[Inspection_Sample_Breakdown_vegetative_weight_scale_weight_I]
      ,[Inspection_Sample_Breakdown_vegetative_weight_scale_percent_S]
      ,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_HOLLOW_HEART_Serious_I]
  FROM [Sipco].[dbo].[McCain_-_Burley__Idaho]
where ([Special_Tests_Bruise_Tests_Bruise_Free_S] =0)
if @@error = 0
 DELETE  McCain_-_Burley__Idaho
where ([Special_Tests_Bruise_Tests_Bruise_Free_S] =0)
COMMIT

GO

Open in new window


I get this:

Msg 102, Level 15, State 1, Line 803
Incorrect syntax near '-'.

The table is called McCain_-_Burley__Idaho and really can not be renamed.

Is there anything I can do to get around this??

Thanks!!
0
Comment
Question by:HDM
  • 5
  • 2
  • 2
  • +1
10 Comments
 
LVL 39

Accepted Solution

by:
Kyle Abrahams earned 250 total points
ID: 40360191
you have to wrap it in []

eg:

 DELETE  from [McCain_-_Burley__Idaho]
where ([Special_Tests_Bruise_Tests_Bruise_Free_S] =0)
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 40360195
>The table is called McCain_-_Burley__Idaho and really can not be renamed.
Just a thought ... what {insert analogy for fine outstanding individual} decided the table can't be renamed?  For starters, having any characters other than underscore _ is going to force a developer to refer to it with square brackets [ ], as Kyle states above.  And with that many characters the table is just begging for a fat-finger typo or three.
0
 

Author Comment

by:HDM
ID: 40360224
Wonderful!!

But now I get one more little problem:

Msg 245, Level 16, State 1, Line 6
Conversion failed when converting the nvarchar value '58.31%' to data type int.
0
 
LVL 39

Expert Comment

by:Kyle Abrahams
ID: 40360232
delete FROM [Sipco].[dbo].[McCain_-_Burley__Idaho]
where (
--assuming everything follows the same format:
[Special_Tests_Bruise_Tests_Bruise_Free_S] = '0.00 %' or
--compare as varchar.
[Special_Tests_Bruise_Tests_Bruise_Free_S] = '0')
0
 

Author Comment

by:HDM
ID: 40360273
Now I get this:

,[Worksheet_Detail_Internal_Inspection_Data_as_a_Percentage_of_Sampled_Weight__1_INCENTIVE_HOLLOW_HEART_Serious_I]
  FROM [Sipco].[dbo].[McCain_-_Burley__Idaho]
where ([Special_Tests_Bruise_Tests_Bruise_Free_S] ='0.00%')
if @@error = 0
 DELETE  [Sipco].[dbo].[McCain_-_Burley__Idaho]
where ([Special_Tests_Bruise_Tests_Bruise_Free_S] ='0.00%')
COMMIT

GO

Msg 245, Level 16, State 1, Line 6
Conversion failed when converting the nvarchar value 'McCain - Burley, Idaho' to data type int.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:HDM
ID: 40360274
BTW--

I can open new questions for each of these if I need to.  Thanks so much for your help!!  :-)
0
 
LVL 65

Assisted Solution

by:Jim Horn
Jim Horn earned 250 total points
ID: 40360280
>Conversion failed when converting the nvarchar value '58.31%' to data type int.
Sounds like you'll need to do a bunch of transforms / conversions, as certain columns in your source table have characters that would not correctly convert to the target table data type (int).

For starters, you can remove the % character by REPLACE(column_name, '%', '')
Then since 58.31 is not an integer, and neither is .5831, you'll need to spell out for us how you wish this value to be stored, and we'll show you how to convert it.

>Conversion failed when converting the nvarchar value 'McCain - Burley, Idaho' to data type int.
Same as above, but I'd also check and make sure that all of your columns are correctly lined up between source and target, as that value cannot possibly be an int.  Or, you'll need to do a lookup and grab a value.

Sounds
0
 

Author Comment

by:HDM
ID: 40360298
Sweet!!  I got it working!!  :-)
0
 

Author Closing Comment

by:HDM
ID: 40360304
THANKS!!
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 40360728
809 lines of SQL, that should be in a code block please
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Suggested Solutions

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now