|
|
-
|
|
I had a post quite a while ago on how to use FOR XML clause with PATH mode, which is available since SQL 2005, to concatenate row values into columns. T-SQL – Concatenate row values in Transact-SQL We can achieve the same in SSRS with a wonderful aggr...
|
|
-
|
|
I had a post, MDX #7 – Get only 10 elements from a MDX query, which showed an example of using the TopCount() function to get the top 10 customers who have the most Internet Sales Amount. What can we do to get the top 5 resellers in each region/countr...
|
|
-
|
|
There is no IIF statement in SSIS scripting functions If you are looking for IIF() for SSIS expressions, you’ll be disappointed. Most of us are familiar with the IIF statement in SSRS expressions (or in many other scripting languages). But in SSIS...
|
|
-
|
|
Placeholder is a perfect solution for formatting substrings inside a textbox Formatting substrings inside a textbox in SSRS 2008 is no longer a problem. In the following example, one textbox can hold both the bolded and underlined title “Report Defin...
|
|
-
|
|
Very often, we are asked by our business users to explain certain behaviors of PivotTable in Excel. Our first instinct is to capture the MDX queries fired from Excel. Once I have the actual MDX query, I can analyze the query and the result, and wi...
|
|
-
|
|
Dimension attributes are always pre-sorted In my previous post, MDX #7 – Get only 10 elements from a MDX query, I mentioned that dimension attributes are always pre-sorted. This is obvious with the following query. Parent-child hierarchy is sorted...
|
|
-
|
|
No matter how much we were told that we are better off leaving TSQL behind when we are learning MDX, we are still trying to draw parallels between these two query languages. One command every SQL developer is very familiar with is the TOP 100 (or any n...
|
|
-
|
|
I have a blog, SSIS #108 – The Makeover of the Lookup Data Flow Component in SSIS 2008, a few months ago. Because of the two improvements of the lookup data flow component in SSIS 2008, the cache mode and the redirecting rows to no match output, I find ...
|
|
-
|
|
This is a test – publish to the new blog module. - Sherry...
|
|
-
|
|
I had many posts that share my experiences with using package configuration files to make my SSIS packages portable from my local development BIDS environment, to the test environment, and the production environment.
In the next few blogs, I’ll share with you a few simple steps to create your......
|
|