Ed Wagner (11/4/2016)

---

djj (11/4/2016)

---

Hugo Kornelis (11/4/2016)

---

Stuart Davies (11/4/2016)

---

Ed Wagner (11/3/2016)

---

Luis Cazares (11/3/2016)

---

Ed Wagner (11/3/2016)

---

Manic Star (11/3/2016)

---

crookj (11/3/2016)

---

Ed Wagner (11/3/2016)

---

Loop...

If you don't have the tables, you could use the import/export wizard. It will create the tables. Just be aware that the data types might not be the best choice.

I'm...

Use ORDER BY and CASE.

Jeff Moden (11/3/2016)

---

Luis Cazares (11/3/2016)

---

I believe that you understood correctly, except for the part that the OP needs to get the MDX query instead of T-SQL.

I know it's possible but...

GilaMonster (11/4/2016)

---

Not a concern here, since XML columns, like the...

It seems correct, the only issue would be with xml columns, but I'm sure those would be handled differently.

stupidity

doug.brown (11/3/2016)

---

(Sorry, response in English) If I understand the Google translate correctly, you'll need to add something to your query to also include the sales from a year ago. ...

That's because you're not taking the hours into account. The difference comes from 2 quotes that you're not including (973 & 1057). Check them and decide if they belong to...

Sean Redmond (11/3/2016)

---

I had never thought so much that hardware was expensive, rather more that software licences and people were expensive. Microsoft play an expensive game.

In my experience, coding well...

Why do you even need a derived table?

SELECT

meetingID,

ProviderName,

SubGroupName,

SessionName,

Attendee =...

I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.

That said, can anyone explain to...

Kaye Cahs (11/2/2016)

---

C. Carl...

If there are only 2 values, you could use MAX and MIN with a validation...

Same here.