tilew-948340 (8/13/2012)

---

Amazing command that dateadd having datepart second, month, etc. Need to know what you are doing when you use it...

From the explanation, it says that:

If datepart is month...

An easy one! NULL means a value unknown or not defined yet, it may be equal to or may not be equal to 'Kannur'....Hence NULLS disappear from equality and inequality...

Koen Verbeeck (8/9/2012)

---

Good question. I took #3 and it was correct. I wonder what happens when you choose #1.

Nice...

Answer choice 1 and 3 are same....whats the difference???? :w00t:

Nice question, Got to learn something new 🙂

Nice question. For all those who use dynamic sqls and sometime stuck up in this scenario, here is the tip for you.

CREATE TABLE #A(COL1 INT)

INSERT INTO #A VALUES (1)

DECLARE @STR2...

Wonderful question!

Such questions build your concepts...and keep you think while you solve them.

Keep posting such questions 🙂

Simple but tricky question 🙂

Simplest of all the questions answered till now 🙂

Thanks for an easy one point.

Really glad to know that I was helpful to you 🙂

Feel free...

Made some changes in your code. Please check now.

DECLARE @year_start DATETIME

SELECT @year_start= '03-JAN-2011'

DECLARE @year_end DATETIME

SELECT @year_end= '31-DEC-2011'

;WITH Date_range

AS

(

SELECT @year_start Start_date, DATEADD(s,-1,@year_start+5) End_date

UNION ALL

...

Please post sample data. Will get back to you.

Took a second look. With the sample data, here is the result which I am getting. Is sClose correct? | ...

sClose should not be NULL. Not sure why this is happening. On my machine with this sample data. It is showing the correct value.

| SYMBOLID | SYMBOL...

Glad to know that was helpful. I am not...