SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Error converting datatypes ('NULL' to int and VARCHAR to int)


Error converting datatypes ('NULL' to int and VARCHAR to int)

Author
Message
SQL_ME_RICH
SQL_ME_RICH
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2480 Visits: 1596
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
mister.magoo
mister.magoo
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10811 Visits: 7891
Instead of replacing 'NULL' with '', try replacing 'NULL' with NULL

MM


select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);




  • 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

  • SQL_ME_RICH
    SQL_ME_RICH
    SSCrazy
    SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

    Group: General Forum Members
    Points: 2480 Visits: 1596
    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.
    mister.magoo
    mister.magoo
    SSChampion
    SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

    Group: General Forum Members
    Points: 10811 Visits: 7891
    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
  • 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

  • Sean Pearce
    Sean Pearce
    SSCarpal Tunnel
    SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

    Group: General Forum Members
    Points: 4154 Visits: 3436
    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
    Bhaskar.Shetty
    Bhaskar.Shetty
    Ten Centuries
    Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

    Group: General Forum Members
    Points: 1140 Visits: 509
    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.
    SQL_ME_RICH
    SQL_ME_RICH
    SSCrazy
    SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

    Group: General Forum Members
    Points: 2480 Visits: 1596
    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


    SQL_ME_RICH
    SQL_ME_RICH
    SSCrazy
    SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

    Group: General Forum Members
    Points: 2480 Visits: 1596
    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


    Go


    Permissions

    You can't post new topics.
    You can't post topic replies.
    You can't post new polls.
    You can't post replies to polls.
    You can't edit your own topics.
    You can't delete your own topics.
    You can't edit other topics.
    You can't delete other topics.
    You can't edit your own posts.
    You can't edit other posts.
    You can't delete your own posts.
    You can't delete other posts.
    You can't post events.
    You can't edit your own events.
    You can't edit other events.
    You can't delete your own events.
    You can't delete other events.
    You can't send private messages.
    You can't send emails.
    You can read topics.
    You can't vote in polls.
    You can't upload attachments.
    You can download attachments.
    You can't post HTML code.
    You can't edit HTML code.
    You can't post IFCode.
    You can't post JavaScript.
    You can post emoticons.
    You can't post or upload images.

    Select a forum

































































































































































    SQLServerCentral


    Search