Using SSRS to Export SQLServer data to multiple Excel Sheets

Last week I had blogged about how to export SQL Server data to multiple sheets of an Excel file using SSIShttp://visakhm.blogspot.in/2013/09/exporting-sqlserver-data-to-multiple.html One of my readers asked me whether we could achieve this using any other method. There’s a much easier…

T-SQL to DAX: Simulating PERCENTILE_CONT analytic function

PERCENTILE_CONT is used for calculating a percentile based on a continuous distribution of the column value. From ORACLE SQL documentation:The result of PERCENTILE_CONT is computed by linear interpolation between values after ordering them. Using the percentilevalue (P) and the number of rows…