Tag Archive: SQL

How-to-Solve-the-Wrong-Level-Of-Grain-Problem-in-SQL

How to Solve the “Wrong Level of Grain” Problem in SQL

In late 2007, two insurance industry collegues brought me into a problem they were having with an SSRS report which listed properties. They wanted to show a count of properties as well as note information for each property. Because each… (READ MORE)

SQL & Data

, , , , , , , , , , , , , , , , ,

Sql-Reporting-Services-To-Roambi

How to Refresh Roambi Reports With SSRS Subscriptions

SSRS is good with parameters, various data sources, subscriptions, and linked reports. But highly responsive and interactive reports (especially on a mobile device) is not what SQL Server Reporting Services is good at. The online BI tool, Roambi, however is… (READ MORE)

Business Intelligence

, , , , , , , , , , , , , ,

data-integration-sql-xml-cross-apply

Transformation Pattern with SQL, XML and CROSS APPLY

You don’t have to live with the repeated pain of transforming xml to rowset values when you need data from xml data stores. You also don’t need to transform and copy the data to relational database┬átables in MS SQL Server… (READ MORE)

SQL & Data

, , , , , , , , , , , , ,