I have written a little bit of code that is external to the cart that rotates your "Featured Items" based on a date.
There is a separate table that needs to be built.... you can do that with THIS bit of code run in your SQL Management Studio:
/****** Object: Table [dbo].[AES_FeaturedItems] Script Date: 09/23/2010 12:08:30 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AES_FeaturedItems](
[SKU] [nvarchar](20) NOT NULL,
[StartDate] [date] NOT NULL,
[EndDate] [date] NOT NULL,
CONSTRAINT [PK_AES_FeaturedItems] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
.... that will create a table called dbo.AES_FeaturedItems
Next, populate that table with the SKU (not the item number), the Start Date and the End Date that you wish the item to be featured. READ
BELOW FOR CAVEATS.
Now, create this SP by running the script below:
CREATE PROC dbo.AES_UpdateFeaturedItems AS
SELECT SKU, StartDate, EndDate
FROM dbo.AES_FeaturedItems t WHERE
(DATEPART(month,t.StartDate) <= DATEPART(month,GETDATE())
AND DATEPART(day,t.StartDate) <= DATEPART(day,GETDATE()))
(DATEPART(month,t.EndDate) >= DATEPART(Month,GETDATE())
AND DATEPART(day,t.EndDate) >= DATEPART(day,GETDATE()));
/* Clear the Featured Items flag in the Smith_Products table */
UPDATE dbo.Smith_Products SET Featured=0;
/* Set the Featured Item flag in the database accordingly */
FROM dbo.Smith_Products sp
INNER JOIN #tmp_Featured tf
ON sp.ModelNumber = tf.SKU;
..... now, here's the caveats.
... that's all there is to it! I run my batch file nightly, so that it updates my featured items on my web page, depending on the dates in the database.