Lynn Pettis (2/8/2013)

---

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

parminder.parmindersingh (2/8/2013)

---

I was shrinking a database, where its stuck and SSMS goes in not responding. I had wait till half an hour but no luck.

then i just went to the...

You may not be aware what a jumping jack is on this side of the pond....

Steve Jones - SSC Editor (2/7/2013)

---

Critical thinking, communication, analysis, these are the skills that you should learn, and learn to apply in different ways. That's important if the degree in...

Grant Fritchey (2/7/2013)

---

Now that's funny because I'd say exactly the opposite. Degrees really, really matter but MOST of them are probably useless (saying that with no degrees and still employed...

Yes. But some of the comments on it are disturbing.

Warning: this is somewhat off...

No, through being so fortunate as to have avoided having to learn about it I know far too little about...

That is a version with some problems (misplaced '[' and ']', misplaced 'with scheamabinding' clause, using [] on identifiers in drop but not on...

JohnPapa (2/6/2013)

---

Gail, there is no need to display it, I just need to know the value. In the recordset the RV value is not Null, nothing prints when you try...

It must be effectively quite a bit different, although it is similar: the older question only got 30 (under 2%) wrong answers to date....

chgn01 (2/5/2013)

---

Please try:

declare @k int;

select

case when @k=0 OR NOT (@k = 0)

then cast(0 as date)

else cast('2012-04-01T10:00:00' as datetime)

end...

Raghu has answered that one at least...

john.moreno (2/4/2013)

---

I got it right, but I wish the date wasn't April Fools day -- it adds a bit of "meta" distraction to the question.

Is it ha, ha fooled you...

I've got a long way to catch up with your...