Error converting datatypes ('NULL' to int and VARCHAR to int)
-
Hello - my issue is that I need to get 5 rows of data from my PROD system down to my PROD-LIKE system, but I am running into a datatype conversion error that I cannot find the culprit to (it's a fairly wide table, and I just cannot find the error anywhere).
Here is the T-SQL, and the errors that go with it.
SET NOCOUNT ONGO
SET IDENTITY_INSERT [dbo].[BBSKUData] ON
GO
INSERT INTO [dbo].[BBSKUData] (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891339','0.01','317','3','LIQCDM14X','7120174','765','LIQCDM14X','4.00071E+11','NULL','BRIGHTSTAR US','0','1314389','11146','0.01','00:00.0','NULL','NULL','39:31.0','','','Y','Y','','Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','NULL','NULL','0','N','N','0','LIQCDM14X','','NULL','N','0','0','','0','N','','A','N','0','0','1','NULL','0','0','0','0','N','N','N','MOCK HARDWARE','','N','N','0','DIGITAL COMMUNICATIO','N','N','1','0','N','N','0','N','N','Y','N','N','NULL','N','N','N','N','N','N','','NULL','N','N','NULL','Y','Y','','0','N','N','N','N','N','0.01','0.01','0.01','0.01','LIQCDM14X','No Sign','B','POSTPAID MOCK','33','0.01','0','0','0','0','0','4.00071E+11','','LIQCDM14X','','','','N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','32:05.9','30:00.7','','');
INSERT INTO [dbo].[BBSKUData] (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891340','0.01','317','3','LIQCDM189','7120183','765','LIQCDM189','4.00071E+11','NULL','BRIGHTSTAR US','0','1314390','11146','0.01','00:00.0','NULL','NULL','39:31.0','','','Y','Y','','Cellular Plans','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','NULL','NULL','0','N','Y','0','LIQCDM189','','NULL','N','0','0','','0','N','','A','N','0','1','1','NULL','0','0','0','0','Y','N','N','MOCK HARDWARE','','N','N','0','DIGITAL COMMUNICATIO','N','N','1','1','N','N','0','Y','N','Y','Y','Y','NULL','N','N','N','N','N','N','','NULL','N','Y','NULL','Y','Y','','0','N','Y','N','N','N','0.01','0.01','0.01','0.01','LIQCDM189','No Sign','B','POSTPAID MOCK','33','0.01','0','0','0','0','0','4.00071E+11','','LIQCDM189','','','','N','800001024','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','32:05.9','30:01.5','','');
INSERT INTO [dbo].[BBSKUData] (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891341','0.01','317','3','LIQGSM159','7121049','765','LIQGSM159','4.00071E+11','NULL','BRIGHTSTAR US','0','1314391','11146','0.01','00:00.0','NULL','NULL','39:31.0','','','Y','Y','','Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','NULL','NULL','0','N','Y','0','LIQGSM159','','NULL','N','0','0','','0','N','','A','N','0','1','1','NULL','0','0','0','0','Y','N','N','MOCK HARDWARE','','N','N','0','DIGITAL COMMUNICATIO','N','N','1','1','N','N','0','Y','N','Y','Y','Y','NULL','N','N','N','N','N','N','','NULL','N','Y','NULL','Y','Y','','0','N','Y','N','N','N','0.01','0.01','0.01','0.01','LIQGSM159','No Sign','B','POSTPAID MOCK','33','0.01','0','0','0','0','0','4.00071E+11','','LIQGSM159','','','','N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','32:05.9','30:01.6','','');
INSERT INTO [dbo].[BBSKUData] (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891978','0.01','317','3','CDMA 8 DIGIT ALPHA/NUMERIC','7149863','765','CDMA 8 DIGIT ALPHA/NUMERIC','4.00071E+11','NULL','BRIGHTSTAR US','0','1316869','11146','0.01','00:00.0','NULL','NULL','36:51.2','','','Y','Y','','Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','NULL','NULL','0','N','Y','0','CDMA 8 DIGI','','NULL','N','0','0','','0','N','','A','N','0','1','1','NULL','0','0','0','0','Y','N','N','MOCK HARDWARE','','N','N','0','DIGITAL COMMUNICATIO','N','N','1','1','N','N','0','Y','N','Y','Y','Y','NULL','N','N','N','N','N','N','','NULL','N','Y','NULL','Y','Y','','0','N','Y','N','N','N','0.01','0.01','0.01','0.01','CDMA 8 DIGIT ALPHA/N','No Sign','B','POSTPAID MOCK','33','0.01','0','0','0','0','0','4.00071E+11','','CDMA 8 DIGIT ALPHA/NUMERIC','','','','N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','30:57.3','30:01.6','','');
INSERT INTO [dbo].[BBSKUData] (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891977','0.01','317','3','CDMA 11 DIGIT NUMERIC','7150059','765','CDMA 11 DIGIT NUMERIC','4.00072E+11','NULL','BRIGHTSTAR US','0','1316868','11146','0.01','00:00.0','NULL','NULL','36:51.2','','','Y','Y','','Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','NULL','NULL','0','N','Y','0','CDMA 11 DIG','','NULL','N','0','0','','0','N','','A','N','0','1','1','NULL','0','0','0','0','Y','N','N','MOCK HARDWARE','','N','N','0','DIGITAL COMMUNICATIO','N','N','1','1','N','N','0','Y','N','Y','Y','Y','NULL','N','N','N','N','N','N','','NULL','N','Y','NULL','Y','Y','','0','N','Y','N','N','N','0.01','0.01','0.01','0.01','CDMA 11 DIGIT NUMERI','No Sign','B','POSTPAID MOCK','33','0.01','0','0','0','0','0','4.00072E+11','','CDMA 11 DIGIT NUMERIC','','','','N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','30:57.3','30:01.6','','');
SET IDENTITY_INSERT [dbo].[BBSKUData] OFF
GO
This generates the following...
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'NULL' to data type int.
So - I highlighted the text and swap out the NULLs for blank values. That now looks like this...
SET NOCOUNT ONGO
SET IDENTITY_INSERT [dbo].[BBSKUData] ON
GO
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891339','0.01','317','3','LIQCDM14X','7120174','765','LIQCDM14X','400071201748','','BRIGHTSTAR US','0','1314389','11146','0.01','2012-11-15','','','2012-11-13','','','Y','Y','','Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','','','0','N','N','0','LIQCDM14X','','','N','0','0','','0','N','','A','N','0','0','1','','0','0','0','0','N','N','N','MOCK HARDWARE','NULL','N','N','0','DIGITAL COMMUNICATION','N','N','1','0','N','N','0','N','N','Y','N','N','NULL','N','N','N','N','N','N','','NULL','N','N','NULL','Y','Y','','0','N','N','N','N','N','0.01','0.01','0.01','0.01','LIQCDM14X','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071201748','','LIQCDM14X','','','','N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-13','2013-04-13','','');
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891340','0.01','317','3','LIQCDM189','7120183','765','LIQCDM189','400071201830','','BRIGHTSTAR US','0','1314390','11146','0.01','2012-11-15','','','2012-11-13','','','Y','Y','','Cellular Plans','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','','','0','N','Y','0','LIQCDM189','','','N','0','0','','0','N','','A','N','0','1','1','','0','0','0','0','Y','N','N','MOCK HARDWARE','NULL','N','N','0','DIGITAL COMMUNICATION','N','N','1','1','N','N','0','Y','N','Y','Y','Y','NULL','N','N','N','N','N','N','','NULL','N','Y','NULL','Y','Y','','0','N','Y','N','N','N','0.01','0.01','0.01','0.01','LIQCDM189','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071201830','','LIQCDM189','','','','N','800001024','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-13','2013-04-20','','');
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891341','0.01','317','3','LIQGSM159','7121049','765','LIQGSM159','400071210498','','BRIGHTSTAR US','0','1314391','11146','0.01','2012-11-15','','','2012-11-13','','','Y','Y','','Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','','','0','N','Y','0','LIQGSM159','','','N','0','0','','0','N','','A','N','0','1','1','','0','0','0','0','Y','N','N','MOCK HARDWARE','NULL','N','N','0','DIGITAL COMMUNICATION','N','N','1','1','N','N','0','Y','N','Y','Y','Y','NULL','N','N','N','N','N','N','','NULL','N','Y','NULL','Y','Y','','0','N','Y','N','N','N','0.01','0.01','0.01','0.01','LIQGSM159','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071210498','','LIQGSM159','','','','N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-13','2013-04-08','','');
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891978','0.01','317','3','CDMA 8 DIGIT ALPHA/NUMERIC','7149863','765','CDMA 8 DIGIT ALPHA/NUMERIC','400071498636','','BRIGHTSTAR US','0','1316869','11146','0.01','2012-11-15','','','2012-11-16','','','Y','Y','','Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','','','0','N','Y','0','CDMA 8 DIGI','','','N','0','0','','0','N','','A','N','0','1','1','','0','0','0','0','Y','N','N','MOCK HARDWARE','NULL','N','N','0','DIGITAL COMMUNICATION','N','N','1','1','N','N','0','Y','N','Y','Y','Y','NULL','N','N','N','N','N','N','','NULL','N','Y','NULL','Y','Y','','0','N','Y','N','N','N','0.01','0.01','0.01','0.01','CDMA 8 DIGIT ALPHA/N','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071498636','','CDMA 8 DIGIT ALPHA/NUMERIC','','','','N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-16','2013-04-08','','');
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891977','0.01','317','3','CDMA 11 DIGIT NUMERIC','7150059','765','CDMA 11 DIGIT NUMERIC','400071500599','','BRIGHTSTAR US','0','1316868','11146','0.01','2012-11-15','','','2012-11-16','','','Y','Y','','Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','','','0','N','Y','0','CDMA 11 DIG','','','N','0','0','','0','N','','A','N','0','1','1','','0','0','0','0','Y','N','N','MOCK HARDWARE','NULL','N','N','0','DIGITAL COMMUNICATION','N','N','1','1','N','N','0','Y','N','Y','Y','Y','NULL','N','N','N','N','N','N','','NULL','N','Y','NULL','Y','Y','','0','N','Y','N','N','N','0.01','0.01','0.01','0.01','CDMA 11 DIGIT NUMERI','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071500599','','CDMA 11 DIGIT NUMERIC','','','','N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-16','2013-04-08','','');
SET IDENTITY_INSERT [dbo].[BBSKUData] OFF
GO
But it now generates this following error...
Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to numeric.
I did start to put some of the NULL values back in with the second attempt (just too see if that error would come back - to try and narrow down where in the VALUES the issue is coming from, but I had no luck with that).
Any and all help as to what I am doing wrong would be much appreciated. Here is the DDL of the table I am trying to get the data into:
SET ANSI_NULLS ONGO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BBSKUData](
[DataID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[Cost] [float] NULL,
[Class] [int] NULL,
[Dept] [int] NULL,
[MfgPartNo] [varchar](75) NULL,
[SKU] [int] NULL,
[SubClass] [int] NULL,
[Title] [varchar](125) NULL,
[UPC] [varchar](25) NULL,
[VendorNo] [int] NULL,
[Vendor] [varchar](75) NULL,
[Processed] [bit] NOT NULL CONSTRAINT [DF_Processed] DEFAULT ((0)),
[ContentID] [int] NULL,
[MFGID] [int] NULL,
[RetailPrice] [money] NULL,
[InStockDate] [datetime] NULL,
[B2BRecovery] [decimal](6, 2) NULL,
[B2CRecovery] [decimal](6, 2) NULL,
[LastUpdated] [datetime] NULL,
[Add_Cust_Info_Ind] [varchar](1) NULL,
[Alert_Info_Cmnt] [varchar](255) NULL,
[Authorized_To_Sell_Ind] [varchar](1) NULL,
[BBY_AAS_Exclude_Ind] [varchar](6) NULL,
[Color] [varchar](12) NULL,
[Category_Name] [varchar](70) NULL,
[Description] [varchar](50) NULL,
[Item_Weight] [decimal](12, 4) NULL,
[Item_Length] [decimal](12, 4) NULL,
[Item_Height] [decimal](12, 4) NULL,
[Item_Width] [decimal](12, 4) NULL,
[Shipping_Length] [decimal](12, 4) NULL,
[Shipping_Weight] [decimal](12, 4) NULL,
[Shipping_Height] [decimal](12, 4) NULL,
[Shipping_Width] [decimal](12, 4) NULL,
[BBY_Accessory_Ind] [varchar](6) NULL,
[BBY_Always_Devo_Flag] [varchar](1) NULL,
[BBY_Devo_Ind] [varchar](6) NULL,
[BBY_Exchange_Days] [numeric](4, 0) NULL,
[BBY_High] [numeric](3, 0) NULL,
[BBY_Home_Delivery_Ind] [varchar](6) NULL,
[BBY_JunkOut_Dstry_InField_Flag] [varchar](1) NULL,
[BBY_Map_End_Date] [datetime] NULL,
[BBY_Map_Start_Date] [datetime] NULL,
[BBY_Mfg_Warranty_Length] [numeric](3, 0) NULL,
[BBY_One_Way_Ind] [varchar](6) NULL,
[BBY_Open_Box_Return] [varchar](1) NULL,
[BBY_Open_Box_RTV_Days] [numeric](4, 0) NULL,
[BBY_PLU] [varchar](11) NULL,
[BBY_Product_Line] [varchar](2) NULL,
[BBY_RA_Request_Date] [datetime] NULL,
[BBY_Repairable_Flag] [varchar](1) NULL,
[BBY_Restock_Fee_PCT] [numeric](3, 0) NULL,
[BBY_Return_Handling] [decimal](20, 4) NULL,
[BBY_Return_Handling_Ind] [varchar](1) NULL,
[BBY_RTV_Days] [numeric](4, 0) NULL,
[BBY_Serial_NBR_FOR_Return_Flag] [varchar](1) NULL,
[Size] [varchar](12) NULL,
[Status] [varchar](6) NULL,
[BBY_Special_Orders_Ind] [varchar](1) NULL,
[BBY_Suggest_Sell_Price_Dscnt] [decimal](12, 4) NULL,
[BBY_Tech_Check_Flag] [varchar](1) NULL,
[BBY_Tie] [numeric](3, 0) NULL,
[BBY_VNDR_Disc_Date] [datetime] NULL,
[BBY_Warranty_Labor_Days] [numeric](3, 0) NULL,
[BBY_Warranty_Labor_Years] [numeric](2, 0) NULL,
[BBY_Warranty_Parts_Days] [numeric](3, 0) NULL,
[BBY_warranty_Parts_Years] [numeric](2, 0) NULL,
[BBYSupport_FCTRY_WRNTY_Ind] [varchar](1) NULL,
[BBYSVC_Outsd_FCTry_WRNTY] [varchar](1) NULL,
[BBYSVC_Under_FCTry_WRNTY] [varchar](1) NULL,
[Class_Name] [varchar](20) NULL,
[Component_Return_Desc] [varchar](60) NULL,
[Consignment_Ind] [varchar](1) NULL,
[Cust_Capture_Ind] [varchar](1) NULL,
[Cust_Data_Check_Req_Ind] [varchar](6) NULL,
[Dept_Name] [varchar](20) NULL,
[Dispose_Ind_Store_Ind] [varchar](1) NULL,
[Freight_Charge_Ind] [varchar](1) NULL,
[Freight_Terms] [varchar](2) NULL,
[FunctionalCheck_LVL] [varchar](1) NULL,
[GiftCard_Ind] [varchar](1) NULL,
[GL_OverRide] [varchar](1) NULL,
[Handling_PCT] [numeric](12, 4) NULL,
[Liquidateable_Ind] [varchar](1) NULL,
[Media_DC_PRCS_Ind] [varchar](1) NULL,
[Merchandise_Ind] [varchar](1) NULL,
[OpenBox_Resell_Ind] [varchar](1) NULL,
[OpenBox_Return_Ind] [varchar](1) NULL,
[Original_Retail] [decimal](20, 4) NULL,
[Quick_Servce_Advntge_Elig_Ind] [varchar](1) NULL,
[Rapd_Exchg_Call_Vendor_Ind] [varchar](1) NULL,
[Rapd_Exchg_Fact_Warr_Ind] [varchar](1) NULL,
[Rapd_Exchg_Fee_Ind] [varchar](1) NULL,
[Rapd_Exchg_Under_PRP_Ind] [varchar](1) NULL,
[Rapd_Exchg_Under_PSP_Ind] [varchar](1) NULL,
[Rapid_Exchange_Ind] [varchar](1) NULL,
[Recommend_Retail] [numeric](12, 4) NULL,
[Recycle_Req_Ind] [varchar](1) NULL,
[Resell_Ind] [varchar](1) NULL,
[Restock_Fee] [numeric](12, 4) NULL,
[Ret_Allow_Ind] [varchar](1) NULL,
[Ret_Auth_Req] [varchar](1) NULL,
[Ret_Courier] [varchar](20) NULL,
[Ret_Min_Dol_Amt] [numeric](20, 4) NULL,
[Ret_Only_Ind] [varchar](1) NULL,
[Return_Ind] [varchar](1) NULL,
[RTV_Always_Ind] [varchar](1) NULL,
[Serial_NBR_RTN_Ind] [varchar](1) NULL,
[Serialized_Item_Ind] [varchar](1) NULL,
[Ship_Carton_HGT] [decimal](12, 4) NULL,
[Ship_Carton_LEN] [decimal](12, 4) NULL,
[Ship_Carton_WID] [decimal](12, 4) NULL,
[Ship_Carton_WT] [decimal](12, 4) NULL,
[Short_Description] [varchar](20) NULL,
[Sign_Description] [varchar](50) NULL,
[SKU_Chain_Ind_Flag] [varchar](1) NULL,
[Sub_Name] [varchar](20) NULL,
[SKU_Type] [varchar](50) NULL,
[Unit_Cost_1] [numeric](20, 4) NULL,
[Unit_Cost_2] [numeric](20, 4) NULL,
[Unit_Cost_3] [numeric](20, 4) NULL,
[UPC_1] [varchar](20) NULL,
[UPC_2] [varchar](20) NULL,
[UPC_3] [varchar](20) NULL,
[UPC_4] [varchar](20) NULL,
[Vendor_Contact_Desc] [varchar](60) NULL,
[VPN_1] [varchar](30) NULL,
[VPN_2] [varchar](30) NULL,
[VPN_3] [varchar](30) NULL,
[Warranty_Document_URL] [varchar](250) NULL,
[Activation_Req_Ind] [varchar](1) NULL,
[Cohort_Code] [varchar](70) NULL,
[Ship_Dimensions_UOM] [varchar](10) NULL,
[Ship_Weight_UOM] [varchar](10) NULL,
[Ship_Cubic_Dimensions] [decimal](20, 4) NULL,
[Item_Dimensions_UOM] [varchar](10) NULL,
[Item_Weight_UOM] [varchar](10) NULL,
[Item_Cubic_Dimensions] [decimal](20, 4) NULL,
[Carton_Dimension_UOM] [varchar](10) NULL,
[Carton_Weight_UOM] [varchar](10) NULL,
[Carton_Cubic_Dimensions] [decimal](12, 4) NULL,
[Brand] [varchar](40) NULL,
[DateAdded] [datetime] NULL,
[LastRetekUpdated] [datetime] NULL
) ON [PRIMARY]
SET ANSI_PADDING OFF
ALTER TABLE [dbo].[BBSKUData] ADD [Game_Platform] [varchar](6) NULL
ALTER TABLE [dbo].[BBSKUData] ADD [Genre] [varchar](6) NULL
/****** Object: Index [PK_BBSKUData] Script Date: 05/22/2013 16:21:40 ******/
ALTER TABLE [dbo].[BBSKUData] ADD CONSTRAINT [PK_BBSKUData] PRIMARY KEY CLUSTERED
(
[DataID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Thank you all again...
SQL_ME_RICH
-
Instead of replacing 'NULL' with '', try replacing 'NULL' with NULL
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);- Forum Etiquette: How to post Reporting Services problems
[/url]- Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]- How to Post Performance Problems - by Gail Shaw
[/url] -
Hey Mister Magoo!
Well - that definitely changed things, but now it creates a whole new error all together (I went back to the first set of INSERT statements, and took your advice to simply change 'NULL' to NULL), but now I get this...
Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
Msg 242, Level 16, State 3, Line 2
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
Msg 242, Level 16, State 3, Line 3
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
Msg 242, Level 16, State 3, Line 4
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
Msg 242, Level 16, State 3, Line 5
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
P.S. I mistitled my post here - in the second set of INSERTS it isn't varchar to int, but varchar to numeric. I've been looking at data from that prespective (at numeric type datatype columns), but no luck there either.
-
SQL_ME_RICH (5/22/2013)
Hey Mister Magoo!Well - that definitely changed things, but now it creates a whole new error all together (I went back to the first set of INSERT statements, and took your advice to simply change 'NULL' to NULL), but now I get this...
Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
Msg 242, Level 16, State 3, Line 2
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
Msg 242, Level 16, State 3, Line 3
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
Msg 242, Level 16, State 3, Line 4
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
Msg 242, Level 16, State 3, Line 5
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
P.S. I mistitled my post here - in the second set of INSERTS it isn't varchar to int, but varchar to numeric. I've been looking at data from that prespective (at numeric type datatype columns), but no luck there either.
It looks like you have problems with the way you are scripting out this data. your first post had two examples of the data, the one where you had 'NULL' values also had problems with InStockDate... You aren't using that one?
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);- Forum Etiquette: How to post Reporting Services problems
[/url]- Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]- How to Post Performance Problems - by Gail Shaw
[/url] -
SQL_ME_RICH (5/22/2013)
Hey Mister Magoo!Well - that definitely changed things, but now it creates a whole new error all together (I went back to the first set of INSERT statements, and took your advice to simply change 'NULL' to NULL), but now I get this...
Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
Msg 242, Level 16, State 3, Line 2
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
Msg 242, Level 16, State 3, Line 3
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
Msg 242, Level 16, State 3, Line 4
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
Msg 242, Level 16, State 3, Line 5
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.
P.S. I mistitled my post here - in the second set of INSERTS it isn't varchar to int, but varchar to numeric. I've been looking at data from that prespective (at numeric type datatype columns), but no luck there either.
Your dates are in a strange format that SQL cannot handle. The dates in your insert statement are all '##:##:#', i.e.
SELECT CAST('39:31.0' AS DATETIME) -
Try Replacing 'NULL' WITH NULL (i.e. Removing Single quotes from NULL value), and there are some problem in the value list pass by you.
-
Yeah - I have a section where the dates were off, and another where they were not off. The one where the dates were correct, I went back and took the single quotes out of the NULL values, but I am still getting a datatype conversion error going from varchar to numeric. Here is that code...
--***3rd Try***SET NOCOUNT ON
GO
SET IDENTITY_INSERT [dbo].[BBSKUData] ON
GO
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891339','0.01','317','3','LIQCDM14X','7120174','765','LIQCDM14X','400071201748','','BRIGHTSTAR US','0','1314389','11146','0.01','2012-11-15','','','2012-11-13','','','Y','Y','','Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','','','0','N','N','0','LIQCDM14X','','','N','0','0','','0','N','','A','N','0','0','1','','0','0','0','0','N','N','N','MOCK HARDWARE',NULL,'N','N','0','DIGITAL COMMUNICATION','N','N','1','0','N','N','0','N','N','Y','N','N',NULL,'N','N','N','N','N','N','',NULL,'N','N',NULL,'Y','Y','','0','N','N','N','N','N','0.01','0.01','0.01','0.01','LIQCDM14X','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071201748','','LIQCDM14X','','','','N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-13','2013-04-13','','');
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891340','0.01','317','3','LIQCDM189','7120183','765','LIQCDM189','400071201830','','BRIGHTSTAR US','0','1314390','11146','0.01','2012-11-15','','','2012-11-13','','','Y','Y','','Cellular Plans','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','','','0','N','Y','0','LIQCDM189','','','N','0','0','','0','N','','A','N','0','1','1','','0','0','0','0','Y','N','N','MOCK HARDWARE',NULL,'N','N','0','DIGITAL COMMUNICATION','N','N','1','1','N','N','0','Y','N','Y','Y','Y',NULL,'N','N','N','N','N','N','',NULL,'N','Y',NULL,'Y','Y','','0','N','Y','N','N','N','0.01','0.01','0.01','0.01','LIQCDM189','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071201830','','LIQCDM189','','','','N','800001024','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-13','2013-04-20','','');
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891341','0.01','317','3','LIQGSM159','7121049','765','LIQGSM159','400071210498','','BRIGHTSTAR US','0','1314391','11146','0.01','2012-11-15','','','2012-11-13','','','Y','Y','','Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','','','0','N','Y','0','LIQGSM159','','','N','0','0','','0','N','','A','N','0','1','1','','0','0','0','0','Y','N','N','MOCK HARDWARE',NULL,'N','N','0','DIGITAL COMMUNICATION','N','N','1','1','N','N','0','Y','N','Y','Y','Y',NULL,'N','N','N','N','N','N','',NULL,'N','Y',NULL,'Y','Y','','0','N','Y','N','N','N','0.01','0.01','0.01','0.01','LIQGSM159','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071210498','','LIQGSM159','','','','N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-13','2013-04-08','','');
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891978','0.01','317','3','CDMA 8 DIGIT ALPHA/NUMERIC','7149863','765','CDMA 8 DIGIT ALPHA/NUMERIC','400071498636','','BRIGHTSTAR US','0','1316869','11146','0.01','2012-11-15','','','2012-11-16','','','Y','Y','','Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','','','0','N','Y','0','CDMA 8 DIGI','','','N','0','0','','0','N','','A','N','0','1','1','','0','0','0','0','Y','N','N','MOCK HARDWARE',NULL,'N','N','0','DIGITAL COMMUNICATION','N','N','1','1','N','N','0','Y','N','Y','Y','Y',NULL,'N','N','N','N','N','N','',NULL,'N','Y',NULL,'Y','Y','','0','N','Y','N','N','N','0.01','0.01','0.01','0.01','CDMA 8 DIGIT ALPHA/N','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071498636','','CDMA 8 DIGIT ALPHA/NUMERIC','','','','N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-16','2013-04-08','','');
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891977','0.01','317','3','CDMA 11 DIGIT NUMERIC','7150059','765','CDMA 11 DIGIT NUMERIC','400071500599','','BRIGHTSTAR US','0','1316868','11146','0.01','2012-11-15','','','2012-11-16','','','Y','Y','','Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N','','Y','0','1','N','','','','0','N','Y','0','CDMA 11 DIG','','','N','0','0','','0','N','','A','N','0','1','1','','0','0','0','0','Y','N','N','MOCK HARDWARE',NULL,'N','N','0','DIGITAL COMMUNICATION','N','N','1','1','N','N','0','Y','N','Y','Y','Y',NULL,'N','N','N','N','N','N','',NULL,'N','Y',NULL,'Y','Y','','0','N','Y','N','N','N','0.01','0.01','0.01','0.01','CDMA 11 DIGIT NUMERI','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071500599','','CDMA 11 DIGIT NUMERIC','','','','N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-16','2013-04-08','','');
SET IDENTITY_INSERT [dbo].[BBSKUData] OFF
GO
-
YES! I figured it out...I decided since all the fields in this table were nullable to go ahead and replace all blank columns with NULL. I then ran that and found that a string would not go because it would be truncated, and remembered that I had tried to fix a data entry in one of the columns by completing the phrase. That caused it to be off by 1 character, and the columns datatype was set to VARCHAR(20).
Here is the working result...
--***4th Try***SET NOCOUNT ON
GO
SET IDENTITY_INSERT [dbo].[BBSKUData] ON
GO
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891339','0.01','317','3','LIQCDM14X','7120174','765','LIQCDM14X','400071201748',NULL,'BRIGHTSTAR US','0','1314389','11146','0.01','2012-11-15',NULL,NULL,'2012-11-13',NULL,NULL,'Y','Y',NULL,'Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N',NULL,'Y','0','1','N',NULL,NULL,NULL,'0','N','N','0','LIQCDM14X',NULL,NULL,'N','0','0',NULL,'0','N',NULL,'A','N','0','0','1',NULL,'0','0','0','0','N','N','N','MOCK HARDWARE',NULL,'N','N','0','DIGITAL COMMUNICATIO','N','N','1','0','N','N','0','N','N','Y','N','N',NULL,'N','N','N','N','N','N',NULL,NULL,'N','N',NULL,'Y','Y',NULL,'0','N','N','N','N','N','0.01','0.01','0.01','0.01','LIQCDM14X','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071201748',NULL,'LIQCDM14X',NULL,NULL,NULL,'N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-13','2013-04-13',NULL,NULL);
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891340','0.01','317','3','LIQCDM189','7120183','765','LIQCDM189','400071201830',NULL,'BRIGHTSTAR US','0','1314390','11146','0.01','2012-11-15',NULL,NULL,'2012-11-13',NULL,NULL,'Y','Y',NULL,'Cellular Plans','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N',NULL,'Y','0','1','N',NULL,NULL,NULL,'0','N','Y','0','LIQCDM189',NULL,NULL,'N','0','0',NULL,'0','N',NULL,'A','N','0','1','1',NULL,'0','0','0','0','Y','N','N','MOCK HARDWARE',NULL,'N','N','0','DIGITAL COMMUNICATIO','N','N','1','1','N','N','0','Y','N','Y','Y','Y',NULL,'N','N','N','N','N','N',NULL,NULL,'N','Y',NULL,'Y','Y',NULL,'0','N','Y','N','N','N','0.01','0.01','0.01','0.01','LIQCDM189','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071201830',NULL,'LIQCDM189',NULL,NULL,NULL,'N','800001024','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-13','2013-04-20',NULL,NULL);
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891341','0.01','317','3','LIQGSM159','7121049','765','LIQGSM159','400071210498',NULL,'BRIGHTSTAR US','0','1314391','11146','0.01','2012-11-15',NULL,NULL,'2012-11-13',NULL,NULL,'Y','Y',NULL,'Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N',NULL,'Y','0','1','N',NULL,NULL,NULL,'0','N','Y','0','LIQGSM159',NULL,NULL,'N','0','0',NULL,'0','N',NULL,'A','N','0','1','1',NULL,'0','0','0','0','Y','N','N','MOCK HARDWARE',NULL,'N','N','0','DIGITAL COMMUNICATIO','N','N','1','1','N','N','0','Y','N','Y','Y','Y',NULL,'N','N','N','N','N','N',NULL,NULL,'N','Y',NULL,'Y','Y',NULL,'0','N','Y','N','N','N','0.01','0.01','0.01','0.01','LIQGSM159','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071210498',NULL,'LIQGSM159',NULL,NULL,NULL,'N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-13','2013-04-08',NULL,NULL);
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891978','0.01','317','3','CDMA 8 DIGIT ALPHA/NUMERIC','7149863','765','CDMA 8 DIGIT ALPHA/NUMERIC','400071498636',NULL,'BRIGHTSTAR US','0','1316869','11146','0.01','2012-11-15',NULL,NULL,'2012-11-16',NULL,NULL,'Y','Y',NULL,'Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N',NULL,'Y','0','1','N',NULL,NULL,NULL,'0','N','Y','0','CDMA 8 DIGI',NULL,NULL,'N','0','0',NULL,'0','N',NULL,'A','N','0','1','1',NULL,'0','0','0','0','Y','N','N','MOCK HARDWARE',NULL,'N','N','0','DIGITAL COMMUNICATIO','N','N','1','1','N','N','0','Y','N','Y','Y','Y',NULL,'N','N','N','N','N','N',NULL,NULL,'N','Y',NULL,'Y','Y',NULL,'0','N','Y','N','N','N','0.01','0.01','0.01','0.01','CDMA 8 DIGIT ALPHA/N','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071498636',NULL,'CDMA 8 DIGIT ALPHA/NUMERIC',NULL,NULL,NULL,'N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-16','2013-04-08',NULL,NULL);
INSERT INTO dbo.BBSKUData (DataID,Cost,Class,Dept,MfgPartNo,SKU,SubClass,Title,UPC,VendorNo,Vendor,Processed,ContentID,MFGID,RetailPrice,InStockDate,B2BRecovery,B2CRecovery,LastUpdated,Add_Cust_Info_Ind,Alert_Info_Cmnt,Authorized_To_Sell_Ind,BBY_AAS_Exclude_Ind,Color,Category_Name,[Description],Item_Weight,Item_Length,Item_Height,Item_Width,Shipping_Length,Shipping_Weight,Shipping_Height,Shipping_Width,BBY_Accessory_Ind,BBY_Always_Devo_Flag,BBY_Devo_Ind,BBY_Exchange_Days,BBY_High,BBY_Home_Delivery_Ind,BBY_JunkOut_Dstry_InField_Flag,BBY_Map_End_Date,BBY_Map_Start_Date,BBY_Mfg_Warranty_Length,BBY_One_Way_Ind,BBY_Open_Box_Return,BBY_Open_Box_RTV_Days,BBY_PLU,BBY_Product_Line,BBY_RA_Request_Date,BBY_Repairable_Flag,BBY_Restock_Fee_PCT,BBY_Return_Handling,BBY_Return_Handling_Ind,BBY_RTV_Days,BBY_Serial_NBR_FOR_Return_Flag,[Size],[Status],BBY_Special_Orders_Ind,BBY_Suggest_Sell_Price_Dscnt,BBY_Tech_Check_Flag,BBY_Tie,BBY_VNDR_Disc_Date,BBY_Warranty_Labor_Days,BBY_Warranty_Labor_Years,BBY_Warranty_Parts_Days,BBY_warranty_Parts_Years,BBYSupport_FCTRY_WRNTY_Ind,BBYSVC_Outsd_FCTry_WRNTY,BBYSVC_Under_FCTry_WRNTY,Class_Name,Component_Return_Desc,Consignment_Ind,Cust_Capture_Ind,Cust_Data_Check_Req_Ind,Dept_Name,Dispose_Ind_Store_Ind,Freight_Charge_Ind,Freight_Terms,FunctionalCheck_LVL,GiftCard_Ind,GL_OverRide,Handling_PCT,Liquidateable_Ind,Media_DC_PRCS_Ind,Merchandise_Ind,OpenBox_Resell_Ind,OpenBox_Return_Ind,Original_Retail,Quick_Servce_Advntge_Elig_Ind,Rapd_Exchg_Call_Vendor_Ind,Rapd_Exchg_Fact_Warr_Ind,Rapd_Exchg_Fee_Ind,Rapd_Exchg_Under_PRP_Ind,Rapd_Exchg_Under_PSP_Ind,Rapid_Exchange_Ind,Recommend_Retail,Recycle_Req_Ind,Resell_Ind,Restock_Fee,Ret_Allow_Ind,Ret_Auth_Req,Ret_Courier,Ret_Min_Dol_Amt,Ret_Only_Ind,Return_Ind,RTV_Always_Ind,Serial_NBR_RTN_Ind,Serialized_Item_Ind,Ship_Carton_HGT,Ship_Carton_LEN,Ship_Carton_WID,Ship_Carton_WT,Short_Description,Sign_Description,SKU_Chain_Ind_Flag,Sub_Name,SKU_Type,Unit_Cost_1,Unit_Cost_2,Unit_Cost_3,UPC_1,UPC_2,UPC_3,UPC_4,Vendor_Contact_Desc,VPN_1,VPN_2,VPN_3,Warranty_Document_URL,Activation_Req_Ind,Cohort_Code,Ship_Dimensions_UOM,Ship_Weight_UOM,Ship_Cubic_Dimensions,Item_Dimensions_UOM,Item_Weight_UOM,Item_Cubic_Dimensions,Carton_Dimension_UOM,Carton_Weight_UOM,Carton_Cubic_Dimensions,Brand,DateAdded,LastRetekUpdated,Game_Platform,Genre) VALUES ('1891977','0.01','317','3','CDMA 11 DIGIT NUMERIC','7150059','765','CDMA 11 DIGIT NUMERIC','400071500599',NULL,'BRIGHTSTAR US','0','1316868','11146','0.01','2012-11-15',NULL,NULL,'2012-11-16',NULL,NULL,'Y','Y',NULL,'Cellular Phones','BEST BUY LIQCDM14X','0.01','0.01','0.01','0.01','0.01','0.01','0.01','0.01','N',NULL,'Y','0','1','N',NULL,NULL,NULL,'0','N','Y','0','CDMA 11 DIG',NULL,NULL,'N','0','0',NULL,'0','N',NULL,'A','N','0','1','1',NULL,'0','0','0','0','Y','N','N','MOCK HARDWARE',NULL,'N','N','0','DIGITAL COMMUNICATIO','N','N','1','1','N','N','0','Y','N','Y','Y','Y',NULL,'N','N','N','N','N','N',NULL,NULL,'N','Y',NULL,'Y','Y',NULL,'0','N','Y','N','N','N','0.01','0.01','0.01','0.01','CDMA 11 DIGIT NUMERI','No Sign','B','POSTPAID MOCK','33','0.01','0.0000','0.0000','000000000000','000000000000','000000000000','400071500599',NULL,'CDMA 11 DIGIT NUMERIC',NULL,NULL,NULL,'N','800000048','IN','LB','0','IN','LB','0','IN','LB','0','Best Buy','2012-11-16','2013-04-08',NULL,NULL);
SET IDENTITY_INSERT [dbo].[BBSKUData] OFF
GO
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply