I have continued to research this question, and I have come to the conclusion that the term "snowflake dimension" does not really describe what my intent is for the "addresses"...

Thanks for the reply, Greg. Based on the use cases for the facts in the database I'm dealing with, I don't think any fact tables will reference more than one...

I've been struggling through the logic of ISO 8601 myself. My solution does not look like anything I've seen in this thread yet, so I am posting my solution for...

I'm pretty sure this question is born out of the fact that T-SQL does not define the "first week of the year" in the same way as the ISO 8601...

Nigel,

I am unsure how this query, despite the fact that it generates a dynamic SQL statement, is vulnerable to a SQL injection attack. The values in the dynamically generated statement...

Here is a bit of dynamic SQL that should achieve the results you are looking for. I used your own suggested subquery in the places to populate the values of...

I read this comment on the day I wore my Green Lantern t-shirt. 🙂 Yes, I would pick Green Lantern for much the same reasons you mentioned. I also have...

I should have asked which version of Reporting Services you are running. The path to the report-only parameters (aka report filters) is quite different in 2005 compared to 2008.

In 2005...

I think the main concept that will solve your problem is the difference between query-based parameters and report-based parameters. Any parameter that is part of the query statement for the...

Although there is no "checkbox" object in Reporting Services, you can emulate one using a TextBox, if you are willing to have an "X" instead of an actual check mark...

In the Color property of the textbox that displays the value that should be red when it is below a particular threshhold, put a statement similar to the one below....

The datename() function returns the full name of the month, not the abbreviated form, and so the comparison term would be February, not Feb, and thus it would match %a%.

A...

As everyone else has pointed out, dob is not the column name given in the question as the column in question. Option A should read month(join_date) in (1,2,3,4,5,8) if it...

I read about your fix from the other forum. It sounds like that will work for this particular report.

When you get to creating new reports, consider putting the labels...