Issue with trying to incorporate the following SELECT DATEPART(WEEKDAY, GETDATE())

• steve4134

  SSC Enthusiast

  Points: 171

  More actions

  October 20, 2010 at 8:19 am

  #141198

  Hey All

  I am new to SQL development and come from a help desk background. This is one of my first projects and I am stuck. My out come would be to use the- SELECT DATEPART(WEEKDAY, GETDATE())- into a current table I have set up. The following code attached is what I am working with. My outcome would be to create another column next to my results with numeric values next to the dates. I am stuck by only getting the current date but I would like it to go for my whole selected date range. Any help is appreciated. This screen shot was from yesterday so I understand today would be 4 and so on.

  Steve

  SELECT * FROM ##salesdays

  EXCEPT

  SELECT date FROM dbo.csta_non_working_days

  SELECT DATEPART(WEEKDAY, GETDATE())

  This gives me the following results below in the image.

  

• only4mithunc

  SSCrazy Eights

  Points: 8434

  More actions

  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

• steve4134

  SSC Enthusiast

  Points: 171

  More actions

  October 20, 2010 at 1:01 pm

  #1239872

  Thank you very much. This was the fix I needed. Thank you again.

  Steve