john.arnott (2/13/2013)

---

With those three pieces of information, which function was used? The time offset forces us to say the UTC function. The further implication of the 330 minute...

davoscollective (2/14/2013)

---

The QoTD shows that when using NOT MATCHED that the src.RowNo =1 in the 'on clause' is not evaluated or at least not at the correct time. (Great question,...

Nice question. However, the explanation would have been better if it had pointed out that filters like this can be placed in the when matche/not matched conditions. In...

GilaMonster (2/13/2013)

---

Personally I find LMGTFY to be incredibly condescending, I'd feel quite insulted if someone gave me that kind of reply. I'll do the search for people if I don't...

john.arnott (2/13/2013)

---

I know I'm late to this party, but have to ask. What 4th statement? I see a Create Table, a Select Into and then a Select. ...

Well, I try to be...

One common purpose of combining two things into a single bucket is to create...

Carlo Romagnano (2/12/2013)

---

This case is simpler: NO CROSS JOIN NEEDED.

Get result in text format:

create table #temp1(PK int IDENTITY Primary Key, column1 varchar(20))

insert into #temp1 values ('employee 1')

insert into #temp1 values...

The correct answer is something like "none of these is correct but there's a fair probability of getting the right result most of the time with query 3 since the...

there...

chained

Nice interesting question.

But why 2 points instead of just 1? It isn't difficult, or complicated. Is it to encourage people who don't know the answer to read a...

Hugo Kornelis (2/11/2013)

---

When picking my answer, I knew I had a 50/50 chance, because my mindreading skills are still not on par with my SQL skills.

There were two options.

1. The...

It's a tube of heavy paper filled with althernating lengths of fuse and tightly confined piles of...

Lynn Pettis (2/8/2013)

---

Not really, other than having someone call me one here on the...