Search code examples
sqlsql-servercase-when

Insert into table when the day is Monday

Is there a way in which I can insert data from one table into another when today is Monday?

I tried making something like the below, using CASE WHEN, however it doesn't quite work right, any help would be welcomed

INSERT INTO [dbo].[WF_All]

SELECT (CASE WHEN (DATENAME(WEEKDAY,FLOOR(convert(float,getdate()))))='MONDAY' THEN  

(
SELECT [Parent Number]
  ,[Parent Name]
  ,[Customer Number]
  ,[Customer Name]
  ,[Collector]
  ,[Outstanding]

   FROM dbo.[Invoices]
 )

  ELSE  NULL END )
Solution

  • yes , like this :

    INSERT INTO [dbo].[WF_All]
SELECT [Parent Number]
  ,[Parent Name]
  ,[Customer Number]
  ,[Customer Name]
  ,[Collector]
  ,[Outstanding]
FROM dbo.[Invoices]
WHERE DATENAME(WEEKDAY,GETDATE()) = 'Monday'

    or

    ... WHERE DATEPART(WEEKDAY, GETDATE()) = 2 --Monday