thank you this works.

hello is unique the skid the only difference is the non applicable word.

thanks so much for this help. is working now..save me !!!

thanks a lot!

thank you so much!!

This works super good:

SELECT CountryOfOrigin,

PartNumber,

SUM(Quantity) Qty,

'x' Sol,

'x' LoadPlanId,

'x' SalesOrder,

'x' PalletNumber

FROM #tempCOO

GROUP BY CountryOfOrigin, PartNumber

ORDER BY CountryOfOrigin, PartNumber

thanks a lot!!!!

yes this logic

thank you so much

SELECT parent.*

,NewCol = CASE WHEN oa.Cnt > 0 THEN 'Mixed' ELSE 'Real' END

FROM @PalletContent parent

OUTER APPLY (SELECT TOP 1 Cnt = 1 FROM @PalletContent child...

it worked thank you!

Thanks so much. this logic also works. Ill appreciate it thank you!

Thanks so much Ill try tomorrow  and I will let you know the results!! thanks so much again!

I also follow your advice changing the format of the date in the variable instead of on where. Query performance is better now! Thank you thank you!

Hello Thank you so much for this. I changed already the code with the changes you gave me and query is much much faster now..thank you so much

Does SKA have an index on StockKeepingId and AttributeNumber ? yes Index for this table is StockKeepingId

Does RMD have an index on RmaDocumentId and RmaDocumentAttributeId ? also Index for this table...