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 ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PJ_Special_Order_T](
[SplOrd_Num] [numeric](18, 0) NULL,
[SplOrd_Date] [datetime] NULL,
[SplOrd_Notes] [varchar](200) NULL,
[Store_Number] [varchar](10) NULL,
[ItemNumber] [varchar](30) NULL,
[Variation] [varchar](50) NULL,
[ItemName] [varchar](50) NULL,
[Qty] [numeric](10, 0) NULL,
[Price] [varchar](20) NULL
) ON [PRIMARY]
GO
USE [BSJ_APPLN]
GO
/****** Object: Table [dbo].[PJ_Matrix_RowDstbn_T] Script Date: 27-05-2017 19:11:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PJ_Matrix_RowDstbn_T](
[Distbn_Date] [datetime] NOT NULL,
[ItemNumber] [varchar](30) NOT NULL,
[Variation] [varchar](50) NOT NULL,
[ItemPrice] [varchar](15) NULL,
[206] [varchar](15) NOT NULL,
[221] [varchar](15) NOT NULL,
[226] [varchar](15) NOT NULL,
[230] [varchar](15) NOT NULL,
[231] [varchar](15) NOT NULL,
[237] [varchar](15) NOT NULL,
[240] [varchar](15) NOT NULL,
[241] [varchar](15) NOT NULL,
[243] [varchar](15) NOT NULL,
[244] [varchar](15) NOT NULL,
[301] [varchar](15) NOT NULL,
[302] [varchar](15) NOT NULL,
[303] [varchar](15) NOT NULL,
[304] [varchar](15) NOT NULL,
[305] [varchar](15) NOT NULL,
[306] [varchar](15) NOT NULL,
[307] [varchar](15) NOT NULL,
[308] [varchar](15) NOT NULL,
[310] [varchar](15) NOT NULL,
[312] [varchar](15) NOT NULL,
[313] [varchar](15) NOT NULL,
[314] [varchar](15) NOT NULL,
[315] [varchar](15) NOT NULL,
[316] [varchar](15) NOT NULL,
[318] [varchar](15) NOT NULL,
[319] [varchar](15) NOT NULL,
[320] [varchar](15) NOT NULL,
[321] [varchar](15) NOT NULL,
[322] [varchar](15) NOT NULL,
[323] [varchar](15) NOT NULL,
[324] [varchar](15) NOT NULL,
[326] [varchar](15) NOT NULL,
[333] [varchar](15) NOT NULL,
[780] [varchar](15) NOT NULL,
[1062] [varchar](15) NOT NULL,
[1070] [varchar](15) NOT NULL,
[1093] [varchar](15) NOT NULL,
[1166] [varchar](15) NULL,
[785] [varchar](50) NULL,
[1174] [varchar](15) NULL,
[1176] [varchar](15) NULL,
[1177] [varchar](15) NULL,
[1195] [varchar](15) NULL,
[2000] [varchar](15) NULL,
[2001] [varchar](15) NULL,
[2002] [varchar](15) NULL,
[@Store_Number] [varchar](15) NULL,
[2003] [varchar](15) NULL,
[2004] [varchar](15) NULL,
[2005] [varchar](15) NULL,
[2006] [varchar](15) NULL
) ON [PRIMARY]
GO
USE [BSJ_APPLN]
GO
/****** Object: Table [dbo].[PJ_Location_M] Script Date: 27-05-2017 19:12:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PJ_Location_M](
[Store_Number] [varchar](10) NOT NULL,
[Location] [varchar](50) NULL,
[Address1] [varchar](50) NULL,
[Address2] [varchar](50) NULL,
[City] [varchar](50) NULL,
[State] [varchar](50) NULL,
[Zip] [varchar](15) NULL,
[Phone] [varchar](15) NULL,
[Fax] [varchar](15) NULL,
[DMM_Name] [varchar](50) NULL,
[Route_Name] [varchar](50) NULL,
[Load_Priority] [varchar](10) NULL,
[SiteId] [varchar](10) NULL,
CONSTRAINT [PK_PJ_Location_M] PRIMARY KEY CLUSTERED
(
[Store_Number] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [BSJ_APPLN]
GO
/****** Object: Table [dbo].[PJ_Item_M] Script Date: 27-05-2017 19:13:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PJ_Item_M](
[ItemNumber] [varchar](30) NOT NULL,
[Variation] [varchar](50) NOT NULL,
[ItemName] [varchar](50) NULL,
[QtyPerCase] [varchar](10) NULL,
[CasePerWagon] [varchar](10) NULL,
[QtyPerWagon] [varchar](15) NULL,
[CapacityValue] [varchar](15) NULL,
[SellingPrice] [varchar](15) NULL,
[Mon_Perc] [varchar](10) NULL,
[Tue_Perc] [varchar](10) NULL,
[Wed_Perc] [varchar](10) NULL,
[Thu_perc] [varchar](10) NULL,
[Fri_Perc] [varchar](10) NULL,
[Sat_Perc] [varchar](10) NULL,
[Sun_perc] [varchar](10) NULL,
[RetailPrice] [varchar](15) NULL,
[MatrixHide] [varchar](10) NULL
) ON [PRIMARY]
GO
USE [BSJ_APPLN]
GO
/****** Object: Table [dbo].[PJ_Daily_DbnMatrix_T] Script Date: 27-05-2017 19:14:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PJ_Daily_DbnMatrix_T](
[FrDate] [datetime] NULL,
[Store_Number] [varchar](10) NULL,
[ItemNumber] [varchar](30) NULL,
[Variation] [varchar](50) NULL,
[Tot_PlanToShip] [varchar](20) NULL,
[Actual_PlanToShip] [numeric](18, 0) NULL,
[Hot_Item] [varchar](10) NULL,
[ItemPrice] [varchar](15) NULL,
[Distbn_Date] [datetime] NULL
) ON [PRIMARY]
GO
USE [BSJ_APPLN]
GO
INSERT INTO [dbo].[PJ_Daily_DbnMatrix_T]
([FrDate]
,[Store_Number]
,[ItemNumber]
,[Variation]
,[Tot_PlanToShip]
,[Actual_PlanToShip]
,[Hot_Item]
,[ItemPrice]
,[Distbn_Date])
VALUES
('2016'
,'206'
,'C123'
,'Flowers'
,'20'
,'25'
,'C123'
,'2.5'
,'2016-02-03')
GO
USE [BSJ_APPLN]
GO
INSERT INTO [dbo].[PJ_Item_M]
([ItemNumber]
,[Variation]
,[ItemName]
,[QtyPerCase]
,[CasePerWagon]
,[QtyPerWagon]
,[CapacityValue]
,[SellingPrice]
,[Mon_Perc]
,[Tue_Perc]
,[Wed_Perc]
,[Thu_perc]
,[Fri_Perc]
,[Sat_Perc]
,[Sun_perc]
,[RetailPrice]
,[MatrixHide])
VALUES
(<ItemNumber, varchar(30),>
,<Variation, varchar(50),>
,<ItemName, varchar(50),>
,<QtyPerCase, varchar(10),>
,<CasePerWagon, varchar(10),>
,<QtyPerWagon, varchar(15),>
,<CapacityValue, varchar(15),>
,<SellingPrice, varchar(15),>
,<Mon_Perc, varchar(10),>
,<Tue_Perc, varchar(10),>
,<Wed_Perc, varchar(10),>
,<Thu_perc, varchar(10),>
,<Fri_Perc, varchar(10),>
,<Sat_Perc, varchar(10),>
,<Sun_perc, varchar(10),>
,<RetailPrice, varchar(15),>
,<MatrixHide, varchar(10),>)
GO
Please imagine any values. I have given the table scripts to create. The output pattern is on the image in my first post. Please help me