It's a text field formatted MonthName + Year, e.g. "November 2011"

Oh, I think the idea has been sold. After my SSAS class I built a small demo with an encounters fact table and Location and Provider dimensions. It...

paul_ramster (9/19/2011)

---

... and if there are procedures from more than one category in an encounter, how to determine which category to include the encounter in? Is there a priority...

Okay... now I know that data belongs in your tables -- not in your code. In a perfect world. But there's not really a mechanism for categorizing the...

Altering the design of the procedures table isn't an option here since it is a 3rd party application. I also don't want duplicate rows in my results, i.e. even...

This is a great (and timely) article. I'm looking forward to the next installment. I watched your SQL Lunch presentation on re-executable T-sql and it has changed my...

P.S. I WISH I could change the db to not store dates as varchar, but it's a 3rd party app and that's just the way they designed it

However, I did...

I've tried both of those approaches and either way I still get the same error. Haven't I already done the conversion to a DATETIME in the view definition? ...