DexCore.Net

DECLARE @YYYYMMDD AS VARCHAR(8)='20180308' DECLARE @PREV_YYYY AS VARCHAR(4) --전년도 DECLARE @WK_NUM AS INT --주차 SELECT @PREV_YYYY = CONVERT(VARCHAR(4),CONVERT(INT,LEFT(@YYYYMMDD, 4)-1)) , @WK_NUM = DATEPART(WK, CONVERT(DATE,@YYYYMMDD)) ; WITH DATE_LIST AS ( SELECT CAST (@PREV_YYYY+'-01-01' AS DATETIME) AS DT UNION ALL SELECT DT+1 FROM DATE_LIST WHERE DT+1

DECLARE @YYYYMMDD AS VARCHAR(8)='20180308' SELECT CONVERT(VARCHAR(8),DATEADD(DAY, 1 - DATEPART(DW, CONVERT(DATE,@YYYYMMDD)) , CONVERT(DATE,@YYYYMMDD)),112) AS 시작일자 , CONVERT(VARCHAR(8),DATEADD(DAY, 7 - DATEPART(DW, CONVERT(DATE,@YYYYMMDD)) , CONVERT(DATE,@YYYYMMDD)),112) AS 종료일자

DECLARE @YYYYMMDD AS VARCHAR(8)='20180308' SELECT LEFT(@YYYYMMDD, 4) AS 년도, DATEPART(WK, CONVERT(DATE,@YYYYMMDD)) AS 주차

CREATE FUNCTION [mirae].[fn_GetWeekDayInfo] ( @P_indate NVARCHAR(10) -- 검색입력날짜 ) /* SELECT startdate AS WEEK_BEG, enddate AS WEEK_END, weekOfMonth AS WEEK_NUM, weekOfYear AS WEEK_YEAR FROM [mirae].[fn_GetWeekDayInfo]('20211228') */ RETURNS @ReturnTable TABLE ( startdate DATETIME, enddate DATETIME, weekOfMonth INT, weekOfYear INT ) AS BEGIN DECLARE @P_date DATETIME -- 검색일 DECLARE @P_startdate DAT..