Monthly Archives: April 2015

Literal Values in Scripts (VALUES() )

The Intransigent Data Blog Posted on by

Options for including literal values in scripts – syntax that I find particularly hard to remember. The feature is named Table Value Constructor. It was introduced in 2008 – see this article. Source of Merge statement MERGE INTO dbo.TargetTable AS Target … Continue reading →

SSRS Formatting Choices

The Intransigent Data Blog Posted on by

Hiding Objects for Export CSV Titles and headings (other than column headings) are typically not required in CSV export.  Text and column objects can be individually hidden from csv output: set the DataElementOutput property of the object to NoOutput PDF, Excel, etc Show … Continue reading →