Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error converting datatypes ('NULL' to int and VARCHAR to int) Expand / Collapse
Author
Message
Posted Wednesday, May 22, 2013 5:22 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 10:08 PM
Points: 485, Visits: 1,363
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 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','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 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

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 ON
GO
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
Post #1455762
Posted Wednesday, May 22, 2013 6:07 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 3:47 PM
Points: 1,778, Visits: 5,730
Instead of replacing 'NULL' with '', try replacing 'NULL' with NULL

MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1455770
    Posted Wednesday, May 22, 2013 6:29 PM
    SSC-Addicted

    SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

    Group: General Forum Members
    Last Login: 2 days ago @ 10:08 PM
    Points: 485, Visits: 1,363
    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.
    Post #1455771
    Posted Wednesday, May 22, 2013 7:57 PM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: Yesterday @ 3:47 PM
    Points: 1,778, Visits: 5,730
    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


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1455784
    Posted Thursday, May 23, 2013 1:57 AM


    SSC Eights!

    SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

    Group: General Forum Members
    Last Login: Today @ 1:48 AM
    Points: 907, Visits: 2,869
    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)





    The SQL Guy @ blogspot

    @SeanPearceSQL

    About Me
    Post #1455864
    Posted Thursday, May 23, 2013 2:06 AM
    SSC-Addicted

    SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

    Group: General Forum Members
    Last Login: Friday, September 19, 2014 5:26 AM
    Points: 493, Visits: 426
    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.
    Post #1455867
    Posted Thursday, May 23, 2013 12:03 PM
    SSC-Addicted

    SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

    Group: General Forum Members
    Last Login: 2 days ago @ 10:08 PM
    Points: 485, Visits: 1,363
    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

    Post #1456148
    Posted Thursday, May 23, 2013 12:26 PM
    SSC-Addicted

    SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

    Group: General Forum Members
    Last Login: 2 days ago @ 10:08 PM
    Points: 485, Visits: 1,363
    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

    Post #1456160
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse