Excellent question / information. Really glad to know this

Thank you all for the nice explanations

Interesting.

thanks for the question

I have checked the rows in sys.syscacheobjects before/after running the selects, found 5 new rows with all the selects mentioned in QOD.

select * from sys.syscacheobjects where objtype ='adhoc' and sql...

Try the below solution

-- HRS VAST

INSERT INTO @T (JAAR, WEEK, HrsVast)

(

SELECTDBO.ISOyear(Begindatum) Jaar, datepart(ISO_WEEK,Begindatum) [Week], sum(DUUR/60.0) HrsVast

FROM DRPDATA D

JOIN HuisAfdeling H

OND.LocatieCode = H.IDHuis

AND D.AfdelingZPT = H.IDAfd

WHERE LocatieCode...

+1

Though I use the row_number() to remove the duplicates, I got it wrong.. 🙁

Thanks for the question

Hugo Kornelis (2/1/2015)

---

To all the people who responded that they are happy to have learned the SOME operator ... please unlearn it, as soon as possilble.

Every expression with SOME (and...

Hugo Kornelis (1/23/2015)

---

pmadhavapeddi22 (1/23/2015)

---

I know that select count(distinct *) does not work, but i am still not clear on one point,

The statement could have given the result like (count...

Bob Cullen-434885 (1/23/2015)

---

Hmm. Not sure about this. I tried select distinct * from mytable, and it returned all the rows, which was correct. So you can use * with distinct,...

I have recently used the count of distinct values. So I was confident to answer.

Thanks for the question steve

I have tried creating tables with all the mentioned datatypes and got the correct answer.

eg.,

create table tab1

(

col_1 numeric(12,2) identity

)

and got the below error for numeric or decimal datatypes with scale...

Good one.. 🙂

Thank you carlo,for all...

thanks for the interesting question

Hugo Kornelis (1/7/2015)

---

Got the answer by deduction and removing the obvious wrongs ones, but I do not like the question.

COUNT, as any other aggregate, ignores NULL values.

COUNT(*) is special. The...

Raghavendra Mudugal (1/1/2015)

---

Thank you, Steve, for the post, very new one to me.

(luckily, this article from the home page http://www.sqlservercentral.com/articles/Power+View/119430/ helped me to understand the PV. New year as began...