How to group & select based on several criteria? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How to group & select based on several criteria?

Author

Topic

SergioM
Posting Yak Master

170 Posts

Posted - 2015-03-16 : 15:30:50

I need to group all of the rows by the UPC which appears in the Product_TMP table. Then from each group, I need to pick the least expensive (Cost) item which also has inventory which is greater than 0. With that I need to display the Inventory, Cost, OurSKU, UPC, Title & Description.

It seems easy enough, but when I group, I am limited in how I can filter. This is what I have so far in terms of the query & the insert statements for the tables are beneath that. What would bring me closer to that goal? Thanks

Enclosed working Query to group one temporal table & one static table

SELECT 
	pt.[ID]
	,it.Cost
	,it.Inventory
	,pt.[OriginVendor]
	,pt.[ManufacturerSKU]
	,pt.[VendorSKU]
	,pt.[OurSKU]
	,pt.[UPC]
	,pt.[Title]
	,pt.[Description]
	,pt.[Weight]
	,pt.[MSRP]
	,pt.[MAP]
	,pt.[Manufacturer]
	,pt.[Category]
	,pt.[Subcategory]
	,pt.[DateCreated]
	,pt.[DateUpdated]
FROM [TestDB].[dbo].[Product_TMP] pt
INNER JOIN (
	SELECT 
		[ID]
		,[SKU]
		,[Cost]
		,[Inventory]
		,[DateAdded]
		,[DateUpdated]
		,[DateExpired]
	FROM [TestDB].[dbo].[Inventory_TMP]
	WHERE DateExpired IS NULL
		AND Inventory > 0
		AND Cost > 0
	) it
	ON pt.OurSKU = it.SKU
WHERE pt.upc IN ('033991038554', '043917796031', '043917799032', '043917985282', '047532896213', '047532900132', '639131007093', '639131023000', '639131813250', '856282004249', '886111610266', '888182023785')
order by pt.UPC

Enclosed Tables

