Koen Verbeeck (4/9/2014)

---

Another side effect from SSMS is that it has to display all the rows in the result set. It might do it not so efficiently as SSRS.

(just a...

Sean Lange (4/7/2014)

---

Oblivion (4/7/2014)

---

Using the ISNULL() method you will also have to account for the user deleting description1 or effectively setting it to ''. You will need to pick up...

Using the ISNULL() method you will also have to account for the user deleting description1 or effectively setting it to ''. You will need to pick up that change at...

My opinion is that the short term pain of learning the MDX/Cube environment will far outweigh the countless number of new SQL queries/modifications you'll be writing when the business expands...

Daniel Bowlin (10/25/2012)

---

It concerns me a bit that you have 2 different week numbers. Personally I would be inclined to change one of them. The business must have...