DECLARE @Product TABLE (Date_From Datetime, Date_To Datetime, Product_ID INT, WeekDay INT)
DECLARE @Beg varchar(50), @End varchar(50) SET @one = 'Monday' SET @two = 'Tuesday' SET @three = 'Friday'
20/03/2011 to 31/03/2011
2011-03-20 2011-03-20 101 2011-03-21 2011-03-22 101 Mon,Tue 2011-03-23 2011-03-24 101 2011-03-25 2011-03-25 101 Fri 2011-03-26 2011-03-27 101 2011-03-28 2011-03-29 101 Mon,Tue 2011-03-30 2011-03-31 101
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)