OPEN @WeekdayCursor
--
--SET @Weekdays = ''
--FETCH NEXT FROM @WeekdayCursor
--INTO @PriceAddID, @StartDate, @EndDate, @Weekdays
--
--WHILE @@FETCH_STATUS = 0
--BEGIN
--DECLARE @Position int
--  SET @Position = 0
--
--  DECLARE @NumDays int
--  SET @NumDays = DATEDIFF(day, @StartDate, @EndDate)
--
--  DECLARE @CurrentDate    datetime
--  DECLARE @CurrentBWeekday  int
--  DECLARE @Weekday int
--
--  WHILE (@Position < @NumDays + 1)
--  BEGIN
--    SET @CurrentDate = DATEADD(day, @Position, @StartDate)
--    -- Remember, SET DATEFIRST 1 for Monday
--    SET @CurrentBWeekday    = dbo.f_BWeekday(@CurrentDate)
--    -- Validate the weekday
--      --SET @Position = @Position + 1
--  IF (@Weekdays > 0 AND @CurrentBWeekday & @Weekdays <> @CurrentBWeekday)
--    BEGIN
--      SET @Position = @Position + 1
--      CONTINUE
--    END
--  SET @Weekday= (SELECT dbo.f_Bweekday(@CurrentDate))
--    INSERT INTO #weekdayprice VALUES(@PriceAddID, @StartDate, @EndDate, @Weekday)
--    SET @Position = @Position + 1
--  END
--
----Logic
--FETCH NEXT FROM @WeekdayCursor
--INTO @PriceAddID, @StartDate, @EndDate, @Weekdays
--END
--
--CLOSE @WeekdayCursor
--DEALLOCATE @WeekdayCursor

SELECT DISTINCT(weekdays), PriceAddID,
CASE weekdays	WHEN 0 THEN 'none'
				WHEN 1 THEN 'mo'
				WHEN 2 THEN 'tu'
				WHEN 4 THEN 'we'
				WHEN 8 THEN 'th'
				WHEN 16 THEN 'fr'
				WHEN 32 THEN 'sa'
				WHEN 64 THEN 'su'
END AS weekdayss
FROM #weekdayprice ORDER BY PriceAddID

DROP TABLE #weekdayprice