Hugo Kornelis (1/3/2013)

---

....

(And yes, 20000101 is yet another more or less randomly chosen base date. I used to use 19000101 here -it seemed appropriate to use the base date-, but...

Thanks, Hugo, for the correction. I like to think, however, that you'd agree that Michael V Jones's code above would be a bit more clear. Your two literal...

Hugo,

Just testing to see if we're reading carefully? 😉

Looks as though your option 2 is screwed up somehow, returning dates years off.

SELECT dateadd(month, datediff(month, getdate(), '20110101'), '20101231');

..... returns...

This is a straight-forward enough QOD, I suppose. But I do wonder what the point is of having the "Include_browse_information" switch to begin with. Why would MS think it...

I'm with you on that, Tom. I get confused enough by RIGHT joins, never mind a join with conditions in the ON clause that don't directly define the relationship....

Another good QOD on a new feature of SQL 2012. Thanks, Ron.

BTW, I'm sure some of those who chose wrong answers will want to blame Microsoft for...

SanDroid, your explanation has me puzzled. The first quote says that one cannot use an expression containing a float expression in the key column of an indexed view. ...

+1

One could bypass this speed-bump with an explicit...

Steve Jones - SSC Editor (12/4/2012)

---

A good reason why I don't like guaranteed contracts. I think there ought to be a reduction of the contract for injury, even in season,...

Malli,

First of all, thank you for submitting a QOD. Please don't be discouraged by the barrage of comments, but rather accept that by posting one of these, your words...

First, thank you for prodding me to read about STUFF, a function I'd seen mentioned but which I haven't used.

Your explanation of answer starts with

I could not find an...

sdolan 41249 (11/16/2012)

---

Our software manager indicated I could install SQL Server 2012 Express and be able to test out the new functions.

Anybody have experience with that? I...

Would method 1 be reliable even in the early morning hours? As SYSDATETIME() is non-deterministic, could it not use two slightly different values for the two calls?

I get the...

Thanks for the QOD, Tom.

I appreciate the heads-up that a deceptively simple condition (like "where myLetter between 'a' and 'Z'") could result in a surprise if one expects...