Tareas SQL

CREATE TABLE DIM_DATE_SEMESTER (
  pk_date_semester VARCHAR(6) NOT NULL PRIMARY KEY,
  Year INT,
  Semester VARCHAR(2)
);
DECLARE @year INT = 2007;
DECLARE @semester VARCHAR(2) = 'S1';
DECLARE @pk_date_semester VARCHAR(6);

WHILE @year <= 2022
BEGIN
  SET @pk_date_semester = CAST(@year AS VARCHAR(4)) + @semester;

  INSERT INTO DIM_DATE_SEMESTER (pk_date_semester, Year, Semester)
  VALUES (@pk_date_semester, @year, @semester);

  SET @semester = CASE @semester
    WHEN 'S1' THEN 'S2'
    ELSE 'S1'
  END;

  IF @semester = 'S1'
    SET @year = @year + 1;
END;