Home / T-SQL

T-SQL

DAX Set column to Zero based on Username()


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 »

Cannot truncate table because it is being referenced by a FOREIGN KEY constraint


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 »

Setup sp_send_dbmail attachment included!

sp_send_dbmail attachment


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 Age 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 »

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 »

Postcoderange opsplitsen naar losse records


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 Lost Customers using T-SQL

Calculate Lost Customers in SQL


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 »

How To Find the slowest SQL Queries

Slowest_SQL_Queries


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 »

Interesting Course about data visualisation from Google


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 »

How to Refresh Reporting Services Cache?

Dynamic Refresh SSRS Cache Using SQL


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 »

Doellijn/Stripline in Reporting Services


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 »