Need help with query. I want the output to be display in single row. We have 2 rows for each ID for Address Type and I want the Home and Mailing address city display in single row.
create table #Test
(ID int,
HomeCity varchar(10),
AddrType varchar(10))
insert into #Test values (10,'Phoenix','Home')
insert into #Test values (10,'Boston','Mailing')
insert into #Test values (20,'Memphis','Home')
insert into #Test values (20,'Durham','Mailing')
insert into #Test values (30,'New York','Mailing')
SELECT * from #Test
EXPECTED Output: