Here's another way

WITH cteDupeName AS (

SELECT RowNum, Name, SomeValue,

COUNT(*) OVER(PARTITION BY Name) AS cn

FROM #TestData)

SELECT RowNum, Name, SomeValue

FROM cteDupeName

WHERE cn>1

ORDER BY RowNum;

Thanks for the feedback!

Try this

SELECT ...

FROM ...

ORDER BY MAX(QNTY) OVER(PARTITION BY PartGroup) DESC, QNTY DESC

I think this gives you what you want, but I don't fully understand the requirements

SELECT n.Numbers,

COALESCE(STUFF((SELECT ','+p.Name AS "text()"

...

You can also replace the multiple 'OR's with an 'IN'

SELECT STK_STOCK_2.STKCODE2 AS [Stock Code], STK_STOCK_2.STK_SANALYSIS1 AS [Price Line 1], STK_STOCK_2.STK_SANALYSIS2 AS [Price Line 2],

...

WITH CTE AS (

SELECT [CustNo], [ContractNo], [RNo], [DateFrom], [Discount],

ROW_NUMBER() OVER(PARTITION BY [CustNo], [ContractNo], [RNo] ORDER BY [DateFrom] DESC) AS rn

...

This should do it

SELECT a.MapID,

a.SeriesID,

STUFF((SELECT ','+CAST(b.Year AS VARCHAR(10)) AS "text()"

...

Here's another guess

SELECT JOB.EMPLID,

JOB.FILE_NBR,

PER.NAME,

JOB.PAYGROUP,

...

Try this

UPDATE t1

SET multi_flag='Y'

FROM MyTable t1

WHERE EXISTS (SELECT * FROM MyTable t2

WHERE t2.exe_name=t1.exe_name

...

Untested, you may have issues with NULLs in your data

select t1.ID, t1.Tel1, t1.Tel2, t1.Tel3, t1.Tel4

from table1 t1

where exists (select * from table1 t2

...

Triggers can cause this

Presumably this?

select ID, name,

dense_rank() over (order by id asc) as Numbering,

count(*) over...

Sounds like a homework assignment, can you post what you have tried so far. Also what happens if a customer has two store locations with the same highest charges?

I've had to guess at what is a value 'Father' node, but gives the correct results with your data

declare @t table(Father int, Item int)

insert into @t(Father,Item)

select 49588, 71246 union all

select...

Untested...

WITH CTE AS (

SELECT A,B,C,V,

ROW_NUMBER() OVER(PARTITION BY A ORDER BY B,C DESC) AS rn

FROM ViewA)

SELECT A,C,V

FROM CTE

WHERE rn=1