Row to Col

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

CREATE table #table1
    (Campaign_ID varchar(50), SMS_TEXT_VAR_1 varchar(50),SMS_DATA_VAR_2 varchar(50))
;
    
INSERT INTO #table1
    (Campaign_ID,SMS_TEXT_VAR_1,SMS_DATA_VAR_2)
VALUES
('C0701002','Right now, you can...','B.handset_1_storage')
;

CREATE table #table2
    (Campaign_ID varchar(50), handset_1_storage varchar(50))
;
    
INSERT INTO #table2
    (Campaign_ID,handset_1_storage)
VALUES
('C0701002','64')
;




Select * FROM #table1 a JOIN #table2 b on a.Campaign_ID = b.Campaign_ID

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results