0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for participants in team and individual sport activities

CREATE table #yourtable
    ([Id] int, 
    [id_karty] varchar(6),
    [data] varchar(30), 
    [mcc] varchar(13),
    [kwota_wkon] int)
;
    
INSERT INTO #yourtable
    ([Id], [id_karty], [data], [mcc], [kwota_wkon])
VALUES
    (1, '10', '01-01-2019', '5001', 10),
    (2, '11', '01-01-2019', '5001', 20),
    (3, '10', '01-01-2019', '5001', 15),
    (4, '12', '01-01-2019', '5002', 10),
    (5, '11', '01-01-2019', '5002', 10),
    (6, '11', '01-01-2019', '5003', 10),
    (7, '11', '01-01-2019', '5005', 10)
;



  select id_karty, data, mcc, kwota_wkon
  from #yourtable

view current version

edited jul 3 20

created jul 3 20 anonymous