USE [TestDB]
GO
/****** Object:  Table [dbo].[Inventory_TMP]    Script Date: 3/16/2015 3:00:09 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Inventory_TMP](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[SKU] [nvarchar](500) NULL,
	[Cost] [decimal](18, 2) NULL,
	[Inventory] [int] NULL,
	[DateAdded] [datetime] NULL,
	[DateUpdated] [datetime] NULL,
	[DateExpired] [datetime] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Product_TMP]    Script Date: 3/16/2015 3:00:09 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Product_TMP](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[OriginVendor] [nvarchar](10) NULL,
	[ManufacturerSKU] [nvarchar](500) NULL,
	[VendorSKU] [nvarchar](500) NULL,
	[OurSKU] [nvarchar](500) NULL,
	[UPC] [nvarchar](20) NULL,
	[Title] [nvarchar](500) NULL,
	[Description] [nvarchar](max) NULL,
	[Weight] [decimal](18, 2) NULL,
	[MSRP] [decimal](18, 2) NULL,
	[MAP] [decimal](18, 2) NULL,
	[Manufacturer] [nvarchar](50) NULL,
	[Category] [nvarchar](500) NULL,
	[Subcategory] [nvarchar](500) NULL,
	[DateCreated] [datetime] NULL,
	[DateUpdated] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET IDENTITY_INSERT [dbo].[Inventory_TMP] ON 

INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (44353, N'V001-IP21G', CAST(53.36 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:15.093' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (47106, N'V001-F4K70UT', CAST(875.57 AS Decimal(18, 2)), 0, CAST(N'2014-12-16 22:25:15.787' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (47565, N'V001-98541301', CAST(22.57 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:15.787' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (56780, N'V001-KXTG4222N', CAST(62.07 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:18.583' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (162456, N'V001-HAS160A', CAST(11.00 AS Decimal(18, 2)), 0, CAST(N'2015-01-20 23:47:15.000' AS DateTime), CAST(N'2015-01-21 00:09:00.990' AS DateTime), CAST(N'2015-01-21 00:09:00.990' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (67204, N'V001-79520500', CAST(25.96 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:22.417' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (67214, N'V001-796002101', CAST(49.65 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:22.417' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (67224, N'V001-799001501', CAST(25.96 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:22.417' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (67373, N'V001-303W250MPOSW', CAST(147.47 AS Decimal(18, 2)), 0, CAST(N'2014-12-16 22:25:22.417' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (67378, N'V001-303W255POSW', CAST(147.47 AS Decimal(18, 2)), 0, CAST(N'2014-12-16 22:25:22.417' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (67601, N'V001-ECMAW3', CAST(160.26 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:22.417' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (144605, N'V001-101W213EXENW', CAST(122.30 AS Decimal(18, 2)), 0, CAST(N'2015-01-20 23:47:15.000' AS DateTime), CAST(N'2015-01-20 23:47:23.457' AS DateTime), CAST(N'2015-01-20 23:47:23.457' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (168010, N'V001-PBX1008', CAST(100.85 AS Decimal(18, 2)), 0, CAST(N'2015-01-20 23:47:15.000' AS DateTime), CAST(N'2015-01-21 00:15:51.147' AS DateTime), CAST(N'2015-01-21 00:15:51.147' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (44983, N'V001-IPL8B', CAST(62.26 AS Decimal(18, 2)), 0, CAST(N'2014-12-16 22:25:15.450' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (46199, N'V001-ONP1', CAST(50.25 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:15.463' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (48507, N'V001-069055862407', CAST(95.93 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:16.097' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (58732, N'V001-ANT5', CAST(5.64 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:19.337' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (52033, N'V001-101B213EXENBBHB', CAST(113.56 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:17.267' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (52042, N'V001-101B213EXENBOHB', CAST(113.56 AS Decimal(18, 2)), 0, CAST(N'2014-12-16 22:25:17.267' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (52132, N'V001-101W213EXENWOHB', CAST(113.56 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:17.267' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (54502, N'V001-KL1516AN', CAST(1625.01 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:18.123' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (67926, N'V001-EF0610AA008', CAST(38.37 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:23.330' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (59791, N'V001-D8E66UT', CAST(888.01 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:20.117' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (59800, N'V001-D8E66UTEXCESS', CAST(761.81 AS Decimal(18, 2)), 0, CAST(N'2014-12-16 22:25:20.117' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (71097, N'V001-IHM59WC', CAST(17.90 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:24.700' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (71107, N'V001-IHM60GT', CAST(18.46 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:24.700' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (71112, N'V001-IHM60LT', CAST(18.46 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:24.700' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (71117, N'V001-IHM60PN', CAST(18.46 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:24.700' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (69237, N'V001-I2R', CAST(16.54 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:24.207' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (70082, N'V001-IBT16UC', CAST(45.31 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:24.210' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (70162, N'V001-IBT60BC', CAST(36.62 AS Decimal(18, 2)), 0, CAST(N'2014-12-16 22:25:24.210' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (70172, N'V001-IBT60UC', CAST(36.27 AS Decimal(18, 2)), 0, CAST(N'2014-12-16 22:25:24.210' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (266913, N'V002-JVC-HAEBX5PN', CAST(10.84 AS Decimal(18, 2)), 16, CAST(N'2015-01-29 12:21:57.000' AS DateTime), CAST(N'2015-01-29 12:21:57.230' AS DateTime), CAST(N'2015-02-09 21:46:08.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (62874, N'V001-GTP5210ZWYXAR', CAST(356.28 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:20.570' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (61165, N'V001-LV290AAABA', CAST(18.35 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:20.497' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (64388, N'V001-HAEBX5AN', CAST(12.98 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:20.623' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (64522, N'V001-HAFR37A', CAST(11.18 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:20.623' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (64547, N'V001-HAFR37R', CAST(11.18 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:20.623' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (64627, N'V001-HAFX32D', CAST(8.47 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:20.623' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (64632, N'V001-HAFX32G', CAST(8.47 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:20.623' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (64642, N'V001-HAFX32R', CAST(8.47 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:20.623' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (64672, N'V001-HAFX40S', CAST(19.18 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:20.623' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (64697, N'V001-HAFX5P', CAST(5.64 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:20.623' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (64737, N'V001-HAFX8R', CAST(5.64 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:20.627' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (64967, N'V001-HAS200B', CAST(19.18 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:20.627' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (82792, N'V002-SUP-SC1325ARD', CAST(8.25 AS Decimal(18, 2)), 27, CAST(N'2014-12-18 11:25:51.000' AS DateTime), CAST(N'2014-12-18 11:25:52.547' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (74701, N'V001-SC1325RED', CAST(14.11 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:26.987' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (74771, N'V001-SC2300SS', CAST(83.51 AS Decimal(18, 2)), 100, CAST(N'2014-12-16 22:25:26.990' AS DateTime), NULL, NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (220485, N'V001-D550MAVDB01DMO', CAST(337.41 AS Decimal(18, 2)), 0, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:10:18.157' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (220896, N'V001-DMCFZ200K', CAST(536.89 AS Decimal(18, 2)), 4, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:10:51.240' AS DateTime), CAST(N'2015-01-29 12:26:20.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (220900, N'V001-DMCLX7W', CAST(372.09 AS Decimal(18, 2)), 0, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:10:51.240' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (220902, N'V001-DMCTS25K', CAST(168.05 AS Decimal(18, 2)), 0, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:10:51.240' AS DateTime), CAST(N'2015-02-01 11:51:46.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (113171, N'V002-SUP-SC1122WH', CAST(20.08 AS Decimal(18, 2)), 4, CAST(N'2014-12-21 19:43:17.000' AS DateTime), CAST(N'2014-12-21 19:43:18.487' AS DateTime), CAST(N'2015-01-20 23:46:22.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (221765, N'V001-EF0420AA002', CAST(113.85 AS Decimal(18, 2)), 6, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:11:57.353' AS DateTime), CAST(N'2015-01-30 22:20:08.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (222508, N'V001-F2B31AAABA', CAST(14.33 AS Decimal(18, 2)), 233, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:12:59.787' AS DateTime), CAST(N'2015-01-23 05:47:35.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (224477, N'V001-HAFX101B', CAST(14.30 AS Decimal(18, 2)), 5, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:15:08.877' AS DateTime), CAST(N'2015-01-29 12:41:03.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (224478, N'V001-HAFX101G', CAST(14.30 AS Decimal(18, 2)), 13, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:15:08.877' AS DateTime), CAST(N'2015-01-30 22:20:08.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (224523, N'V001-HAS160A', CAST(11.00 AS Decimal(18, 2)), 0, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:15:08.877' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (224805, N'V001-HFH113NUM', CAST(14.30 AS Decimal(18, 2)), 0, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:15:08.877' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (224963, N'V001-HPF2B31AA', CAST(14.40 AS Decimal(18, 2)), 47, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:15:44.857' AS DateTime), CAST(N'2015-01-27 21:58:52.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (225335, N'V001-IBT60UX', CAST(29.70 AS Decimal(18, 2)), 95, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:16:21.057' AS DateTime), CAST(N'2015-01-30 22:20:08.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (148167, N'V001-4352G9U', CAST(2158.97 AS Decimal(18, 2)), 0, CAST(N'2015-01-20 23:47:15.000' AS DateTime), CAST(N'2015-01-20 23:51:48.417' AS DateTime), CAST(N'2015-01-20 23:51:48.417' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (150233, N'V002-SUP-SC1122WH', CAST(20.08 AS Decimal(18, 2)), 0, CAST(N'2015-01-20 23:46:22.000' AS DateTime), CAST(N'2015-01-20 23:46:23.543' AS DateTime), CAST(N'2015-03-15 11:27:38.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (150260, N'V002-SUP-SC2300', CAST(63.25 AS Decimal(18, 2)), 16, CAST(N'2015-01-20 23:46:22.000' AS DateTime), CAST(N'2015-03-15 11:31:08.567' AS DateTime), CAST(N'2015-02-13 00:19:09.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (150422, N'V002-WAHL-79520500', CAST(25.19 AS Decimal(18, 2)), 10, CAST(N'2015-01-20 23:46:22.000' AS DateTime), CAST(N'2015-03-15 11:31:17.543' AS DateTime), CAST(N'2015-02-09 21:46:08.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (226914, N'V001-KL1508AM', CAST(1163.02 AS Decimal(18, 2)), 0, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:18:02.493' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (230074, N'V001-PBX1008', CAST(100.85 AS Decimal(18, 2)), 0, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:22:21.257' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (158418, N'V001-D550MAVDB01DMO', CAST(337.41 AS Decimal(18, 2)), 0, CAST(N'2015-01-20 23:47:15.000' AS DateTime), CAST(N'2015-01-21 00:03:55.850' AS DateTime), CAST(N'2015-01-21 00:03:55.850' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (158809, N'V001-DMCLX7W', CAST(372.09 AS Decimal(18, 2)), 0, CAST(N'2015-01-20 23:47:15.000' AS DateTime), CAST(N'2015-01-21 00:04:34.077' AS DateTime), CAST(N'2015-01-21 00:04:34.077' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (236036, N'V001-TVPRAMP1R', CAST(20.90 AS Decimal(18, 2)), 0, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:29:08.977' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (237521, N'V001-WES9087PC', CAST(17.05 AS Decimal(18, 2)), 0, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:31:33.930' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (164853, N'V001-KL1508AM', CAST(1163.02 AS Decimal(18, 2)), 0, CAST(N'2015-01-20 23:47:15.000' AS DateTime), CAST(N'2015-01-21 00:11:57.433' AS DateTime), CAST(N'2015-01-21 00:11:57.433' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (249445, N'V001-F2B31AAABA', CAST(14.33 AS Decimal(18, 2)), 234, CAST(N'2015-01-23 05:47:35.000' AS DateTime), CAST(N'2015-01-23 06:12:55.690' AS DateTime), CAST(N'2015-01-27 21:58:52.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (183939, N'V001-81398124', CAST(392.70 AS Decimal(18, 2)), 27, CAST(N'2015-01-21 18:40:09.000' AS DateTime), CAST(N'2015-01-21 18:49:34.507' AS DateTime), CAST(N'2015-01-21 18:49:34.507' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (193799, N'V001-HAS160A', CAST(11.00 AS Decimal(18, 2)), 0, CAST(N'2015-01-21 18:40:09.000' AS DateTime), CAST(N'2015-01-21 19:01:08.283' AS DateTime), CAST(N'2015-01-21 19:01:08.283' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (194239, N'V001-HPF2B31AA', CAST(14.40 AS Decimal(18, 2)), 47, CAST(N'2015-01-21 18:40:09.000' AS DateTime), CAST(N'2015-01-21 19:01:40.577' AS DateTime), CAST(N'2015-01-21 19:01:40.577' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (194611, N'V001-IBT60UX', CAST(29.70 AS Decimal(18, 2)), 95, CAST(N'2015-01-21 18:40:09.000' AS DateTime), CAST(N'2015-01-21 19:02:17.103' AS DateTime), CAST(N'2015-01-21 19:02:17.103' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (173988, N'V001-TVPRAMP1R', CAST(20.90 AS Decimal(18, 2)), 0, CAST(N'2015-01-20 23:47:15.000' AS DateTime), CAST(N'2015-01-21 00:23:41.027' AS DateTime), CAST(N'2015-01-21 00:23:41.027' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (177573, N'V001-101B213EXENB', CAST(122.30 AS Decimal(18, 2)), 7, CAST(N'2015-01-21 18:40:09.000' AS DateTime), CAST(N'2015-01-21 18:40:17.417' AS DateTime), CAST(N'2015-01-21 18:40:17.417' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (177578, N'V001-101W213EXENW', CAST(122.30 AS Decimal(18, 2)), 0, CAST(N'2015-01-21 18:40:09.000' AS DateTime), CAST(N'2015-01-21 18:40:17.417' AS DateTime), CAST(N'2015-01-21 18:40:17.417' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (181342, N'V001-4352G9U', CAST(2158.97 AS Decimal(18, 2)), 0, CAST(N'2015-01-21 18:40:09.000' AS DateTime), CAST(N'2015-01-21 18:45:32.473' AS DateTime), CAST(N'2015-01-21 18:45:32.473' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (254096, N'V001-10069055863975', CAST(82.28 AS Decimal(18, 2)), 44, CAST(N'2015-01-27 21:58:52.000' AS DateTime), CAST(N'2015-01-27 21:58:54.987' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (189761, N'V001-D550MAVDB01DMO', CAST(337.41 AS Decimal(18, 2)), 0, CAST(N'2015-01-21 18:40:09.000' AS DateTime), CAST(N'2015-01-21 18:56:06.600' AS DateTime), CAST(N'2015-01-21 18:56:06.600' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (190176, N'V001-DMCLX7W', CAST(372.09 AS Decimal(18, 2)), 0, CAST(N'2015-01-21 18:40:09.000' AS DateTime), CAST(N'2015-01-21 18:56:37.647' AS DateTime), CAST(N'2015-01-21 18:56:37.647' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (190178, N'V001-DMCTS25K', CAST(168.05 AS Decimal(18, 2)), 0, CAST(N'2015-01-21 18:40:09.000' AS DateTime), CAST(N'2015-01-21 18:56:37.647' AS DateTime), CAST(N'2015-01-21 18:56:37.647' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (199350, N'V001-PBX1008', CAST(100.85 AS Decimal(18, 2)), 0, CAST(N'2015-01-21 18:40:09.000' AS DateTime), CAST(N'2015-01-21 19:07:49.960' AS DateTime), CAST(N'2015-01-21 19:07:49.960' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (208896, N'V001-101B213EXENB', CAST(122.30 AS Decimal(18, 2)), 7, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 00:56:28.383' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (208901, N'V001-101W213EXENW', CAST(122.30 AS Decimal(18, 2)), 0, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 00:56:28.383' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (196190, N'V001-KL1508AM', CAST(1163.02 AS Decimal(18, 2)), 0, CAST(N'2015-01-21 18:40:09.000' AS DateTime), CAST(N'2015-01-21 19:03:57.890' AS DateTime), CAST(N'2015-01-21 19:03:57.890' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (205312, N'V001-TVPRAMP1R', CAST(20.90 AS Decimal(18, 2)), 0, CAST(N'2015-01-21 18:40:09.000' AS DateTime), CAST(N'2015-01-21 19:14:29.363' AS DateTime), CAST(N'2015-01-21 19:14:29.363' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (212066, N'V001-4352G9U', CAST(2158.97 AS Decimal(18, 2)), 0, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:00:11.093' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (214663, N'V001-81398124', CAST(392.70 AS Decimal(18, 2)), 27, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:03:49.673' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (220292, N'V001-CV102', CAST(30.80 AS Decimal(18, 2)), 0, CAST(N'2015-01-22 00:56:26.000' AS DateTime), CAST(N'2015-01-22 01:10:18.157' AS DateTime), CAST(N'2015-01-29 12:26:20.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (243024, N'V001-IBT20GC', CAST(60.23 AS Decimal(18, 2)), 47, CAST(N'2015-01-22 20:20:31.000' AS DateTime), CAST(N'2015-01-22 20:49:48.293' AS DateTime), CAST(N'2015-01-27 21:58:52.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (271275, N'V001-CV102', CAST(30.80 AS Decimal(18, 2)), 16, CAST(N'2015-01-29 12:26:20.000' AS DateTime), CAST(N'2015-01-29 12:33:23.037' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (271485, N'V001-DMCFZ200K', CAST(536.89 AS Decimal(18, 2)), 3, CAST(N'2015-01-29 12:26:20.000' AS DateTime), CAST(N'2015-01-29 12:33:42.777' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (261614, N'V001-KXTS4300B', CAST(150.70 AS Decimal(18, 2)), 49, CAST(N'2015-01-27 21:58:52.000' AS DateTime), CAST(N'2015-01-27 22:39:46.177' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (272688, N'V001-HAFX101B', CAST(14.30 AS Decimal(18, 2)), 4, CAST(N'2015-01-29 12:41:03.000' AS DateTime), CAST(N'2015-01-29 12:50:46.330' AS DateTime), CAST(N'2015-02-01 11:51:46.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (282389, N'V001-I2C12', CAST(16.96 AS Decimal(18, 2)), 7, CAST(N'2015-01-30 22:20:08.000' AS DateTime), CAST(N'2015-01-30 22:31:10.363' AS DateTime), CAST(N'2015-02-01 11:51:46.000' AS DateTime))
GO
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (282404, N'V001-IBT60BX', CAST(29.70 AS Decimal(18, 2)), 30, CAST(N'2015-01-30 22:20:08.000' AS DateTime), CAST(N'2015-01-30 22:31:10.363' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (282405, N'V001-IBT60UX', CAST(29.70 AS Decimal(18, 2)), 94, CAST(N'2015-01-30 22:20:08.000' AS DateTime), CAST(N'2015-01-30 22:31:10.363' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (259817, N'V001-F2B31AAABA', CAST(14.33 AS Decimal(18, 2)), 233, CAST(N'2015-01-27 21:58:52.000' AS DateTime), CAST(N'2015-01-27 22:30:09.570' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (290922, N'V001-KXTS4100B', CAST(88.00 AS Decimal(18, 2)), 70, CAST(N'2015-02-01 11:51:46.000' AS DateTime), CAST(N'2015-02-01 12:08:33.643' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (290924, N'V001-KXTS500B', CAST(12.10 AS Decimal(18, 2)), 124, CAST(N'2015-02-01 11:51:46.000' AS DateTime), CAST(N'2015-02-01 12:08:33.643' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (291233, N'V001-MF0420AA002', CAST(27.08 AS Decimal(18, 2)), 225, CAST(N'2015-02-01 11:51:46.000' AS DateTime), CAST(N'2015-02-01 12:09:27.120' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (278932, N'V001-29115', CAST(46.75 AS Decimal(18, 2)), 46, CAST(N'2015-01-30 22:20:08.000' AS DateTime), CAST(N'2015-01-30 22:20:33.143' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (289132, N'V001-DMCTS25K', CAST(168.05 AS Decimal(18, 2)), 2, CAST(N'2015-02-01 11:51:46.000' AS DateTime), CAST(N'2015-02-01 12:02:48.597' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (289448, N'V001-ESLA63S', CAST(146.30 AS Decimal(18, 2)), 29, CAST(N'2015-02-01 11:51:46.000' AS DateTime), CAST(N'2015-02-01 12:03:41.420' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (263809, N'V001-SHB301GR', CAST(20.35 AS Decimal(18, 2)), 79, CAST(N'2015-01-27 21:58:52.000' AS DateTime), CAST(N'2015-01-27 22:51:31.417' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (273097, N'V001-IBT16PC', CAST(28.90 AS Decimal(18, 2)), 64, CAST(N'2015-01-29 12:41:03.000' AS DateTime), CAST(N'2015-01-29 12:51:22.150' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (273139, N'V001-IM60GT', CAST(17.78 AS Decimal(18, 2)), 0, CAST(N'2015-01-29 12:41:03.000' AS DateTime), CAST(N'2015-01-29 12:51:22.150' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (290095, N'V001-HAFX101A', CAST(14.30 AS Decimal(18, 2)), 52, CAST(N'2015-02-01 11:51:46.000' AS DateTime), CAST(N'2015-02-01 12:05:54.443' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (290096, N'V001-HAFX101B', CAST(14.30 AS Decimal(18, 2)), 0, CAST(N'2015-02-01 11:51:46.000' AS DateTime), CAST(N'2015-02-01 12:05:54.443' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (290330, N'V001-HPLV290AA', CAST(17.96 AS Decimal(18, 2)), 109, CAST(N'2015-02-01 11:51:46.000' AS DateTime), CAST(N'2015-02-01 12:06:20.840' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (290433, N'V001-I2C12', CAST(16.96 AS Decimal(18, 2)), 5, CAST(N'2015-02-01 11:51:46.000' AS DateTime), CAST(N'2015-02-01 12:06:20.840' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (290436, N'V001-I2RA', CAST(16.04 AS Decimal(18, 2)), 391, CAST(N'2015-02-01 11:51:46.000' AS DateTime), CAST(N'2015-02-01 12:06:20.840' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (290509, N'V001-IM59WC', CAST(17.78 AS Decimal(18, 2)), 35, CAST(N'2015-02-01 11:51:46.000' AS DateTime), CAST(N'2015-02-01 12:06:47.467' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (260787, N'V001-HPF2B31AA', CAST(14.40 AS Decimal(18, 2)), 46, CAST(N'2015-01-27 21:58:52.000' AS DateTime), CAST(N'2015-01-27 22:35:00.267' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (260928, N'V001-I2RA', CAST(16.04 AS Decimal(18, 2)), 394, CAST(N'2015-01-27 21:58:52.000' AS DateTime), CAST(N'2015-01-27 22:36:04.610' AS DateTime), CAST(N'2015-02-01 11:51:46.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (260949, N'V001-IBT20GC', CAST(60.23 AS Decimal(18, 2)), 0, CAST(N'2015-01-27 21:58:52.000' AS DateTime), CAST(N'2015-01-27 22:36:04.613' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (292431, N'V001-SC709', CAST(43.45 AS Decimal(18, 2)), 2, CAST(N'2015-02-01 11:51:46.000' AS DateTime), CAST(N'2015-02-01 12:13:53.527' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (267595, N'V002-WAHL-98541301', CAST(24.20 AS Decimal(18, 2)), 10, CAST(N'2015-01-29 12:21:57.000' AS DateTime), CAST(N'2015-03-15 11:31:17.880' AS DateTime), CAST(N'2015-02-09 21:46:08.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (289013, N'V001-D550MAVDB01', CAST(337.41 AS Decimal(18, 2)), 2520, CAST(N'2015-02-01 11:51:46.000' AS DateTime), CAST(N'2015-02-01 12:02:21.890' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (265666, N'V001-WES9014PC', CAST(35.20 AS Decimal(18, 2)), 32, CAST(N'2015-01-27 21:58:52.000' AS DateTime), CAST(N'2015-01-27 22:59:47.797' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (281460, N'V001-EF0420AA002', CAST(113.85 AS Decimal(18, 2)), 5, CAST(N'2015-01-30 22:20:08.000' AS DateTime), CAST(N'2015-01-30 22:28:40.630' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (282118, N'V001-HAFX101G', CAST(14.30 AS Decimal(18, 2)), 12, CAST(N'2015-01-30 22:20:08.000' AS DateTime), CAST(N'2015-01-30 22:30:32.937' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (282137, N'V001-HASR500B', CAST(31.90 AS Decimal(18, 2)), 0, CAST(N'2015-01-30 22:20:08.000' AS DateTime), CAST(N'2015-01-30 22:30:32.937' AS DateTime), CAST(N'2015-02-09 21:46:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (870813, N'V001-10069055863975', CAST(82.28 AS Decimal(18, 2)), 42, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 21:46:20.757' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (880785, N'V001-I2C12', CAST(16.96 AS Decimal(18, 2)), 0, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:45:42.617' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (880789, N'V001-I2RA', CAST(16.04 AS Decimal(18, 2)), 388, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:45:42.617' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (880825, N'V001-IBT16PC', CAST(28.90 AS Decimal(18, 2)), 46, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:48:53.000' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (880828, N'V001-IBT60BX', CAST(29.70 AS Decimal(18, 2)), 90, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:48:53.000' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (880878, N'V001-IM59WC', CAST(17.78 AS Decimal(18, 2)), 50, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:48:53.000' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (880879, N'V001-IM60GT', CAST(17.78 AS Decimal(18, 2)), 25, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:48:53.000' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (875134, N'V001-81398124', CAST(392.70 AS Decimal(18, 2)), 26, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 22:36:54.603' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (887135, N'V001-WES9014PC', CAST(35.20 AS Decimal(18, 2)), 29, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-10 01:05:59.983' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (887142, N'V001-WES9087PC', CAST(17.05 AS Decimal(18, 2)), 16, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-10 01:05:59.983' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (880280, N'V001-HAFX101A', CAST(14.30 AS Decimal(18, 2)), 49, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:42:33.103' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (880281, N'V001-HAFX101G', CAST(14.30 AS Decimal(18, 2)), 9, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:42:33.103' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (880318, N'V001-HASR500B', CAST(31.90 AS Decimal(18, 2)), 5, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:42:33.103' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (880518, N'V001-HFH113NUM', CAST(14.30 AS Decimal(18, 2)), 23, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:42:33.103' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (880648, N'V001-HPLV290AA', CAST(17.96 AS Decimal(18, 2)), 98, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:45:42.617' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (871713, N'V001-29115', CAST(46.75 AS Decimal(18, 2)), 38, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 21:52:44.430' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (872337, N'V002-JVC-HAEBX5PN', CAST(10.84 AS Decimal(18, 2)), 15, CAST(N'2015-02-09 21:46:08.000' AS DateTime), CAST(N'2015-02-09 21:46:13.483' AS DateTime), CAST(N'2015-02-19 11:17:23.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (873203, N'V002-SUP-SC507MP3RD', CAST(27.39 AS Decimal(18, 2)), 117, CAST(N'2015-02-09 21:46:08.000' AS DateTime), CAST(N'2015-02-09 21:46:13.600' AS DateTime), CAST(N'2015-02-19 11:17:23.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (873290, N'V002-WAHL-79520500', CAST(25.19 AS Decimal(18, 2)), 26, CAST(N'2015-02-09 21:46:08.000' AS DateTime), CAST(N'2015-03-15 11:31:17.543' AS DateTime), CAST(N'2015-02-19 11:17:23.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (873295, N'V002-WAHL-796002101', CAST(44.99 AS Decimal(18, 2)), 96, CAST(N'2015-02-09 21:46:08.000' AS DateTime), CAST(N'2015-02-09 21:46:13.600' AS DateTime), CAST(N'2015-02-13 00:19:09.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (873296, N'V002-WAHL-799001501', CAST(25.19 AS Decimal(18, 2)), 41, CAST(N'2015-02-09 21:46:08.000' AS DateTime), CAST(N'2015-02-09 21:46:13.600' AS DateTime), CAST(N'2015-02-19 11:17:23.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (873313, N'V002-WAHL-98541301', CAST(24.20 AS Decimal(18, 2)), 28, CAST(N'2015-02-09 21:46:08.000' AS DateTime), CAST(N'2015-03-15 11:31:17.880' AS DateTime), CAST(N'2015-02-19 11:17:23.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (878476, N'V001-DMCFZ200K', CAST(536.89 AS Decimal(18, 2)), 0, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:20:39.273' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (878922, N'V001-EF0420AA002', CAST(113.85 AS Decimal(18, 2)), 0, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:23:49.453' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (879114, N'V001-ESLA63S', CAST(146.30 AS Decimal(18, 2)), 44, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:26:57.313' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (878151, N'V001-CV102', CAST(30.80 AS Decimal(18, 2)), 2, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:14:19.080' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (878251, N'V001-D550MAVDB01', CAST(337.41 AS Decimal(18, 2)), 1817, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-09 23:17:28.950' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (884503, N'V001-SC709', CAST(43.45 AS Decimal(18, 2)), 55, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-10 00:37:39.080' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (882379, N'V001-MF0420AA002', CAST(27.08 AS Decimal(18, 2)), 664, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-10 00:07:45.107' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (881799, N'V001-KXTS4100B', CAST(88.00 AS Decimal(18, 2)), 63, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-10 00:01:30.547' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (881801, N'V001-KXTS4300B', CAST(150.70 AS Decimal(18, 2)), 45, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-10 00:01:30.547' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (881802, N'V001-KXTS500B', CAST(12.10 AS Decimal(18, 2)), 46, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-10 00:01:30.547' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (884740, N'V001-SHB301GR', CAST(20.35 AS Decimal(18, 2)), 78, CAST(N'2015-02-09 21:46:14.000' AS DateTime), CAST(N'2015-02-10 00:40:28.437' AS DateTime), CAST(N'2015-02-13 00:19:14.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (895816, N'V001-D550MAVDB01', CAST(337.41 AS Decimal(18, 2)), 1752, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:10:05.020' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (898045, N'V001-IM59WC', CAST(17.78 AS Decimal(18, 2)), 104, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:22:00.007' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (898046, N'V001-IM60GT', CAST(17.78 AS Decimal(18, 2)), 70, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:22:00.007' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (889747, N'V001-10069055863975', CAST(82.28 AS Decimal(18, 2)), 37, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 00:19:43.177' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (889761, N'V001-101B213EXENB', CAST(122.30 AS Decimal(18, 2)), 6, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 00:19:43.177' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (891534, N'V001-29115', CAST(46.75 AS Decimal(18, 2)), 29, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 00:26:25.083' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (890891, N'V002-SUP-SC1366BTBL', CAST(22.00 AS Decimal(18, 2)), 25, CAST(N'2015-02-13 00:19:09.000' AS DateTime), CAST(N'2015-02-13 00:19:20.277' AS DateTime), CAST(N'2015-02-19 11:17:23.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (890901, N'V002-SUP-SC2300', CAST(63.25 AS Decimal(18, 2)), 14, CAST(N'2015-02-13 00:19:09.000' AS DateTime), CAST(N'2015-03-15 11:31:08.567' AS DateTime), CAST(N'2015-02-19 11:17:23.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (890917, N'V002-SUP-SC709CD', CAST(41.47 AS Decimal(18, 2)), 160, CAST(N'2015-02-13 00:19:09.000' AS DateTime), CAST(N'2015-02-13 00:19:20.277' AS DateTime), CAST(N'2015-02-19 11:17:23.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (890969, N'V002-WAHL-796002101', CAST(44.99 AS Decimal(18, 2)), 84, CAST(N'2015-02-13 00:19:09.000' AS DateTime), CAST(N'2015-02-13 00:19:20.277' AS DateTime), CAST(N'2015-03-15 11:27:38.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (897770, N'V001-HFH113NUM', CAST(14.30 AS Decimal(18, 2)), 50, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:20:49.383' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (897875, N'V001-HPLV290AA', CAST(17.96 AS Decimal(18, 2)), 129, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:20:49.383' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (897576, N'V001-HAFX101A', CAST(14.30 AS Decimal(18, 2)), 48, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:19:35.517' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (898856, N'V001-KXTS4100B', CAST(88.00 AS Decimal(18, 2)), 60, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:26:39.437' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (898858, N'V001-KXTS4300B', CAST(150.70 AS Decimal(18, 2)), 44, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:26:39.437' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (898859, N'V001-KXTS500B', CAST(12.10 AS Decimal(18, 2)), 117, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:26:39.437' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (898000, N'V001-IBT16PC', CAST(28.90 AS Decimal(18, 2)), 42, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:22:00.007' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (898001, N'V001-IBT20GC', CAST(60.23 AS Decimal(18, 2)), 12, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:22:00.007' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (898003, N'V001-IBT60BX', CAST(29.70 AS Decimal(18, 2)), 84, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:22:00.007' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (899416, N'V001-MF0420AA002', CAST(27.08 AS Decimal(18, 2)), 616, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:30:11.440' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (903536, N'V001-WES9014PC', CAST(35.20 AS Decimal(18, 2)), 22, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:52:02.793' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (903544, N'V001-WES9087PC', CAST(17.05 AS Decimal(18, 2)), 0, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:52:02.793' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (896478, N'V001-ESLA63S', CAST(146.30 AS Decimal(18, 2)), 0, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:13:38.740' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (897603, N'V001-HASR500B', CAST(31.90 AS Decimal(18, 2)), 10, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:19:35.517' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (901309, N'V001-SC709', CAST(43.45 AS Decimal(18, 2)), 100, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:40:33.687' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (901606, N'V001-SHB301GR', CAST(20.35 AS Decimal(18, 2)), 77, CAST(N'2015-02-13 00:19:14.000' AS DateTime), CAST(N'2015-02-13 01:41:41.030' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (905261, N'V002-JVC-HAEBX5PN', CAST(10.84 AS Decimal(18, 2)), 13, CAST(N'2015-02-19 11:17:23.000' AS DateTime), CAST(N'2015-02-19 11:17:38.500' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (906051, N'V002-SUP-SC1366BTBL', CAST(22.00 AS Decimal(18, 2)), 23, CAST(N'2015-02-19 11:17:23.000' AS DateTime), CAST(N'2015-02-19 11:17:38.593' AS DateTime), CAST(N'2015-03-15 11:27:38.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (906061, N'V002-SUP-SC2300', CAST(63.25 AS Decimal(18, 2)), 13, CAST(N'2015-02-19 11:17:23.000' AS DateTime), CAST(N'2015-03-15 11:31:08.567' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (906082, N'V002-SUP-SC507MP3RD', CAST(27.39 AS Decimal(18, 2)), 113, CAST(N'2015-02-19 11:17:23.000' AS DateTime), CAST(N'2015-02-19 11:17:38.593' AS DateTime), CAST(N'2015-03-15 11:27:38.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (906091, N'V002-SUP-SC709CD', CAST(41.47 AS Decimal(18, 2)), 124, CAST(N'2015-02-19 11:17:23.000' AS DateTime), CAST(N'2015-02-19 11:17:38.593' AS DateTime), CAST(N'2015-03-15 11:27:38.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (906169, N'V002-WAHL-79520500', CAST(25.19 AS Decimal(18, 2)), 0, CAST(N'2015-02-19 11:17:23.000' AS DateTime), CAST(N'2015-03-15 11:31:17.543' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (906173, N'V002-WAHL-799001501', CAST(25.19 AS Decimal(18, 2)), 39, CAST(N'2015-02-19 11:17:23.000' AS DateTime), CAST(N'2015-02-19 11:17:38.610' AS DateTime), CAST(N'2015-03-15 11:27:38.000' AS DateTime))
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (906187, N'V002-WAHL-98541301', CAST(24.20 AS Decimal(18, 2)), 25, CAST(N'2015-02-19 11:17:23.000' AS DateTime), CAST(N'2015-03-15 11:31:17.880' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (908160, N'V002-SUP-SC1122WH', CAST(20.08 AS Decimal(18, 2)), 40, CAST(N'2015-03-15 11:27:38.000' AS DateTime), CAST(N'2015-03-15 11:27:52.080' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (908172, N'V002-SUP-SC1366BTBL', CAST(20.68 AS Decimal(18, 2)), 15, CAST(N'2015-03-15 11:27:38.000' AS DateTime), CAST(N'2015-03-15 11:27:52.080' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (908212, N'V002-SUP-SC507MP3RD', CAST(27.39 AS Decimal(18, 2)), 109, CAST(N'2015-03-15 11:27:38.000' AS DateTime), CAST(N'2015-03-15 11:27:52.080' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (908222, N'V002-SUP-SC709CD', CAST(41.47 AS Decimal(18, 2)), 149, CAST(N'2015-03-15 11:27:38.000' AS DateTime), CAST(N'2015-03-15 11:27:52.080' AS DateTime), NULL)
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (908357, N'V002-WAHL-796002101', CAST(44.99 AS Decimal(18, 2)), 66, CAST(N'2015-03-15 11:27:38.000' AS DateTime), CAST(N'2015-03-15 11:27:52.080' AS DateTime), NULL)
GO
INSERT [dbo].[Inventory_TMP] ([ID], [SKU], [Cost], [Inventory], [DateAdded], [DateUpdated], [DateExpired]) VALUES (908358, N'V002-WAHL-799001501', CAST(25.19 AS Decimal(18, 2)), 38, CAST(N'2015-03-15 11:27:38.000' AS DateTime), CAST(N'2015-03-15 11:27:52.080' AS DateTime), NULL)
SET IDENTITY_INSERT [dbo].[Inventory_TMP] OFF
SET IDENTITY_INSERT [dbo].[Product_TMP] ON 

INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (94677, N'Vendor1', N'HAEBX5PN', N'JVC-HAEBX5PN', N'V002-JVC-HAEBX5PN', N'046838046384', N'HEADPHONES,SPORT-CLIP,PNK', NULL, CAST(0.11 AS Decimal(18, 2)), CAST(19.95 AS Decimal(18, 2)), NULL, N'JVC', NULL, NULL, NULL, CAST(N'2015-02-19 11:21:46.307' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (75504, N'Vendor2', N'51MF0420AA002', N'MF0420AA002', N'V001-MF0420AA002', N'054651180444', N'A250 2.1 Speaker', NULL, CAST(6.00 AS Decimal(18, 2)), CAST(24.62 AS Decimal(18, 2)), NULL, N'Creative Labs', N'Speakers', N'2.1 & Up Systems', CAST(N'2014-12-16 22:25:25.597' AS DateTime), CAST(N'2015-02-13 01:35:03.973' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67093, N'Vendor2', N'HAEBX5AN', N'HAEBX5AN', N'V001-HAEBX5AN', N'046838046353', N'InnerEar Clip Headphone Blue', NULL, CAST(0.10 AS Decimal(18, 2)), CAST(19.95 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.623' AS DateTime), CAST(N'2014-12-16 22:25:20.623' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67118, N'Vendor2', N'HAEBX5PN', N'HAEBX5PN', N'V001-HAEBX5PN', N'046838046384', N'InnerEar clip Headphone Pink', NULL, CAST(0.10 AS Decimal(18, 2)), CAST(11.50 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.623' AS DateTime), CAST(N'2014-12-21 20:11:19.830' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67227, N'Vendor2', N'HAFR37A', N'HAFR37A', N'V001-HAFR37A', N'046838068836', N'Marshmallow Inner Ear With Mic', NULL, CAST(0.10 AS Decimal(18, 2)), CAST(19.95 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.623' AS DateTime), CAST(N'2014-12-16 22:25:20.623' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67252, N'Vendor2', N'HAFR37R', N'HAFR37R', N'V001-HAFR37R', N'046838068881', N'Marshmallow With Mic Red', NULL, CAST(0.10 AS Decimal(18, 2)), CAST(19.95 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.623' AS DateTime), CAST(N'2014-12-16 22:25:20.623' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67297, N'Vendor2', N'HAFX101A', N'HAFX101A', N'V001-HAFX101A', N'046838049774', N'Inner Ear Headphones Blue', NULL, CAST(0.10 AS Decimal(18, 2)), CAST(13.00 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.623' AS DateTime), CAST(N'2015-02-13 01:24:58.033' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67302, N'Vendor2', N'HAFX101B', N'HAFX101B', N'V001-HAFX101B', N'046838049781', N'Inner Ear Headphones Black', NULL, CAST(0.10 AS Decimal(18, 2)), CAST(13.00 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.623' AS DateTime), CAST(N'2015-02-13 01:24:58.127' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67307, N'Vendor2', N'HAFX101G', N'HAFX101G', N'V001-HAFX101G', N'046838049798', N'Inner Ear Headphones Green', NULL, CAST(0.10 AS Decimal(18, 2)), CAST(13.00 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.623' AS DateTime), CAST(N'2015-02-13 01:24:58.243' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67332, N'Vendor2', N'HAFX32D', N'HAFX32D', N'V001-HAFX32D', N'046838068935', N'Marshmallow Inner Ear Orange', NULL, CAST(0.05 AS Decimal(18, 2)), CAST(14.95 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.623' AS DateTime), CAST(N'2014-12-16 22:25:20.623' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67337, N'Vendor2', N'HAFX32G', N'HAFX32G', N'V001-HAFX32G', N'046838068942', N'Marshmallow Inner Ear Green', NULL, CAST(0.10 AS Decimal(18, 2)), CAST(14.95 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.623' AS DateTime), CAST(N'2014-12-16 22:25:20.623' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67347, N'Vendor2', N'HAFX32R', N'HAFX32R', N'V001-HAFX32R', N'046838068966', N'Marshmallow Inner Ear Red', NULL, CAST(0.10 AS Decimal(18, 2)), CAST(14.95 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.623' AS DateTime), CAST(N'2014-12-16 22:25:20.623' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67377, N'Vendor2', N'HAFX40S', N'HAFX40S', N'V001-HAFX40S', N'046838049743', N'In Ear Headphones Silver', NULL, CAST(0.20 AS Decimal(18, 2)), CAST(29.95 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.623' AS DateTime), CAST(N'2014-12-16 22:25:20.623' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67402, N'Vendor2', N'HAFX5P', N'HAFX5P', N'V001-HAFX5P', N'046838046803', N'Gumy Plus Headphone Pink', NULL, CAST(0.05 AS Decimal(18, 2)), CAST(9.99 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.623' AS DateTime), CAST(N'2014-12-16 22:25:20.623' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67442, N'Vendor2', N'HAFX8R', N'HAFX8R', N'V001-HAFX8R', N'046838048456', N'RIPTIDZ Headphones Red', NULL, CAST(0.05 AS Decimal(18, 2)), CAST(9.99 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.627' AS DateTime), CAST(N'2014-12-16 22:25:20.627' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67642, N'Vendor2', N'HAS160A', N'HAS160A', N'V001-HAS160A', N'046838046049', N'FLAT Headphones  Blue', NULL, CAST(0.30 AS Decimal(18, 2)), CAST(10.00 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.627' AS DateTime), CAST(N'2015-02-13 01:25:04.093' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67672, N'Vendor2', N'HAS200B', N'HAS200B', N'V001-HAS200B', N'046838049897', N'RIPTIDZ Headphones Black', NULL, CAST(0.55 AS Decimal(18, 2)), CAST(29.95 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.627' AS DateTime), CAST(N'2014-12-16 22:25:20.627' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (67732, N'Vendor2', N'HASR500B', N'HASR500B', N'V001-HASR500B', N'046838066122', N'Black Lightweight Headphone', NULL, CAST(0.50 AS Decimal(18, 2)), CAST(29.00 AS Decimal(18, 2)), NULL, N'JVC America', N'Headphones', N'Headphones Wired', CAST(N'2014-12-16 22:25:20.627' AS DateTime), CAST(N'2015-02-13 01:25:05.347' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (47691, N'Vendor2', N'iPL8B', N'IPL8B', N'V001-IPL8B', N'047532903461', N'Dual Charg Stereo iPad iPho Bk', NULL, CAST(2.68 AS Decimal(18, 2)), CAST(69.99 AS Decimal(18, 2)), NULL, N'iHome', N'Digital Media Players', N'iPod Docks & Speakers', CAST(N'2014-12-16 22:25:15.450' AS DateTime), CAST(N'2014-12-16 22:25:15.450' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (47719, N'Vendor2', N'F2B31AA#ABA', N'F2B31AAABA', N'V001-F2B31AAABA', N'888182023785', N'HP 15.6" Notebook Sleeve Red', NULL, CAST(0.80 AS Decimal(18, 2)), CAST(13.03 AS Decimal(18, 2)), NULL, N'PNY Technologies', N'Bags & Carry Cases', N'Notebook Bags & Sleeves', CAST(N'2014-12-16 22:25:15.450' AS DateTime), CAST(N'2015-02-13 01:20:23.203' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (48907, N'Vendor2', N'ONP1', N'ONP1', N'V001-ONP1', N'092636965921', N'15.4" NotePac Plus Case', NULL, CAST(3.25 AS Decimal(18, 2)), CAST(63.99 AS Decimal(18, 2)), NULL, N'Targus', N'Bags & Carry Cases', N'Notebook Bags & Sleeves', CAST(N'2014-12-16 22:25:15.463' AS DateTime), CAST(N'2014-12-16 22:25:15.463' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (57154, N'Vendor2', N'KL1508AM', N'KL1508AM', N'V001-KL1508AM', N'672792400629', N'17" 8-Port Cat5 LCD KVM', NULL, CAST(20.61 AS Decimal(18, 2)), CAST(1057.29 AS Decimal(18, 2)), NULL, N'Aten Corp', N'KVM & Peripheral Sharing', N'KVM LCD Consoles', CAST(N'2014-12-16 22:25:18.123' AS DateTime), CAST(N'2015-02-13 01:31:04.237' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (57208, N'Vendor2', N'KL1516AN', N'KL1516AN', N'V001-KL1516AN', N'672792400629', N'19" 16-Port Cat5 LCD KVM', NULL, CAST(53.50 AS Decimal(18, 2)), CAST(1949.95 AS Decimal(18, 2)), NULL, N'Aten Corp', N'KVM & Peripheral Sharing', N'KVM LCD Consoles', CAST(N'2014-12-16 22:25:18.123' AS DateTime), CAST(N'2014-12-16 22:25:18.123' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (47061, N'Vendor2', N'IP21GV', N'IP21G', N'V001-IP21G', N'047532895643', N'App Friendly AlarmClock Gunmtl', NULL, CAST(2.30 AS Decimal(18, 2)), CAST(59.99 AS Decimal(18, 2)), NULL, N'iHome', N'Digital Media Players', N'iPod Docks & Speakers', CAST(N'2014-12-16 22:25:15.093' AS DateTime), CAST(N'2014-12-16 22:25:15.093' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (51215, N'Vendor2', N'10069055862404', N'069055862407', N'V001-069055862407', N'069055862407', N'Braun Series 3 380 Wet Dry', NULL, CAST(1.20 AS Decimal(18, 2)), CAST(99.99 AS Decimal(18, 2)), NULL, N'Procter & Gamble', N'Beauty Care', N'Mens'' Grooming', CAST(N'2014-12-16 22:25:16.097' AS DateTime), CAST(N'2014-12-16 22:25:16.097' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (58340, N'Vendor2', N'WES9014PC', N'WES9014PC', N'V001-WES9014PC', N'037988564170', N'Combo Foil Blade For ES8228S', NULL, CAST(0.20 AS Decimal(18, 2)), CAST(32.00 AS Decimal(18, 2)), NULL, N'Panasonic', N'Beauty Care', N'Mens'' Grooming', CAST(N'2014-12-16 22:25:18.127' AS DateTime), CAST(N'2015-02-13 01:57:14.953' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (54462, N'Vendor2', N'10069055863975', N'10069055863975', N'V001-10069055863975', N'069055863978', N'Braun Cppr Legs and Body Epltr', NULL, CAST(1.35 AS Decimal(18, 2)), CAST(74.80 AS Decimal(18, 2)), NULL, N'Procter & Gamble', N'Beauty Care', N'Women''s Grooming', CAST(N'2014-12-16 22:25:17.267' AS DateTime), CAST(N'2015-02-13 00:30:57.550' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (54741, N'Vendor2', N'101B213EXENBBHB', N'101B213EXENBBHB', N'V001-101B213EXENBBHB', N'856282004249', N'iPad Executive Kiosk Black', NULL, CAST(3.00 AS Decimal(18, 2)), CAST(109.95 AS Decimal(18, 2)), NULL, N'Mac Locks', N'Mounts & Brackets', N'Brackets & Accessories', CAST(N'2014-12-16 22:25:17.267' AS DateTime), CAST(N'2014-12-16 22:25:17.267' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (54750, N'Vendor2', N'101B213EXENBOHB', N'101B213EXENBOHB', N'V001-101B213EXENBOHB', N'856282004249', N'iPad Executive Kiosk Black', NULL, CAST(3.00 AS Decimal(18, 2)), CAST(109.95 AS Decimal(18, 2)), NULL, N'Mac Locks', N'Mounts & Brackets', N'Brackets & Accessories', CAST(N'2014-12-16 22:25:17.267' AS DateTime), CAST(N'2014-12-16 22:25:17.267' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (48995, N'Vendor2', N'SHB301GR', N'SHB301GR', N'V001-SHB301GR', N'044476115585', N'Shutterball Green', NULL, CAST(0.10 AS Decimal(18, 2)), CAST(18.50 AS Decimal(18, 2)), NULL, N'Audiovox Electronics Corp.', N'Cell  Phones', N'Accessories', CAST(N'2014-12-16 22:25:15.783' AS DateTime), CAST(N'2015-02-13 01:47:12.560' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (49814, N'Vendor2', N'F4K70UT#ABA', N'F4K70UT', N'V001-F4K70UT', N'888182564141', N'21.5" AiO Pentium G3420 500GB', NULL, CAST(26.69 AS Decimal(18, 2)), CAST(804.00 AS Decimal(18, 2)), NULL, N'HP Business', N'Computers Desktop', N'Desktops All-in-One', CAST(N'2014-12-16 22:25:15.787' AS DateTime), CAST(N'2014-12-16 22:25:15.787' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (50273, N'Vendor2', N'9854-1301', N'98541301', N'V001-98541301', N'043917985282', N'Bump Control T Blade', NULL, CAST(0.90 AS Decimal(18, 2)), CAST(41.99 AS Decimal(18, 2)), NULL, N'Wahl', N'Beauty Care', N'Mens'' Grooming', CAST(N'2014-12-16 22:25:15.787' AS DateTime), CAST(N'2014-12-16 22:25:15.787' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (54840, N'Vendor2', N'101W213EXENWOHB', N'101W213EXENWOHB', N'V001-101W213EXENWOHB', N'856282004256', N'iPad Executive Kiosk White', NULL, CAST(3.20 AS Decimal(18, 2)), CAST(109.95 AS Decimal(18, 2)), NULL, N'Mac Locks', N'Bags & Carry Cases', N'Tablet Cases & Protection', CAST(N'2014-12-16 22:25:17.267' AS DateTime), CAST(N'2014-12-16 22:25:17.267' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (53048, N'Vendor2', N'4352G9U', N'4352G9U', N'V001-4352G9U', N'888228290546', N'TS S30 E5 1TB 8GB', NULL, CAST(38.00 AS Decimal(18, 2)), CAST(1962.70 AS Decimal(18, 2)), NULL, N'Lenovo', N'Computers Desktop', N'Workstations', CAST(N'2014-12-16 22:25:16.827' AS DateTime), CAST(N'2015-02-13 00:53:26.513' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (53601, N'Vendor2', N'PBX 1008', N'PBX1008', N'V001-PBX1008', N'606540014080', N'8" Portable Battery Spkr USB', NULL, CAST(32.00 AS Decimal(18, 2)), CAST(91.68 AS Decimal(18, 2)), NULL, N'QFX', N'Speakers', N'1 Piece Portable', CAST(N'2014-12-16 22:25:16.827' AS DateTime), CAST(N'2015-02-13 01:39:18.203' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (62496, N'Vendor2', N'D8E66UT#ABA', N'D8E66UT', N'V001-D8E66UT', N'887758500996', N'6470b i5 3230M 14.0 500 4 Win8', NULL, CAST(7.50 AS Decimal(18, 2)), CAST(919.00 AS Decimal(18, 2)), NULL, N'HP Business', N'Computers Notebooks', N'Notebooks', CAST(N'2014-12-16 22:25:20.117' AS DateTime), CAST(N'2014-12-16 22:25:20.117' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (62505, N'Vendor2', N'D8E66UT#ABA', N'D8E66UTEXCESS', N'V001-D8E66UTEXCESS', N'887758500996', N'14" i5 3230M 4GB 500GB', NULL, CAST(7.15 AS Decimal(18, 2)), CAST(919.00 AS Decimal(18, 2)), NULL, N'HP Commercial Refurb', N'Computers Notebooks', N'Notebooks', CAST(N'2014-12-16 22:25:20.117' AS DateTime), CAST(N'2014-12-16 22:25:20.117' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (93927, N'Vendor2', N'WES9087PC', N'WES9087PC', N'V001-WES9087PC', N'037988564200', N'Replacement Outer Foil', N'Replacement Outer Foil for Panasonic Shavers ES810', CAST(1.00 AS Decimal(18, 2)), CAST(15.50 AS Decimal(18, 2)), NULL, N'Panasonic Consumer', NULL, NULL, CAST(N'2014-12-18 12:03:38.500' AS DateTime), CAST(N'2015-02-13 01:57:15.767' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (71916, N'Vendor2', N'I2C12', N'I2C12', N'V001-I2C12', N'033991039148', N'Car Lighting Charger 12 Watt', NULL, CAST(0.20 AS Decimal(18, 2)), CAST(15.42 AS Decimal(18, 2)), NULL, N'Scosche', N'Digital Media Players', N'iPod Car Accessories', CAST(N'2014-12-16 22:25:24.207' AS DateTime), CAST(N'2015-02-13 01:26:57.067' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (71941, N'Vendor2', N'I2R', N'I2R', N'V001-I2R', N'033991038554', N'USB To Lightning Cable', NULL, CAST(0.15 AS Decimal(18, 2)), CAST(24.99 AS Decimal(18, 2)), NULL, N'Scosche', N'Digital Media Players', N'iPod Cables & Adapters', CAST(N'2014-12-16 22:25:24.207' AS DateTime), CAST(N'2014-12-16 22:25:24.207' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (59485, N'Vendor2', N'KX-TG4222N', N'KXTG4222N', N'V001-KXTG4222N', N'885170109162', N'Dect 6.0 Cordless Phone', NULL, CAST(1.75 AS Decimal(18, 2)), CAST(59.95 AS Decimal(18, 2)), NULL, N'Panasonic Consumer', N'Telecommunications', N'Cordless Phones', CAST(N'2014-12-16 22:25:18.583' AS DateTime), CAST(N'2014-12-16 22:25:18.583' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (59710, N'Vendor2', N'KX-TS4100B', N'KXTS4100B', N'V001-KXTS4100B', N'037988477425', N'4 Line Speaker Phone', NULL, CAST(3.80 AS Decimal(18, 2)), CAST(80.00 AS Decimal(18, 2)), NULL, N'Panasonic Consumer', N'Telecommunications', N'Corded Phones', CAST(N'2014-12-16 22:25:18.587' AS DateTime), CAST(N'2015-02-13 01:31:57.730' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (59728, N'Vendor2', N'KX-TS4300B', N'KXTS4300B', N'V001-KXTS4300B', N'037988477449', N'4 Line Speaker Phone', NULL, CAST(3.90 AS Decimal(18, 2)), CAST(137.00 AS Decimal(18, 2)), NULL, N'Panasonic Consumer', N'Telecommunications', N'Corded Phones', CAST(N'2014-12-16 22:25:18.587' AS DateTime), CAST(N'2015-02-13 01:31:57.927' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (59737, N'Vendor2', N'KX-TS500B', N'KXTS500B', N'V001-KXTS500B', N'037988474165', N'Integrated Corded Phone', NULL, CAST(1.40 AS Decimal(18, 2)), CAST(11.00 AS Decimal(18, 2)), NULL, N'Panasonic Consumer', N'Telecommunications', N'Cordless Phones', CAST(N'2014-12-16 22:25:18.587' AS DateTime), CAST(N'2015-02-13 01:31:58.050' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (72776, N'Vendor2', N'IBT16PC', N'IBT16PC', N'V001-IBT16PC', N'047532901375', N'Bluetooth Mini Cube Pink', NULL, CAST(0.65 AS Decimal(18, 2)), CAST(26.27 AS Decimal(18, 2)), NULL, N'iHome', N'Speakers', N'1 Piece Portable', CAST(N'2014-12-16 22:25:24.210' AS DateTime), CAST(N'2015-02-13 01:27:10.400' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (72780, N'Vendor2', N'ES-LA63-S', N'ESLA63S', N'V001-ESLA63S', N'037988566532', N'4 Head Shaver w Vibrating Head', NULL, CAST(1.55 AS Decimal(18, 2)), CAST(133.00 AS Decimal(18, 2)), NULL, N'Panasonic', N'Beauty Care', N'Mens'' Grooming', CAST(N'2014-12-16 22:25:24.210' AS DateTime), CAST(N'2015-02-13 01:19:17.670' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (72786, N'Vendor2', N'IBT16UC', N'IBT16UC', N'V001-IBT16UC', N'047532901658', N'Bluetooth Mini Cube Purple', NULL, CAST(0.65 AS Decimal(18, 2)), CAST(49.99 AS Decimal(18, 2)), NULL, N'iHome', N'Speakers', N'1 Piece Portable', CAST(N'2014-12-16 22:25:24.210' AS DateTime), CAST(N'2014-12-16 22:25:24.210' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (72791, N'Vendor2', N'IBT20GC', N'IBT20GC', N'V001-IBT20GC', N'047532902440', N'Bluetooth FM Clock Radio USB', NULL, CAST(2.75 AS Decimal(18, 2)), CAST(54.75 AS Decimal(18, 2)), NULL, N'iHome', N'Digital Media Players', N'iPod Docks & Speakers', CAST(N'2014-12-16 22:25:24.210' AS DateTime), CAST(N'2015-02-13 01:27:10.490' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (72866, N'Vendor2', N'iBT60BC', N'IBT60BC', N'V001-IBT60BC', N'047532902242', N'Bluetooth Mini Speaker Black', NULL, CAST(0.62 AS Decimal(18, 2)), CAST(39.99 AS Decimal(18, 2)), NULL, N'iHome', N'Speakers', N'1 Piece Portable', CAST(N'2014-12-16 22:25:24.210' AS DateTime), CAST(N'2014-12-16 22:25:24.210' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (72876, N'Vendor2', N'iBT60UC', N'IBT60UC', N'V001-IBT60UC', N'047532902372', N'Bluetooth Mini Speaker Purple', NULL, CAST(0.40 AS Decimal(18, 2)), CAST(39.99 AS Decimal(18, 2)), NULL, N'iHome', N'Speakers', N'1 Piece Portable', CAST(N'2014-12-16 22:25:24.210' AS DateTime), CAST(N'2014-12-16 22:25:24.210' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (69909, N'Vendor2', N'79520-500', N'79520500', N'V001-79520500', N'043917795164', N'Chrome Pro Haircutting Kit', NULL, CAST(2.05 AS Decimal(18, 2)), CAST(46.99 AS Decimal(18, 2)), NULL, N'Wahl', N'Beauty Care', N'Mens'' Grooming', CAST(N'2014-12-16 22:25:22.417' AS DateTime), CAST(N'2014-12-16 22:25:22.417' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (69919, N'Vendor2', N'79600-2101', N'796002101', N'V001-796002101', N'043917796031', N'Lithium Ion Clipper Kit', NULL, CAST(2.05 AS Decimal(18, 2)), CAST(93.99 AS Decimal(18, 2)), NULL, N'Wahl', N'Beauty Care', N'Mens'' Grooming', CAST(N'2014-12-16 22:25:22.417' AS DateTime), CAST(N'2014-12-16 22:25:22.417' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (69929, N'Vendor2', N'79900-1501', N'799001501', N'V001-799001501', N'043917799032', N'Clip n Trim Red', NULL, CAST(2.00 AS Decimal(18, 2)), CAST(46.99 AS Decimal(18, 2)), NULL, N'Wahl', N'Beauty Care', N'Mens'' Grooming', CAST(N'2014-12-16 22:25:22.417' AS DateTime), CAST(N'2014-12-16 22:25:22.417' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (61437, N'Vendor2', N'ANT 5', N'ANT5', N'V001-ANT5', N'606540008775', N'Flat Indoor Antenna HD DTV VHF', NULL, CAST(0.40 AS Decimal(18, 2)), CAST(9.99 AS Decimal(18, 2)), NULL, N'QFX', N'TV & Accessories', N'Antennas', CAST(N'2014-12-16 22:25:19.337' AS DateTime), CAST(N'2014-12-16 22:25:19.337' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (70078, N'Vendor2', N'303W250MPOSW', N'303W250MPOSW', N'V001-303W250MPOSW', N'856282004270', N'iPad Mini POS Kiosk Wht Side P', NULL, CAST(5.00 AS Decimal(18, 2)), CAST(179.95 AS Decimal(18, 2)), NULL, N'Mac Locks', N'Tablets', N'Accessories', CAST(N'2014-12-16 22:25:22.417' AS DateTime), CAST(N'2014-12-16 22:25:22.417' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (70083, N'Vendor2', N'303W255POSW', N'303W255POSW', N'V001-303W255POSW', N'856282004270', N'iPad POS Kiosk Wht Slide Pro', NULL, CAST(5.50 AS Decimal(18, 2)), CAST(179.95 AS Decimal(18, 2)), NULL, N'Mac Locks', N'Tablets', N'Accessories', CAST(N'2014-12-16 22:25:22.417' AS DateTime), CAST(N'2014-12-16 22:25:22.417' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (70306, N'Vendor2', N'ECM-AW3', N'ECMAW3', N'V001-ECMAW3', N'027242748736', N'Bluetooth Wireless Microphone', NULL, CAST(0.50 AS Decimal(18, 2)), CAST(229.99 AS Decimal(18, 2)), NULL, N'Sony Audio/Video', N'Cameras & Frames', N'Camcorder Accessories', CAST(N'2014-12-16 22:25:22.417' AS DateTime), CAST(N'2014-12-16 22:25:22.417' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (85039, N'Vendor2', N'303W225POSW', N'303W225POSW', N'V001-303W225POSW', N'856282004270', N'SlidePro iPad POS Kiosk White', N'Slide Pro iPad POS Kiosk - White. Fits iPad 2, iPa', CAST(6.50 AS Decimal(18, 2)), CAST(129.26 AS Decimal(18, 2)), NULL, N'Mac Locks', NULL, NULL, CAST(N'2014-12-18 11:27:48.177' AS DateTime), CAST(N'2014-12-21 19:52:04.737' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (63870, N'Vendor2', N'LV290AA#ABA', N'LV290AAABA', N'V001-LV290AAABA', N'886111610266', N'HP Wireless Desktop Combo', NULL, CAST(1.85 AS Decimal(18, 2)), CAST(29.99 AS Decimal(18, 2)), NULL, N'PNY Technologies', N'Input Devices Wireless', N'Bundle-Keyboard & Mouse', CAST(N'2014-12-16 22:25:20.497' AS DateTime), CAST(N'2014-12-16 22:25:20.497' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (79272, N'Vendor2', N'TVPRAMP1R', N'TVPRAMP1R', N'V001-TVPRAMP1R', N'044476071669', N'Antenna Pre Amplifier', NULL, CAST(1.16 AS Decimal(18, 2)), CAST(19.00 AS Decimal(18, 2)), NULL, N'Audiovox Accessories', N'TV & Accessories', N'Antennas', CAST(N'2014-12-16 22:25:27.240' AS DateTime), CAST(N'2015-02-13 01:54:09.703' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (65328, N'Vendor2', N'DMC-FZ200K', N'DMCFZ200K', N'V001-DMCFZ200K', N'885170087804', N'12.1mp Digital Camera Black', NULL, CAST(2.20 AS Decimal(18, 2)), CAST(488.08 AS Decimal(18, 2)), NULL, N'Panasonic Consumer', N'Cameras & Frames', N'Digital SLRs', CAST(N'2014-12-16 22:25:20.570' AS DateTime), CAST(N'2015-02-13 01:16:19.127' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (65348, N'Vendor2', N'DMC-TS25K', N'DMCTS25K', N'V001-DMCTS25K', N'885170116993', N'16.1mp Digital Camera Black', NULL, CAST(0.80 AS Decimal(18, 2)), CAST(152.77 AS Decimal(18, 2)), NULL, N'Panasonic Consumer', N'Cameras & Frames', N'Digital Point & Shoot', CAST(N'2014-12-16 22:25:20.570' AS DateTime), CAST(N'2015-02-01 12:04:34.723' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (65579, N'Vendor2', N'GT-P5210ZWYXAR', N'GTP5210ZWYXAR', N'V001-GTP5210ZWYXAR', N'887276981727', N'10" GalaxyTab3 16GB white', NULL, CAST(1.80 AS Decimal(18, 2)), CAST(479.99 AS Decimal(18, 2)), NULL, N'Samsung IT', N'Tablets', N'Android based', CAST(N'2014-12-16 22:25:20.570' AS DateTime), CAST(N'2014-12-16 22:25:20.570' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (68983, N'Vendor2', N'29115', N'29115', N'V001-29115', N'040102291159', N'Andis Clipper Trimmer Combo', NULL, CAST(2.95 AS Decimal(18, 2)), CAST(42.50 AS Decimal(18, 2)), NULL, N'Andis Company', N'Beauty Care', N'Mens'' Grooming', CAST(N'2014-12-16 22:25:21.530' AS DateTime), CAST(N'2015-02-13 00:45:50.330' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (89576, N'Vendor2', N'F2B31AA#ABA', N'HPF2B31AA', N'V001-HPF2B31AA', N'888182023785', N'HP 15.6" Notebook Sleeve Red', N'HP 15.6" Notebook Sleeve Red with silver hardware.', CAST(0.85 AS Decimal(18, 2)), CAST(13.09 AS Decimal(18, 2)), NULL, N'HP Consumer', NULL, NULL, CAST(N'2014-12-18 11:46:41.757' AS DateTime), CAST(N'2015-02-13 01:26:09.647' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (89591, N'Vendor2', N'LV290AA#ABA', N'HPLV290AA', N'V001-HPLV290AA', N'886111610266', N'HP Wireless Desktop Combo', N'HP Wireless Classic Desktop Combo', CAST(2.35 AS Decimal(18, 2)), CAST(16.33 AS Decimal(18, 2)), NULL, N'HP Consumer', NULL, NULL, CAST(N'2014-12-18 11:46:41.757' AS DateTime), CAST(N'2015-02-13 01:26:14.877' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (89682, N'Vendor2', N'I2BOXWT', N'I2BOXWT', N'V001-I2BOXWT', N'033991042353', N'Retractable Lightning Cable WT', N'Retractable Tangle-Free Cable Design  The retracta', CAST(0.10 AS Decimal(18, 2)), CAST(15.28 AS Decimal(18, 2)), NULL, N'Scosche', NULL, NULL, CAST(N'2014-12-18 11:46:41.757' AS DateTime), CAST(N'2014-12-21 20:12:16.103' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (89685, N'Vendor2', N'I2RA', N'I2RA', N'V001-I2RA', N'033991038554', N'Retract USB To Lightning Cable', N'Retractable Cable Design  The retractable design l', CAST(1.00 AS Decimal(18, 2)), CAST(14.58 AS Decimal(18, 2)), NULL, N'Scosche', NULL, NULL, CAST(N'2014-12-18 11:46:41.757' AS DateTime), CAST(N'2015-02-13 01:26:58.607' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (88157, N'Vendor2', N'DMC-LX7W', N'DMCLX7W', N'V001-DMCLX7W', N'885170087378', N'10MP Digital Still Camera Wht', N'Panasonic LUMIX DMC-LX7W 10.1 MP Digital Camera wi', CAST(1.40 AS Decimal(18, 2)), CAST(338.26 AS Decimal(18, 2)), NULL, N'Panasonic Consumer', NULL, NULL, CAST(N'2014-12-18 11:41:02.797' AS DateTime), CAST(N'2015-01-23 06:13:20.343' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (84342, N'Vendor2', N'101B213EXENB', N'101B213EXENB', N'V001-101B213EXENB', N'856282004249', N'iPad Executive Kiosk Black', N'Maclocks Black executive enclosure kiosk with tamp', CAST(3.00 AS Decimal(18, 2)), CAST(111.18 AS Decimal(18, 2)), NULL, N'Mac Locks', NULL, NULL, CAST(N'2014-12-18 11:26:05.693' AS DateTime), CAST(N'2015-02-13 00:31:06.620' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (84345, N'Vendor2', N'101W213EXENW', N'101W213EXENW', N'V001-101W213EXENW', N'856282004256', N'iPad Executive Kiosk White', N'Maclocks White executive enclosure kiosk with tamp', CAST(3.20 AS Decimal(18, 2)), CAST(111.18 AS Decimal(18, 2)), NULL, N'Mac Locks', NULL, NULL, CAST(N'2014-12-18 11:26:05.693' AS DateTime), CAST(N'2015-02-13 00:31:08.337' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (88424, N'Vendor2', N'51EF0420AA002', N'EF0420AA002', N'V001-EF0420AA002', N'054651177208', N'Aurvana In Ear3 Headphone', N'The Aurvana In-Ear3 are in-ear earphones powered b', CAST(0.55 AS Decimal(18, 2)), CAST(103.50 AS Decimal(18, 2)), NULL, N'Creative Labs', NULL, NULL, CAST(N'2014-12-18 11:42:20.907' AS DateTime), CAST(N'2015-02-13 01:18:18.693' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (87974, N'Vendor2', N'CV-102', N'CV102', N'V001-CV102', N'606540027783', N'Digital Converter Box', N'Digital Converter Box.  Receive Free Over-the-Air ', CAST(1.00 AS Decimal(18, 2)), CAST(28.00 AS Decimal(18, 2)), NULL, N'QFX', NULL, NULL, CAST(N'2014-12-18 11:40:31.730' AS DateTime), CAST(N'2015-02-13 01:14:38.137' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (88052, N'Vendor2', N'90NB0481-M09960', N'D550MAVDB01', N'V001-D550MAVDB01', N'886227801626', N'15.6" Intel N2830 4G DDR3 500G', N'Black Non-Touch Screen 15.6" HD (1366*768), glossy', CAST(6.80 AS Decimal(18, 2)), CAST(306.74 AS Decimal(18, 2)), NULL, N'ASUS Notebooks', NULL, NULL, CAST(N'2014-12-18 11:40:31.730' AS DateTime), CAST(N'2015-02-13 01:15:18.630' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (88053, N'Vendor2', N'90NB0481-M09960', N'D550MAVDB01DMO', N'V001-D550MAVDB01DMO', N'886227801626', N'15.6" Intel N2830 4G DDR3 500G', N'Black Non-Touch Screen 15.6" HD (1366*768), glossy', CAST(6.80 AS Decimal(18, 2)), CAST(306.74 AS Decimal(18, 2)), NULL, N'ASUS Notebooks', NULL, NULL, CAST(N'2014-12-18 11:40:31.730' AS DateTime), CAST(N'2015-02-13 01:15:18.720' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (89703, N'Vendor2', N'IBT60BY', N'IBT60BX', N'V001-IBT60BX', N'047532902242', N'Bluetooth Mini Speaker Black', N'iHome Bluetooth Rechargeable Mini Speaker System i', CAST(0.35 AS Decimal(18, 2)), CAST(27.00 AS Decimal(18, 2)), NULL, N'iHome', NULL, NULL, CAST(N'2014-12-18 11:47:16.527' AS DateTime), CAST(N'2015-02-13 01:27:10.887' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (89704, N'Vendor2', N'iBT60UY', N'IBT60UX', N'V001-IBT60UX', N'047532902372', N'Bluetooth Mini Speaker Purple', N'iHome Bluetooth Rechargeable Mini Speaker System i', CAST(0.40 AS Decimal(18, 2)), CAST(27.00 AS Decimal(18, 2)), NULL, N'iHome', NULL, NULL, CAST(N'2014-12-18 11:47:16.527' AS DateTime), CAST(N'2015-02-13 01:27:11.000' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (77405, N'Vendor2', N'SC-1325RED', N'SC1325RED', N'V001-SC1325RED', N'639131813250', N'Portable Speaker Red', NULL, CAST(0.50 AS Decimal(18, 2)), CAST(34.99 AS Decimal(18, 2)), NULL, N'Supersonic', N'Speakers', N'1 Piece Portable', CAST(N'2014-12-16 22:25:26.987' AS DateTime), CAST(N'2014-12-16 22:25:26.987' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (77475, N'Vendor2', N'SC-2300', N'SC2300SS', N'V001-SC2300SS', N'639131023000', N'DJ SPEAKER', NULL, CAST(7.50 AS Decimal(18, 2)), CAST(99.99 AS Decimal(18, 2)), NULL, N'Supersonic', N'Speakers', N'1 Piece Portable', CAST(N'2014-12-16 22:25:26.990' AS DateTime), CAST(N'2014-12-16 22:25:26.990' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (77555, N'Vendor2', N'SC-709', N'SC709', N'V001-SC709', N'639131007093', N'Portable MP3 CD Cassette USB', NULL, CAST(6.15 AS Decimal(18, 2)), CAST(39.50 AS Decimal(18, 2)), NULL, N'Supersonic', N'Home & Portable Audio', N'Personal CD & Boomboxes', CAST(N'2014-12-16 22:25:26.990' AS DateTime), CAST(N'2015-02-13 01:45:59.247' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (89506, N'Vendor2', N'HFH113-UM', N'HFH113NUM', N'V001-HFH113NUM', N'048894042461', N'Holmes Compact Heater Fan', N'Holmes Compact Heater Fan with Manual Controls. Wh', CAST(2.70 AS Decimal(18, 2)), CAST(13.00 AS Decimal(18, 2)), NULL, N'Jarden Home Environment', NULL, NULL, CAST(N'2014-12-18 11:46:04.370' AS DateTime), CAST(N'2015-02-13 01:25:51.267' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (89507, N'Vendor2', N'HFH113-TG', N'HFH113TG', N'V001-HFH113TG', N'048894042461', N'Small Fan Heater', N'Holmes Small Fan Heater with Manual Thermostat.', CAST(2.70 AS Decimal(18, 2)), CAST(16.00 AS Decimal(18, 2)), NULL, N'Jarden Home Environment', NULL, NULL, CAST(N'2014-12-18 11:46:04.370' AS DateTime), CAST(N'2014-12-21 20:11:43.360' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (70631, N'Vendor2', N'51EF0610AA008', N'EF0610AA008', N'V001-EF0610AA008', N'054651186958', N'HITZ MA350 InEar Headset Black', NULL, CAST(0.11 AS Decimal(18, 2)), CAST(39.99 AS Decimal(18, 2)), NULL, N'Creative Labs', N'Headphones', N'Headset & Mic Combos', CAST(N'2014-12-16 22:25:23.330' AS DateTime), CAST(N'2014-12-16 22:25:23.330' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (70654, N'Vendor2', N'81398124', N'81398124', N'V001-81398124', N'069055866818', N'Braun Cool Tec 5CC Blu Box Sys', NULL, CAST(2.65 AS Decimal(18, 2)), CAST(357.00 AS Decimal(18, 2)), NULL, N'Procter & Gamble', N'Beauty Care', N'Mens'' Grooming', CAST(N'2014-12-16 22:25:23.330' AS DateTime), CAST(N'2015-02-13 01:00:03.617' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (73801, N'Vendor2', N'iHM59WC', N'IHM59WC', N'V001-IHM59WC', N'047532900132', N'White Color Change Mini Speake', NULL, CAST(0.40 AS Decimal(18, 2)), CAST(19.99 AS Decimal(18, 2)), NULL, N'iHome', N'Digital Media Players', N'iPod Docks & Speakers', CAST(N'2014-12-16 22:25:24.700' AS DateTime), CAST(N'2014-12-16 22:25:24.700' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (73811, N'Vendor2', N'IHM60GY', N'IHM60GT', N'V001-IHM60GT', N'047532896213', N'CrystalTunes Mini Gray Speaker', NULL, CAST(0.40 AS Decimal(18, 2)), CAST(19.99 AS Decimal(18, 2)), NULL, N'iHome', N'Speakers', N'1 Piece Portable', CAST(N'2014-12-16 22:25:24.700' AS DateTime), CAST(N'2014-12-16 22:25:24.700' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (73816, N'Vendor2', N'IHM60LY', N'IHM60LT', N'V001-IHM60LT', N'047532895797', N'CrystalTunes Mini Blue Speaker', NULL, CAST(0.35 AS Decimal(18, 2)), CAST(19.99 AS Decimal(18, 2)), NULL, N'iHome', N'Speakers', N'1 Piece Portable', CAST(N'2014-12-16 22:25:24.700' AS DateTime), CAST(N'2014-12-16 22:25:24.700' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (73821, N'Vendor2', N'IHM60PN', N'IHM60PN', N'V001-IHM60PN', N'047532901412', N'Mini Speaker Neon Pink', NULL, CAST(0.35 AS Decimal(18, 2)), CAST(19.99 AS Decimal(18, 2)), NULL, N'iHome', N'Speakers', N'1 Piece Portable', CAST(N'2014-12-16 22:25:24.700' AS DateTime), CAST(N'2014-12-16 22:25:24.700' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (83409, N'Vendor1', N'SC1122WH', N'SUP-SC1122WH', N'V002-SUP-SC1122WH', N'639131611221', N'DANCING WATER SPEAKER,WHT', NULL, CAST(0.00 AS Decimal(18, 2)), CAST(29.99 AS Decimal(18, 2)), NULL, N'SUPERSONIC', NULL, NULL, NULL, CAST(N'2015-03-15 11:37:06.800' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (83424, N'Vendor1', N'SC1325ARD', N'SUP-SC1325ARD', N'V002-SUP-SC1325ARD', N'639131813250', N'PORTABLE SPEAKER,LI-ON', NULL, CAST(0.00 AS Decimal(18, 2)), CAST(24.99 AS Decimal(18, 2)), NULL, N'SUPERSONIC', NULL, NULL, NULL, CAST(N'2014-12-21 19:53:51.380' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (83439, N'Vendor1', N'SC1366BTBL', N'SUP-SC1366BTBL', N'V002-SUP-SC1366BTBL', N'639131313668', N'PORTABLE BLUETOOTH SPEAKE', NULL, CAST(0.00 AS Decimal(18, 2)), CAST(49.99 AS Decimal(18, 2)), NULL, N'SUPERSONIC', NULL, NULL, NULL, CAST(N'2015-03-15 11:37:09.597' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (83463, N'Vendor1', N'SC2300', N'SUP-SC2300', N'V002-SUP-SC2300', N'639131023000', N'PA SYSTEM,USB,MICRO SD', NULL, CAST(0.00 AS Decimal(18, 2)), CAST(99.99 AS Decimal(18, 2)), NULL, N'SUPERSONIC', NULL, NULL, NULL, CAST(N'2015-03-15 11:37:12.647' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (83486, N'Vendor1', N'SC507MP3RD', N'SUP-SC507MP3RD', N'V002-SUP-SC507MP3RD', N'639131805071', N'CD BOOMBOX,MP3,AM/FM,AUX', NULL, CAST(0.00 AS Decimal(18, 2)), CAST(59.00 AS Decimal(18, 2)), NULL, N'SUPERSONIC', NULL, NULL, NULL, CAST(N'2015-03-15 11:37:15.273' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (83498, N'Vendor1', N'SC709CD', N'SUP-SC709CD', N'V002-SUP-SC709CD', N'639131007093', N'CD BOOMBOX,MP3,CASSETTE', NULL, CAST(0.00 AS Decimal(18, 2)), CAST(59.00 AS Decimal(18, 2)), NULL, N'SUPERSONIC', NULL, NULL, NULL, CAST(N'2015-03-15 11:37:16.627' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (83777, N'Vendor1', N'79520500', N'WAHL-79520500', N'V002-WAHL-79520500', N'043917795164', N'HAIRCUT KIT,25 PIECES', NULL, CAST(0.00 AS Decimal(18, 2)), CAST(49.99 AS Decimal(18, 2)), NULL, N'WAHL', NULL, NULL, NULL, CAST(N'2015-03-15 11:37:47.383' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (83782, N'Vendor1', N'796002101', N'WAHL-796002101', N'V002-WAHL-796002101', N'043917796031', N'HAIR CLIPPER,LI-ION BATT', NULL, CAST(2.15 AS Decimal(18, 2)), CAST(99.99 AS Decimal(18, 2)), NULL, N'WAHL', NULL, NULL, NULL, CAST(N'2015-03-15 11:37:47.967' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (83783, N'Vendor1', N'799001501', N'WAHL-799001501', N'V002-WAHL-799001501', N'043917799032', N'HAIR CLIPPER,20 PIECES', NULL, CAST(0.00 AS Decimal(18, 2)), CAST(49.99 AS Decimal(18, 2)), NULL, N'WAHL', NULL, NULL, NULL, CAST(N'2015-03-15 11:37:48.083' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (83802, N'Vendor1', N'98541301', N'WAHL-98541301', N'V002-WAHL-98541301', N'043917985282', N'T-BLADE SHAVER/TRIMMER', NULL, CAST(0.00 AS Decimal(18, 2)), CAST(41.99 AS Decimal(18, 2)), NULL, N'WAHL', NULL, NULL, NULL, CAST(N'2015-03-15 11:37:50.313' AS DateTime))
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (89901, N'Vendor2', N'iM59WC', N'IM59WC', N'V001-IM59WC', N'047532900132', N'Color Change Mini Speaker Whit', N'iHome Rechargeable Color Changing Mini Speaker for', CAST(3.00 AS Decimal(18, 2)), CAST(16.16 AS Decimal(18, 2)), NULL, N'iHome', NULL, NULL, CAST(N'2014-12-18 11:47:16.527' AS DateTime), CAST(N'2015-02-13 01:27:44.660' AS DateTime))
GO
INSERT [dbo].[Product_TMP] ([ID], [OriginVendor], [ManufacturerSKU], [VendorSKU], [OurSKU], [UPC], [Title], [Description], [Weight], [MSRP], [MAP], [Manufacturer], [Category], [Subcategory], [DateCreated], [DateUpdated]) VALUES (89902, N'Vendor2', N'iM60GT', N'IM60GT', N'V001-IM60GT', N'047532896213', N'CrystalTunes Mini Speaker Gray', N'iHome Crystaltunes Rechargeable Mini Speaker for L', CAST(0.35 AS Decimal(18, 2)), CAST(16.16 AS Decimal(18, 2)), NULL, N'iHome', NULL, NULL, CAST(N'2014-12-18 11:47:16.527' AS DateTime), CAST(N'2015-02-13 01:27:44.767' AS DateTime))
SET IDENTITY_INSERT [dbo].[Product_TMP] OFF

-Sergio
I use Microsoft SQL 2008

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources