Home Forums SQL Server 2005 SQL Server 2005 General Discussion Issue with trying to incorporate the following SELECT DATEPART(WEEKDAY, GETDATE()) RE: Issue with trying to incorporate the following SELECT DATEPART(WEEKDAY, GETDATE())

  • October 20, 2010 at 10:08 am

    #1239794

    Hi try this,

    SELECT dateRange,DATEPART(WEEKDAY,dateRange)as Week_day

    from

    (

    SELECT dateRange FROM ##salesdays

    EXCEPT

    SELECT date FROM dbo.csta_non_working_days

    ) as t

    Thanks & Regards,
    MC