*check this brings results but can not find how to group them by WhsName*/

DECLARE @DATE AS DATETIME;

SET @DATE = GETDATE ();

select P.ItemName, P.ItemCode,P.WhsName,

[100] Sh,

[101] TI,

[102] Bod,

[103]...