My Table code as follows,
<code>CREATE TABLE SalesData (
ID INT,
ProductName VARCHAR(50),
Year INT,
SalesAmount DECIMAL(10, 2)
);
INSERT INTO SalesData (ID, ProductName, Year, SalesAmount)
VALUES
(1, 'ProductA', 2021, 150.00),
(2, 'ProductB', 2022, 200.00),
(3, 'ProductA', 2022, 300.00),
(4, 'ProductB', 2021, 400.00);
</code>
<code>CREATE TABLE SalesData (
ID INT,
ProductName VARCHAR(50),
Year INT,
SalesAmount DECIMAL(10, 2)
);
INSERT INTO SalesData (ID, ProductName, Year, SalesAmount)
VALUES
(1, 'ProductA', 2021, 150.00),
(2, 'ProductB', 2022, 200.00),
(3, 'ProductA', 2022, 300.00),
(4, 'ProductB', 2021, 400.00);
</code>
CREATE TABLE SalesData (
ID INT,
ProductName VARCHAR(50),
Year INT,
SalesAmount DECIMAL(10, 2)
);
INSERT INTO SalesData (ID, ProductName, Year, SalesAmount)
VALUES
(1, 'ProductA', 2021, 150.00),
(2, 'ProductB', 2022, 200.00),
(3, 'ProductA', 2022, 300.00),
(4, 'ProductB', 2021, 400.00);
and my expected result is
Should I use pivot to achieve this and do we have any other method like cross apply ?