L' Eomot Inversé (7/25/2012)

---

I could remember 3 of the four answers, but on the mirroring one I was racking my brains to no avail, and finally gave up and consulted...

Thomas Abraham (7/24/2012)

---

Thanks kranthi1.aprdc for the question. I see you are relatively new to the site. So good to see you jumping in with a QotD contribution. As others have...

Interesting question, John. And great explanation of what's going on under the hood, Hugo!

Thanks to you both.

venoym (6/14/2012)

---

ronmoses (6/14/2012)

---

L' Eomot Inversé (6/14/2012)

---

Most of those errors were the same wrong answer, there appears to a widely distributed myth that any primary index is clustered unless it is...

Good question. I learned something, too.

But I also agree with the following...

L' Eomot Inversé (5/23/2012)

---

Unfortunately the explanation is all about implicit transactions, while the question is about an explicit transaction....

Sorry -- hadn't read your entire post. Looks like you don't have permissions to modify the table/indexes at all. That would rule out implementing my suggestion....

Do you have an index on the ID field? I presume you would....

This might be a situation where it would be worth creating a computed column that contained only the...

How about...

select cast(datepart(Year,[Net_Day]) as varchar) + '/' + right('0' + cast(datepart(Month,[Net_Day]) as varchar),2) as [Year/Month],

cast(datepart(Year,[Net_Day]) as varchar) +...

Great question. Looking forward to using this feature in an upcoming project....

Lynn,

You're absolutely correct. There are quite a few unknowns here.

But I made qualified assumption based on the OP's initial post, which said,

select cast(selection as varchar(1))+cast(period as varchar(1)) as number from...

If the range of values for u.selection and u.period are constrained to single digit integers [1-9], why not skip the cast as varchar/int parts and just work with integer values,...

I'll add my voice to those saying this was a rather poorly worded, ambiguous question.

I took the third option to mean, 'Technically no, but you can mostly simulate foreign key...

Good question. Learned something...again!

If you only want to see the Encounter value once in the result set, I'd add...

Great question. Definitely learned something today.

I agree that the typo was a serious distraction, but I thought it was pretty obviously a typo and I assumed that QOTD would NEVER,...