Also asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99743

Try this

SELECTd.Name

FROM(

SELECTf1.Name,

MIN(f1.Region) AS minRegion,

MAX(f1.Region) AS maxRegion,

SUM(CASE WHEN f2.Name IS NULL THEN 1 ELSE 0 END) AS Nulls,

COUNT(*) AS Items

FROM@Fruit AS f1

LEFT JOIN@Fruit AS f2 ON f2.Name = f1.Name

AND f2.Sequence =...

If I change this line

select 3, 'nut', 1, 'hard to crack' union all

to

select 3, 'nut', 2, 'hard to crack' union all

it fails too...

Also asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99666

Try thisSELECTf1.Name

FROM@Fruit AS f1

LEFT JOIN@Fruit AS f2 ON f2.Name = f1.Name

AND f2.Sequence = f1.Sequence

AND f2.Description = f1.Description

AND f2.Region <> f1.Region

GROUP BYf1.Name

HAVINGSUM(CASE WHEN f2.Name IS NULL THEN 1 ELSE 0 END)...

Already asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99544

SELECTCategoryID,

Category,

CASE

WHEN Category LIKE 'Fema%Jewel%OB' THEN 'Female Accessories Own Brand'

WHEN Category LIKE 'Fema%Jewel%Brand%' THEN 'Female Accessories Outside Brand'

WHEN Category LIKE 'Fema%Und%wear%Brand%' THEN 'Womenswear Outside Brand'

WHEN Category LIKE 'Male%Accs%OB' THEN 'Male Accessories...

If only digits are allowed, try this

SELECT*

FROMTable1

WHERECol1 NOT LIKE '%[^0-9]%'

Sarvesh Kumar Gupta (3/14/2008)

---

Ok if u r right then give me a query by using group by clause for removing duplicate values from a table. and without using a aggregate...

Other than this?DELETEf

FROM(

SELECTROW_NUMBER() OVER (PARTITION BY Col1 ORDER BY Col2 DESC) AS RecID

FROMTable1

) AS f

WHEREf.RecID > 1

Well, Sarvesh is not entirely correct.

You can use GROUP BY to sort out duplicate values. In most cases GROUP BY is more efficient than DISTINCT to do that because GROUP...

First tell me which part of Books Online about DISTINCT and GROUP BY you didn't understand, and I can maybe tell you some more.

SELECT

SUM(CASE WHEN ve < 0 THEN ve ELSE 0 END) AS Negative,

SUM(CASE WHEN ve > 0 THEN ve ELSE 0 END) AS Positive

FROM Table1

Thank you!

It's nice to see someone recognize the simpicity of the algorithm structure.

You are absolutely correct about the quick start, to only change the insert thingy with SELECT .. GROUP...

What?

He asked for cars here...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98384