UPDATE tblConstants SET ConstantDate = '5/23/2013' WHERE ConstantLabel = 'LastSoldCheck'

SELECT tblInventory.InventoryNumber, tblInventory.DateSold, tblInventory.Price, DateDiff(d,tblInventory.DateSold,GetDate()) AS DaysSold, OnSpecial FROM tblInventory WHERE ( ((tblInventory.Price=1) OR (tblInventory.OnSpecial=3)) AND ((DateDiff(d,[tblInventory].[DateSold],GetDate()))>13) AND ((tblInventory.VehicleInvTypesID)<>6))

SELECT tblInventory.InventoryNumber, tblInventory.PriceChangeDate, tblInventory.Price, DateDiff(d,tblInventory.PriceChangeDate,GetDate()) AS DaysSpecial, OnSpecial FROM tblInventory WHERE ( (tblInventory.OnSpecial=2) AND ((DateDiff(d,[tblInventory].[PriceChangeDate],GetDate()))>13) AND ((tblInventory.VehicleInvTypesID)<>6))

IV#:12027 - Date New Price:4/20/2013 1:55:46 PM

UPDATE tblInventory SET OnSpecial = 0 WHERE InventoryNumber = '12027'

UPDATE bkof_tblInventory SET BK_OnSpecial = 0 WHERE BK_InventoryNumber = '12027'

IV#:12417 - Date New Price:5/1/2013 3:36:36 PM

UPDATE tblInventory SET OnSpecial = 0 WHERE InventoryNumber = '12417'

UPDATE bkof_tblInventory SET BK_OnSpecial = 0 WHERE BK_InventoryNumber = '12417'

IV#:11326 - Date New Price:11/1/2012 7:19:51 PM

UPDATE tblInventory SET OnSpecial = 0 WHERE InventoryNumber = '11326'

UPDATE bkof_tblInventory SET BK_OnSpecial = 0 WHERE BK_InventoryNumber = '11326'

IV#:11913 - Date New Price:10/23/2012 1:28:30 PM

UPDATE tblInventory SET OnSpecial = 0 WHERE InventoryNumber = '11913'

UPDATE bkof_tblInventory SET BK_OnSpecial = 0 WHERE BK_InventoryNumber = '11913'

IV#:11747 - Date New Price:4/30/2012

UPDATE tblInventory SET OnSpecial = 0 WHERE InventoryNumber = '11747'

UPDATE bkof_tblInventory SET BK_OnSpecial = 0 WHERE BK_InventoryNumber = '11747'

IV#:11772 - Date New Price:4/30/2012

UPDATE tblInventory SET OnSpecial = 0 WHERE InventoryNumber = '11772'

UPDATE bkof_tblInventory SET BK_OnSpecial = 0 WHERE BK_InventoryNumber = '11772'

IV#:11897 - Date New Price:11/1/2012 7:11:00 PM

UPDATE tblInventory SET OnSpecial = 0 WHERE InventoryNumber = '11897'

UPDATE bkof_tblInventory SET BK_OnSpecial = 0 WHERE BK_InventoryNumber = '11897'

IV#:12171 - Date New Price:3/12/2013 12:44:30 PM

UPDATE tblInventory SET OnSpecial = 0 WHERE InventoryNumber = '12171'

UPDATE bkof_tblInventory SET BK_OnSpecial = 0 WHERE BK_InventoryNumber = '12171'

IV#:12101 - Date New Price:3/28/2013 11:53:42 AM

UPDATE tblInventory SET OnSpecial = 0 WHERE InventoryNumber = '12101'

UPDATE bkof_tblInventory SET BK_OnSpecial = 0 WHERE BK_InventoryNumber = '12101'

IV#:12290 - Date New Price:3/25/2013 2:00:45 PM

UPDATE tblInventory SET OnSpecial = 0 WHERE InventoryNumber = '12290'

UPDATE bkof_tblInventory SET BK_OnSpecial = 0 WHERE BK_InventoryNumber = '12290'