( IDAREA INT,

DATEREG date NOT NULL,

IDPROD [NVARCHAR](50) NOT NULL

);

INSERT INTO SALESHS

( IDAREA, DATEREG, IDPROD)

( 1, '03/12/2019', 'xplpc'),

( 1, '03/15/2019', 'ndtlctm'),

( 2, '04/12/2019', 'wntd')

CREATE TABLE Calendar

(

[CalendarDate] DATE

,[MonthName] AS FORMAT(CONVERT(DATE, DATEADD(m, DATEDIFF(m, 0, CalendarDate), 0)), 'MMM-yyyy')

,[MonthNo] AS FORMAT(CalendarDate,'MM')

,[Year] AS FORMAT(CalendarDate,'yyyy')

,DateKey AS CONCAT(FORMAT(CalendarDate,'yyyy'), FORMAT(CalendarDate,'MM'))

)

DECLARE @Date DATE, @StartDate DATE, @EndDate DATE

SET @Date = '01/01/2012'

SET @StartDate = CONVERT(DATE, DATEADD(m, DATEDIFF(m, 0, @Date), 0)) /* Set Start date to first day of the month for given date */

SET @EndDate = '04/01/2019'

WHILE @StartDate <= @EndDate

INSERT INTO Calendar (CalendarDate)

SELECT @StartDate

SET @StartDate = DATEADD(m, 1, @StartDate)