SQL

A situation arose today where the key fields for an SSRS report just fitted into an A4 landscape page, but additional fields would be useful when exporting to Excel or CSV. Others seem to have had the same requirement and suggest setting the column visibility depending upon the render format. The suggestion works nicely once tweaked to cater for newer versions of Excel! Right click on the column and change the column visibility to “Show or hide based on an expression”: ...

A festive post for the twelfth day of Christmas and one way to avoid taking the decorations down for a while longer! If you have each gift from the “Twelve days of Christmas” song as an individual record in a SQL Server database table, can you write a query that returns one row for each verse of the song? Yes you can. This problem is similar to other cases where you need to flatten multiple rows into a single string. In this case for each day we want a comma separated list of the gifts for that day and all preceding days. ...