Code for Result in single row from multiple row table

DECLARE
@SQLExec varchar(MAX) SET @SQLExec = NULL SELECT @SQLExec = COALESCE (@SQLeXEC + ''', DISK = ', '') + '''' + BackupFileName FROM PublishDetails WITH (NOLOCK) WHERE databasename = 'DWStage' Print @SQLExec