0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

CREATE TABLE #Donations100 (
    [ID] INT,
    [Product1] VARCHAR(32),
    [Quantity1] INT,
    [Product2] VARCHAR(32),
    [Quantity2] INT,
    [Product3] VARCHAR(32),
    [Quantity3] INT
);
    
INSERT INTO #donations100 ([ID], [Product1], [Quantity1], [Product2], [Quantity2], [Product3], [Quantity3])
VALUES
    (1,'Blankets',3,'Hand Towels',5,'Queen Bed Frames',2),
    (2,'Dressers',10,'Queen Mattreses',2,null,null),
    (3,'Welcome Mats',2,'Silverware',6,null,null);
    
select * from #Donations100

fork query

edited sep 18 anonymous

created jun 8 16 bluefeet