Missed the "Distinct" 😛

Nice question and Great comments..

Easy.. Thanks

Tricky.. 🙂 lost my points

Got some energy for Monday 🙂

+1 🙂

ChrisM@Work (7/21/2014)

---

Yes, which makes tempdb useful...

Thanks.. But still confused:-P.. need to work on it..

Good Question. Thanks for the easy point.

L' Eomot Inversé (10/9/2013)

---

Nice question.

I've never understood why try...catch was banned in functions, but the explanation for this question provides a clue. I'd...

+3 🙂

tom.w.brannon (10/2/2013)

---

I believe the problem is a difference in how distinct gets used in different contexts. For the following queries

select count(distinct id) from #temp_test;

select distinct id from #temp_test;

select count(*)...

Nice and simple question. Lot to think.. thanks Samith..

Carlo Romagnano (9/25/2013)

---

Dscheypie (9/25/2013)

---

Carlos,

sure, you may be right.

And the topic of this QotD is CTE and the usage of DML.

With the example for identifying duplicate records I wouldn't agree...

How about Recursive CTE? Here is a simple example. Try this too..

DECLARE @FromDate DATE = '01 APR 13'

DECLARE @ToDate DATE = '31 MAR 14'

; WITH CTE

AS

(

SELECT @FromDate Dates

UNION ALL...

create table #temp_test

(id int);

insert into #temp_test

values(1)

insert into #temp_test

values(1)

insert into #temp_test

values(2)

insert into #temp_test

values(2)

insert into #temp_test

values(3)

insert into #temp_test

values(5)

;

with ABC_CTE as

(

select ROW_NUMBER() OVER(PARTITION BY ID...