sdf

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stellar Meta

Q&A about the site for developers and users of Stellar and the Stellar Distributed Exchange

CREATE TABLE #Table1
    ([FORECAST_YEAR] int, [FORECAST_MONTH] int, [QUARTER] int, [ITEM_MASTER_SID] int, [COMPANY_MASTER_SID] int, [UNITS] int)
;

INSERT INTO #Table1
    ([FORECAST_YEAR], [FORECAST_MONTH], [QUARTER], [ITEM_MASTER_SID], [COMPANY_MASTER_SID], [UNITS])
VALUES
    (2016, 1, 1, 18, 172496, 10000),
    (2016, 2, 1, 18, 172496, 11000),
    (2016, 3, 1, 18, 172496, 12000),
    (2016, 4, 2, 18, 172496, 13000),
    (2016, 5, 2, 18, 172496, 14000),
    (2016, 6, 2, 18, 172496, 15000),
    (2016, 7, 3, 18, 172496, 16000),
    (2016, 8, 3, 18, 172496, 17000),
    (2016, 9, 3, 18, 172496, 18000),
    (2016, 10, 4, 18, 172496, 19000),
    (2016, 11, 4, 18, 172496, 20000),
    (2016, 12, 4, 18, 172496, 21000)

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results