{"id":146,"date":"2023-05-18T11:40:50","date_gmt":"2023-05-18T11:40:50","guid":{"rendered":"https:\/\/datadandies.nl\/?p=146"},"modified":"2023-05-18T11:40:50","modified_gmt":"2023-05-18T11:40:50","slug":"maak-een-datum-dimensie-met-een-recursive-query-loop-in-sql","status":"publish","type":"post","link":"https:\/\/datadandies.nl\/index.php\/2023\/05\/18\/maak-een-datum-dimensie-met-een-recursive-query-loop-in-sql\/","title":{"rendered":"Maak een datum dimensie met een recursive query \/ loop in SQL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Wil je een lijst met datums genereren in SQL?&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Recursive queries kunnen je dan helpen. Een recursive query is een \u201cloop\u201d, oftewel, een query die zichzelf blijft herhalen. De syntax is relatief eenvoudig; in de onderstaande voorbeeld-query in T-SQL zeg je:&nbsp;&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Pak de datum 2020-01-01&#8230; (anchor member)&nbsp;<\/li>\n\n\n\n<li>En tel er steeds \u00e9\u00e9n dag bij op&#8230; (recursive part)&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tot ik zeg dat dit niet meer hoeft. (termination condition)&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Mocht je een complete datumtabel willen cre\u00ebren met behulp van een recursive query, moet je hierbij wel rekening houden met schrikkeljaren e.d.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"598\" src=\"https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230213-SQL-Recursive-query-list-of-dates-1024x598.png\" alt=\"\" class=\"wp-image-147\" srcset=\"https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230213-SQL-Recursive-query-list-of-dates-1024x598.png 1024w, https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230213-SQL-Recursive-query-list-of-dates-300x175.png 300w, https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230213-SQL-Recursive-query-list-of-dates-768x449.png 768w, https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230213-SQL-Recursive-query-list-of-dates-1536x897.png 1536w, https:\/\/datadandies.nl\/wp-content\/uploads\/2023\/05\/20230213-SQL-Recursive-query-list-of-dates-2048x1196.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Wil je een lijst met datums genereren in SQL?&nbsp; Recursive queries kunnen je dan helpen. Een recursive query is een \u201cloop\u201d, oftewel, een query die zichzelf blijft herhalen. De syntax is relatief eenvoudig; in de onderstaande voorbeeld-query in T-SQL zeg je:&nbsp;&nbsp; Mocht je een complete datumtabel willen cre\u00ebren met behulp van een recursive query, moet&hellip;<\/p>\n<p class=\"more-link\"><a href=\"https:\/\/datadandies.nl\/index.php\/2023\/05\/18\/maak-een-datum-dimensie-met-een-recursive-query-loop-in-sql\/\" class=\"themebutton\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[4],"class_list":["post-146","post","type-post","status-publish","format-standard","hentry","category-blog","tag-sql"],"_links":{"self":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/comments?post=146"}],"version-history":[{"count":1,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/146\/revisions"}],"predecessor-version":[{"id":148,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/146\/revisions\/148"}],"wp:attachment":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/media?parent=146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/categories?post=146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/tags?post=146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}