Advertisement
Guest User

Untitled

a guest
Nov 14th, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. CREATE PROCEDURE [dbo].[PopulateDimDates]
  2. @FromDate DATE = '2004-01-01',
  3. @ToDate DATE = '2020-12-31'
  4. AS
  5. BEGIN
  6.  
  7. --Setting language
  8. SET LANGUAGE English
  9.  
  10. --Populating Dimension
  11. WHILE @FromDate <= @ToDate
  12. BEGIN
  13. IF MONTH(@FromDate) < 10
  14. BEGIN
  15. INSERT INTO Czas(
  16. [id],
  17. [Miesiac],
  18. [Rok],
  19. [Kwartal]
  20. )
  21. SELECT
  22. CONCAT(0, MONTH(@FromDate), YEAR(@FromDate)) AS [id],
  23. MONTH(@FromDate) AS [Miesiac],
  24. YEAR(@FromDate) AS [Rok],
  25. DATENAME(QUARTER,@FromDate) AS [Quarter]
  26. SET @FromDate = DATEADD(MONTH, 1, @FromDate)
  27. END
  28. ELSE
  29. BEGIN
  30. INSERT INTO Czas(
  31. [id],
  32. [Miesiac],
  33. [Rok],
  34. [Kwartal]
  35. )
  36. SELECT
  37. CONCAT( MONTH(@FromDate), YEAR(@FromDate)) AS [id],
  38. MONTH(@FromDate) AS [Miesiac],
  39. YEAR(@FromDate) AS [Rok],
  40. DATENAME(QUARTER,@FromDate) AS [Quarter]
  41. SET @FromDate = DATEADD(MONTH, 1, @FromDate)
  42. END
  43. END
  44.  
  45. END
  46. GO
  47. exec [dbo].[PopulateDimDates]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement