T-SQL select into temp table does not have correct result

Question

-- This Result Is Right and work correctly:

SELECT AutoId, Name,[Group],[Priority], SUMCalculatedPercent
FROM
(SELECT DISTINCT *,
 ROW_NUMBER() OVER 
 (
    PARTITION BY [Group] ORDER BY SUMCalculatedPercent DESC,[Priority]
 ) 
 AS ranker 
 FROM #GroupMasterNameChoose
)Z
WHERE ranker = 1
ORDER BY Z.SUMCalculatedPercent DESC,Z.[Priority]

-- This Result Is Wrong :

SELECT AutoId, Name,[Group],[Priority], SUMCalculatedPercent
INTO #GroupOwner
FROM
(SELECT DISTINCT *,
 ROW_NUMBER() OVER 
 (
    PARTITION BY [Group] ORDER BY SUMCalculatedPercent DESC,[Priority]
 ) 
 AS ranker 
 FROM #GroupMasterNameChoose
)Z
WHERE ranker = 1
ORDER BY Z.SUMCalculatedPercent DESC,Z.[Priority]

-- Problem : I Need Store My Right Result To Temp Table

I don't think the `ORDER BY` clause in the second query has any meaning or purpose. — Tim Biegeleisen, Feb 15 '17 at 07:12

score 0 · Accepted Answer · answered Feb 15 '17 at 07:21

0

Remove ORDER BY Z.SUMCalculatedPercent DESC,Z.[Priority]

answered Feb 15 '17 at 07:21

Singh Kailash

545
4
16

T-SQL select into temp table does not have correct result

1 Answers1