By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test
(
JobNumber int
,JobNAme varchar(25)
,DesignStatus varchar(25)
,ShopStatus varchar(25)
,Title varchar(25)
,Note varchar(50)
,Remove varchar(25)
)
;
INSERT INTO test(JobNumber,JobNAme,DesignStatus,ShopStatus,Title,Note,Remove)
VALUES
(1234,'TestName','Correct','Inc','Title1','Note test design','Remove')
,(1234,'TestName','Correct','Inc','Title2','Note test proyect','Remove')
;
SELECT STRING_AGG(CONCAT(Title, ': ', Note, ' \n'),', ') from test
| (No column name) |
|---|
| Title1: Note test design \n, Title2: Note test proyect \n |