Nandhini Ramanujam (5/31/2012)

---

Query 3 would fail because both tables contain employee id column but, alias name of employee id have not been used in order by clause. Please check for...

This one was so easy that I was looking for the "trick." I kept look and looking but never found one so I finally submitted my answer. I...

You got me on this one. I didn't know this would produce an error and according to the current stats on who answered it incorrectly, I'm not the only...

Yes, got that one in my list posted previously.

It could stand for any of the following:

Security Support Provider Interface (Microsoft)

Security Service Provider Interface (Microsoft)

Society of Satellite Professionals International

Steady-State Plasma Insulin

Signs and Symptoms of Psychotic Illness (rating scale)

Salle de...

Why in the world would someone create a checkbox question with 5 possible answers and tell you to select 4 of them? Why not make it a radio button...

I agree. Along...

No. That's the server version I use most of the time. It was introduced in 2008.

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

---

Guess??!! But BETWEEN is an operator...

I too was looking for the trick in the question.

First, it used DATE instead of DATETIME which gives you an error if you're using Server 2005. The...

Raghavendra Mudugal (2/29/2012)

---

It gives me this error on the 2nd block

Msg 8117, Level 16, State 1, Line 3

Operand data type char is invalid for multiply operator.

I guess E stands for...

capn.hector (2/23/2012)

---

That would work however there are userid's that repeat, so the...

I use virtual machines too. VMWare Fusion on my Mac is great.

Using snapshots is how I'll test new software. If I want to revert back to the way...

Can't this be accomplished by a simple query like this:

select

productID,

min(EventTime) as StartTime,

max(EventTime) as EndTime,

RoleName

From [YourTableNameHere]

Group by

ProductID,

RoleName

m mcdonald (2/22/2012)

---

Did a little research and ran across this previous QotD

http://www.sqlservercentral.com/questions/Model+Database/69457/

"With SQL Server 2005 or 2008. Wnen (sic) working with the Model database what can you NOT...