L' Eomot Inversé (5/30/2013)

---

That's a fun question.

But maybe there will be complaints from some who think QotD should test only knowledge and not reasoning (except perhaps very trivial...

If Hugo doesn't get it, I don't feel bad...

Sean Lange (4/30/2013)

---

I don't think I follow you here Tom. The condition checks is @ToCreate = 1. It does not equal 1 because it is NULL. Therefore the boolean check...

And if @ToCreate is set to 1, SQL...

ScottPletcher (4/26/2013)

---

I'd use a CASE expression so you can guarantee the order of execution; you don't need a CTE for that.

SELECT OBSVALUE

FROM OBS

WHERE 1 = CASE

...

Eric Nordlander (4/26/2013)

---

1. what are the min and max values in the table? (the ranges for the data types is why it could be a concern--> http://msdn.microsoft.com/en-us/library/ms187347.aspx)

2. try assigning...

It's a datetime. And of course this gives no errors...

SELECT OBSVALUE

FROM temperic_OBSVals

WHERE...

This is what I get for trusting that voice in my head that says, "No, that's way too obvious." :crazy:

ron

Today's a bad day to ask this question. The guy in the next cubicle over has spent the last four months spearheading our biggest upgrade project of the year....

It would have been interesting to include exactly which value(s) would be inserted. If you weren't aware that the identity would be consumed, you might believe that the value...

You have no idea how many times in the six months I've been at this job that I've wished for a script like this. Thank you so much!

ron

happycat59 (3/5/2013)

---

Mmm, why have "ISNUMERIC" as the heading for this question ? This question is not really about the ISNUMERIC function. How about getting the heading to match...

Good question.

I might have changed up the options a bit, though. Once you realize the first two are true (and those are easy), then by the nature of the...

Where I got tripped up was here, and I guess I'm still not sure I understand...

create proc sp1

as

select * from temp1

exec sp2

Without a BEGIN and END defining the body of...

Having used a single-row table for just such a...