Saturday, August 30, 2014

Shared Dataset for SSRS - Data Defaults

By "Week", I mean what week of the month it is, as I provided in my example.


The week of August 3rd, the week of August 10th, etc. This is a concept that can be found in MDX and Analysis Services. It's a pretty standard thing. I have not found anything similar to this construct that is native to T-SQL. I cannot do something similar in T-SQL.


What I don't need is just the number of the week in the year. Again, I've found nothing similar in T-SQL. I've only seen Month and Year functions.


This is what MDX returns with regards to Week:





A. M. Robinson


No comments:

Post a Comment