SQLスキルのデータベースは、ケースを整理する

DECLARE @Day SmallDateTime
SET @Day = DateAdd(MM, DateDiff(MM,0,'2019-11-21'), 0)

;WITH Temp AS
( SELECT @Day AS RQ UNION ALL
    SELECT RQ+1
    FROM TEMP WHERE DateDiff(Month,RQ+1,@Day) = 0
)
SELECT
    RN = Row_Number() Over(ORDER BY RQ),
    RQ
FROM Temp WHERE DatePart(WEEKDAY,RQ)= (07-@@@DateFirst) % 7 + 1

DECLARE @RQ SMALLDATETIME
SET @RQ = '2019-09-01';

;WITH
  tAppDays (fDay) AS
  (
    SELECT @RQ AS fDay
    UNION ALL
    SELECT fDay + 1 FROM tAppDays WHERE DateDiff(Month,fDay+1,@RQ) = 0
  )
SELECT * FROM tAppDays ORDER BY fDAY

-- SPLIT method that uses recursion to get a given string

DECLARE @CommentStr NVARCHAR(4000)='General Manager's Office|Sales Department|Accounting Department|Human Resources Department|Trade Union|Logistics Department|Production Planning Department|Power Branch|Quality Inspection Department|Transportation Department'
DECLARE @Split NVARCHAR(1)='|';

WITH Temp AS
( SELECT 1 AS Num UNION ALL
   SELECT Num + 1
   FROM TEMP WHERE Num<Len(@CommentStr) )
SELECT
  RN = Row_Number() Over(ORDER BY Num),
  SplitStr = SUBSTRING(@CommentStr,Num,CHARINDEX(@Split,@CommentStr+@Split,Num)-Num)
FROM Temp WHERE SUBSTRING(@Split+@CommentStr,Num,1) = @Split OPTION(MAXRECURSION 0);

-- ================================================================================================
-- pAppGetSplit '|','Subject name|ID number|student name|instructor number|instructor name|training times|total times|responsibility percentage'
================================================================================================
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'pAppGetSplit' AND type = 'P')
   DROP PROCEDURE pAppGetSplit
GO
CREATE PROCEDURE pAppGetSplit
  @Split VARCHAR(1),
  @STR NVARCHAR(4000)
AS
  WITH Temp AS -- Get a list of fields by separator
  ( SELECT 1 AS Num UNION ALL
     SELECT Num + 1
     FROM TEMP WHERE Num<Len(@STR) )
  SELECT
    RN = Row_Number() Over(ORDER BY Num),
    SplitStr = SUBSTRING(@STR,Num,CHARINDEX(@Split,@STR+@Split,Num)-Num)
  FROM Temp WHERE SUBSTRING(@Split+@STR,Num,1) = @Split OPTION(MAXRECURSION 0);
GO

--get the date of the Monday of the week
DECLARE @Z SMALLINT
-- [1,2,3,4,5,6,7] for [Mon,Tue,Wed,Thu,Fri,Sat,Sun] respectively
SET @Z=1
SELECT
  GetDate() Today,
  DATEPART(Weekday,GetDate()) Today's serial number,
  (DATEPART(Weekday,GetDate()) + @@DATEFIRST-1)%7 What day of the week it is,
  DATEADD(Day,@Z-(DATEPART(Weekday,GetDate()) + @@DATEFIRST-1)%7,GetDate()) Monday of the week