The advert is, of course, appalling. There needs to be space in life to be not working, so I hope the advert is more of a joke that a...

Sean Lange (4/23/2015)

---

Excellent question. I got it right by deduction more than understanding. I figured the scalar would run for each row but I would have thought the itvf would...

teodorom (4/22/2015)

---

Apart that I am an (exclusively) strong supporter of the stored procedures.

That is, given any business problem, I've never seen a situation where it was worthwhile not to use...

Dungeons

It's a good idea to do some logging when an error are detected, as well as trying to recover or contain the error.

And of course code defensively (detect the impossible...

I find it hard to understand why you think it should not return 32.

You are generating a column called [dim_vArticlesStyleDescription0_7] which is a copy of [StyleDescription] with the trailing...

Blues

Dance

Warfare

Interesting discussion.

I think Conery's article is excellent, never mind the phrasing look at what is being said.

It's a pity that some people seem to believe that using stored procedures for...

Hugo Kornelis (4/19/2015)

---

Oh, I absolutely am with you on the assumption that the data being queries is already aggregated on a per-month basis. I now, upon rereading, realise that my...

Hugo Kornelis (4/18/2015)

---

I personally think the first case is already crazy (who would ever type a literal NULL as the first argument to ISNULL anyway??). But for the sake of...

patricklambin (4/18/2015)

---

Thanks for this question which seems very simple and evident ( at least it is my own opinion ).

I am surprised that only half of the voters have found...

Hugo Kornelis (4/15/2015)

---

But note that supplying an offset only produces the expected results if you can be sure that there is exactly one row per month in the sales table....

I didn't know this, so responded with what the answer would be in my favoured world (I'm and XML hater, so far as putting the stuff as anything other than...