This is a query I’ve written probably dozens of times but never actually saved. I often forget about the ‘HAVING’ clause, but it’s necessary as WHERE doesn’t cut it in these situations (the aggregation with COUNT(*)). 159 more words
Tags » SQL
Access uses cunning extended properties which live within SQL. However if you start altering the database manually or via DMO statements these get confused.
To remove all the Extended Properties, get Jamie Thompson’s script from… 17 more words
Conditionally Setting Column Visibility in SSRS
In this article I will show you real example of the usage of Column Visibility property in SSRS. Column visibility property is used to show or hide the column in the report. 303 more words
Never in my life I would imagine myself writing a blog post about such a scholastic subject, as normalization.
First, we all know what normalization is, we did study the normal forms in our first Database theory class (or SQL Primer, or whatever). 677 more words