SQL Server 2022

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), 
('2023-01-11', 2199170000000), 
('2023-01-12', 2202989000000), 
('2023-01-13', 2179781000000), 
('2023-01-17', 2093328000000), 
('2023-01-18', 2131678000000), 
('2023-01-19', 2110145000000), 
('2023-01-20', 2090523000000), 
('2023-01-23', 2135499000000), 
('2023-01-24', 2048386000000), 
('2023-01-25', 2031561000000), 
('2023-01-26', 2024069000000), 
('2023-01-27', 2003634000000), 
('2023-01-30', 2048714000000), 
('2023-01-31', 2061572000000), 
('2023-02-01', 2038262000000), 
('2023-02-02', 2050063000000), 
('2023-02-03', 2041217000000), 
('2023-02-06', 2072261000000), 
('2023-02-07', 2057958000000), 
('2023-02-08', 2059604000000), 
('2023-02-09', 2058942000000), 
('2023-02-10', 2042893000000), 
('2023-02-13', 2107775000000), 
('2023-02-14', 2076548000000), 
('2023-02-15', 2011998000000), 
('2023-02-16', 2032457000000), 
('2023-02-17', 2059662000000), 
('2023-02-21', 2046064000000), 
('2023-02-22', 2113849000000), 
('2023-02-23', 2147417000000), 
('2023-02-24', 2142141000000), 
('2023-02-27', 2162435000000), 
('2023-02-28', 2188035000000), 
('2023-03-01', 2133950000000), 
('2023-03-02', 2192355000000), 
('2023-03-03', 2186150000000), 
('2023-03-06', 2190793000000), 
('2023-03-07', 2170195000000), 
('2023-03-08', 2193237000000), 
('2023-03-09', 2229623000000), 
('2023-03-10', 2188375000000), 
('2023-03-13', 2126677000000), 
('2023-03-14', 2042579000000), 
('2023-03-15', 2055823000000), 
('2023-03-16', 2066319000000), 
('2023-03-17', 2106166000000), 
('2023-03-20', 2098393000000), 
('2023-03-21', 2194631000000), 
('2023-03-22', 2279608000000), 
('2023-03-23', 2233956000000), 
('2023-03-24', 2218458000000), 
('2023-03-27', 2220131000000), 
('2023-03-28', 2231749000000), 
('2023-03-29', 2264862000000), 
('2023-03-30', 2271531000000), 
('2023-03-31', 2375171000000), 
('2023-04-03', 2221010000000), 
('2023-04-04', 2219375000000), 
('2023-04-05', 2243011000000), 
('2023-04-06', 2173663000000);

79 rows affected

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