Thank you @sergiy, @jeff Moden, @Jeffrey Williams, @scott Pletcher..You all provided some great suggestions and enhanced my knowledge.

I will try your suggestions and post...

• This reply was modified 4 years, 1 month ago by  hello.priyanka.

Hi Scott,

I tried creating an index on (WarehouseID, ProductID) INCLUDE(Qty). It still does the same.

On Dev database, for this query:

;With P As 
(Select CP.ProductID
From CatProduct CP
Join Product...

Thanks for your reply.

I tried that, but it still gives same result.

Attaching screenshots

The link for Json on W3schools.com is not working. Here is the updated link : https://www.w3schools.com/js/js_json_intro.asp