Since there's been nothing posted to guide anyone's further efforts, here's my guess:SELECT d.*, ROW_NUMBER() OVER(PARTITION BY d.Empid ORDER BY d.phonetype DESC) AS RowNum
FROM (
        VALUES    (1999993, 'CELL', '494757587838'),
                (1999993,...

We'd need a LOT more detail.   One question I'll ask because you mentioned cxpacket is whether you have any linked servers involved in your queries?   That can be problematic if...

I can't imagine any DBA allowing an app to stop relying on stored procedures.   If the stored procedures aren't performing well, that can be addressed, as it's not the nature...

How many DBA's does it take to change a light bulb?

One to tell the developers to do it, and a half dozen BAs to figure out which light...

If a DBA pulls a trigger, did he just commit suicide?

Two programmers walk into a bar.... the third one ducks...