Home / Tag Archives: SQL

Tag Archives: SQL

T-TSQL – Create 4 week Moving Total


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

Calculate time in hours and minutes between two dates


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

After update trigger


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

Dichtstbijzijnde werkdag uitrekenen


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

Nederlandse feestdagen in SQL Server


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

Centraliseren van KPI’s in je Datawarehouse


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

Running Totals / Cumulatieven berekenen

Cumulatieven berekenen SQL Server


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

Script alle databases en objecten


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

Hoe maak ik een datum dimensie?


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

Rekenen met datums


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

Dubbele rijen vinden


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

Query Active Directory


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

Recursieve Query met CTE I


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

Datum omzetten naar een Integer


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »

De 3 beste manieren – Kolom zoeken in een SQL database


Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 76

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /home/kraije21/domains/sqlblog.nl/public_html/wp-content/plugins/seo-auto-links/seo-auto-links.php on line 246

Read More »