Database

Jassim Rahma wrote:

but I want to get order details as well?!

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

George Tsiga wrote:

My command

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Super Lloyd wrote:

am about to create 18 brand new table ...I don't want to make thing more complicated

WHERE
    WeekStartDate <= @SelectedEndDate
And
    WeekEndDate >= @SelectedStartDate

DECLARE @SelectedStartDate date = '20130815';
DECLARE @SelectedEndDate date = '20130830';

WITH cteOverlappingWeeks As
(
    SELECT
        StartDate,
        MON,
        TUE,
        WED,
        THUR,
        FRI,
        SAT,
        SUN
    FROM
        dbo.Timesheet
    WHERE
        StartDate <= @SelectedEndDate
    And
        EndDate >= @SelectedStartDate
),
ctePivotedWeeks (WorkDay, Hours) As
(
    SELECT
        StartDate,
        MON
    FROM
        cteOverlappingWeeks

    UNION ALL

    SELECT
        DateAdd(day, 1, StartDate),
        TUE
    FROM
        cteOverlappingWeeks

    UNION ALL

    SELECT
        DateAdd(day, 2, StartDate),
        WED
    FROM
        cteOverlappingWeeks

    UNION ALL

    SELECT
        DateAdd(day, 3, StartDate),
        THUR
    FROM
        cteOverlappingWeeks

    UNION ALL

    SELECT
        DateAdd(day, 4, StartDate),
        FRI
    FROM
        cteOverlappingWeeks

    UNION ALL

    SELECT
        DateAdd(day, 5, StartDate),
        SAT
    FROM
        cteOverlappingWeeks

    UNION ALL

    SELECT
        DateAdd(day, 6, StartDate),
        SUN
    FROM
        cteOverlappingWeeks
)
SELECT
    WorkDay,
    Hours
FROM
    ctePivotedWeeks
WHERE
    WorkDay Between @SelectedStartDate And @SelectedEndDate
ORDER BY
    WorkDay
;