add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='WSHOSHO')
CREATE TABLE WSHOSHO (
DATE varchar(255),
WSHOSHO decimal
)

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='RRP')
CREATE TABLE RRP (
DATE varchar(255),
RRP decimal
)

INSERT INTO WSHOSHO
VALUES
('2023-01-11', 8100175.0),
('2023-01-18', 8079010.0),
('2023-01-25', 8062665.0),
('2023-02-01', 8024470.0),
('2023-02-08', 8024104.0),
('2023-02-15', 7990467.0),
('2023-02-22', 7986887.0),
('2023-03-01', 7948534.0),
('2023-03-08', 7948335.0),
('2023-03-15', 7940014.0),
('2023-03-22', 7936558.0),
('2023-03-29', 7926131.0),
('2023-04-05', 7877114.0);

INSERT INTO RRP
VALUES
('2023-01-03', 2188272000000),
('2023-01-04', 2229542000000),
('2023-01-05', 2242486000000),
('2023-01-06', 2208265000000),
('2023-01-09', 2199121000000),
('2023-01-10', 2192942000000), 
79 rows affected
SELECT
R.[DATE],
WSHOSHO =
LAST_VALUE(W.WSHOSHO) IGNORE NULLS OVER (
ORDER BY R.[DATE] ASC
ROWS UNBOUNDED PRECEDING),
R.RRP
FROM WSHOSHO AS W
RIGHT JOIN RRP AS R
ON (R.[DATE] = W.[DATE])
ORDER BY
R.[DATE] ASC;
DATE WSHOSHO RRP
2023-01-03 null 2188272000000
2023-01-04 null 2229542000000
2023-01-05 null 2242486000000
2023-01-06 null 2208265000000
2023-01-09 null 2199121000000
2023-01-10 null 2192942000000
2023-01-11 8100175 2199170000000
2023-01-12 8100175 2202989000000
2023-01-13 8100175 2179781000000
2023-01-17 8100175 2093328000000
2023-01-18 8079010 2131678000000
2023-01-19 8079010 2110145000000
2023-01-20 8079010 2090523000000
2023-01-23 8079010 2135499000000
2023-01-24 8079010 2048386000000
2023-01-25 8062665 2031561000000
2023-01-26 8062665 2024069000000
2023-01-27 8062665 2003634000000
2023-01-30 8062665 2048714000000
2023-01-31 8062665 2061572000000
2023-02-01 8024470 2038262000000
2023-02-02 8024470 2050063000000
2023-02-03 8024470 2041217000000
2023-02-06 8024470 2072261000000
2023-02-07 8024470 2057958000000
2023-02-08 8024104 2059604000000
2023-02-09 8024104 2058942000000
2023-02-10 8024104 2042893000000
2023-02-13 8024104 2107775000000
2023-02-14 8024104 2076548000000
2023-02-15 7990467 2011998000000
2023-02-16 7990467 2032457000000
2023-02-17 7990467 2059662000000
2023-02-21 7990467 2046064000000
2023-02-22 7986887 2113849000000
2023-02-23 7986887 2147417000000
2023-02-24 7986887 2142141000000
2023-02-27 7986887 2162435000000
2023-02-28 7986887 2188035000000
2023-03-01 7948534 2133950000000
2023-03-02 7948534 2192355000000
2023-03-03 7948534 2186150000000
2023-03-06 7948534 2190793000000
2023-03-07 7948534 2170195000000
2023-03-08 7948335 2193237000000
2023-03-09 7948335 2229623000000
2023-03-10 7948335 2188375000000
2023-03-13 7948335 2126677000000
2023-03-14 7948335 2042579000000
2023-03-15 7940014 2055823000000
2023-03-16 7940014 2066319000000
2023-03-17 7940014 2106166000000
2023-03-20 7940014 2098393000000
2023-03-21 7940014 2194631000000
2023-03-22 7936558 2279608000000
2023-03-23 7936558 2233956000000
2023-03-24 7936558 2218458000000
2023-03-27 7936558 2220131000000
2023-03-28 7936558 2231749000000
2023-03-29 7926131 2264862000000
2023-03-30 7926131 2271531000000
2023-03-31 7926131 2375171000000
2023-04-03 7926131 2221010000000
2023-04-04 7926131 2219375000000
2023-04-05 7877114 2243011000000
2023-04-06 7877114 2173663000000