Hi Jeff,

You said that adding 'partition by' will reduce it only to one case statement, Not able to translate that into a query, can you please help?

Regards - Yasub

Hi Jeff,

Thanks for your reply. Sorry about the code, its a copy paste error, when i was trying to make the dummy code for this post, please ignore that functional...

Hi,

Here is the code in the sp which takes a lot of time, around 17 secs, the reads are only 1303,

SELECT

col1, col2, col3....,

(CASE @LocDBSortOrder

WHEN 'DESC' THEN

CASE @LocstrSortExpression ...

Hi,

Thanks for your reply, there was sniffing, had no choice but to disable it within the sproc.

Was working on another perf issue, the reads are down but the duration is...