Nice going both of you...

Hi Eirikur Eiriksson,
Can you please help me with the query. I need to work on it and publish soon.

Thanks,

Thanks for the reply. Expected input will be
Please find the tables:

USE [BSJ_APPLN]
GO
/****** Object: Table [dbo].[PJ_Special_Order_T]  Script Date: 27-05-2017 19:07:46 ******/
SET ANSI_NULLS...

Sorry Louis C,
My requirement changed a bit. Please help me if you can for the below query:

select RST.Store_Number, PLM.Location, RST.WkEnd_Date, RST.ItemNumber, SUM(RST.Qty) as Qty, PIM.SellingPrice,...

Hi,
Thank you Matt and Luis,

Sorry for not being clear. I need to create new columns in order to show the calculated output. Below image is my output format. 

The @StoreNumber actually is a set of column names in a table. To test the query, I need to pass:

exec OverallItemReport_Select 'sum(cast([1062] as int)) + sum(cast([1070]...

Employee    superior
Sam            Andrew
Nehal          Sam
AAA            Sam
BBB           Sam