Stacie
asked on
Store procedure explanation
Could someone tell me what does this do?
-- GET JT NUMBER AND SALES ORDER STATUS
UPDATE #ForecastSolution
SET JTNumber = SDURAB
,OrderStatus = SDNXTR
FROM F42119
WHERE OrderNum = SDDOCO
AND SDURCD = 'JT'
AND SDURAB <> 0
-- GET JT NUMBER AND SALES ORDER STATUS
UPDATE #ForecastSolution
SET JTNumber = SDURAB
,OrderStatus = SDNXTR
FROM F42119
WHERE OrderNum = SDDOCO
AND SDURCD = 'JT'
AND SDURAB <> 0
ALTER PROCEDURE [dbo].[Acct_ForecastSolutionEvaluation]
AS
BEGIN
SET NOCOUNT ON;
--SET STATISTICS IO ON;
--SET STATISTICS TIME ON;
IF OBJECT_ID('TEMPDB..#ForecastSolution') IS NOT NULL
BEGIN
DROP TABLE #ForecastSolution;
END
CREATE TABLE #ForecastSolution
(
OrderNum INT
,OrderType VARCHAR(2)
,SoldTo VARCHAR(8)
,CustomerName VARCHAR(40)
,BusinessUnit VARCHAR(12)
,ShortItem INT
,LongItem VARCHAR(25)
,OrderStatus VARCHAR(3)
,JTNumber INT
,PubTypeCode VARCHAR(4)
,ProdPubType VARCHAR(1975)
,ConfigType VARCHAR(8)
,Description2 VARCHAR(1975)
,Brand VARCHAR(1975)
,[PageCount] VARCHAR(1975)
,Qty VARCHAR(1975)
,ShippedQTY DECIMAL(11,2)
,RevenueJT VARCHAR(1975)
,ExtendedAmt DECIMAL(11,2)
);
INSERT INTO #ForecastSolution(OrderNum,OrderType,SoldTo,CustomerName,BusinessUnit,ShortItem,ShippedQTY,Description2,ExtendedAmt,PubTypeCode)
SELECT
OrderNum
,OrderType
,AddressNum
,cName
,BusinessUnit
,ShortItemNum
,QuantityShipped
,DescriptionLine2
,ExtendedPrice
,ProdPubType
FROM dbo.Acct_SalesStatementRD
WHERE GL_Date >= '20140101'
-- ADD OPEN ORDER
-- FROM F4211
-- GET JT NUMBER AND SALES ORDER STATUS
UPDATE #ForecastSolution
SET JTNumber = SDURAB
,OrderStatus = SDNXTR
FROM F42119
WHERE OrderNum = SDDOCO
AND SDURCD = 'JT'
AND SDURAB <> 0
-- GET JT NUMBER AND SALES ORDER STATUS
UPDATE #ForecastSolution
SET JTNumber = SDURAB
,OrderStatus = SDNXTR
FROM F4211
WHERE OrderNum = SDDOCO
AND SDURCD = 'JT'
AND SDURAB <> 0
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.