How to merge lines?

Question

How can I merge two or more **Linhas x Coluna** of the consultation below?

select cast(OS.CreateDate as date) as DtMovimentacao, OS.Id as NrOS, OS.Description Origem, OSI.Description as ItemSaida, OSI.Quantity as QtdSaida,
OSE.Description, OSE.Quantity, OSE.Notes
from Asset_WorkOrders OS
join Asset_WorkOrderOtherCost OSI
on OSI.WorkOrderId = OS.Id
join 
(
    select OS.WorkOrderId, OSI.Description,OSI.Quantity,OSI.Notes from Asset_WorkOrders OS
    join Asset_WorkOrderOtherCost OSI
    on OSI.WorkOrderId = OS.Id
    where TypeId = 56
)OSE
on OSE.WorkOrderId = OS.Id
where OS.Id = 147412
and OS.TypeId = 34

I needed the result to stay that way.

That in the query or through the Report Server.

Answer 1

EDIT: With SQL I think the only way is to check the information that is different between the lines and use the FOR XML PATH in that column, in the following example I used in the column "Description"

select cast(OS.CreateDate as date) AS DtMovimentacao, OS.Id AS NrOS,
Origem = (SELECT OS2.Description + CHAR(10)
FROM Asset_WorkOrders OS2
WHERE OS.Id = OS2.Id
  and OS.TypeId = OS2.TypeId
FOR XML PATH(''))
OS.Description as Origem,

OSI.Description as ItemSaida, OSI.Quantity as QtdSaida,
OSE.Description, OSE.Quantity, OSE.Notes
from Asset_WorkOrders OS
join Asset_WorkOrderOtherCost OSI
on OSI.WorkOrderId = OS.Id
join 
(
    select OS.WorkOrderId, OSI.Description,OSI.Quantity,OSI.Notes from Asset_WorkOrders OS
    join Asset_WorkOrderOtherCost OSI
    on OSI.WorkOrderId = OS.Id
    where TypeId = 56
)OSE
on OSE.WorkOrderId = OS.Id
where OS.Id = 147412
and OS.TypeId = 34

Since you have not included information from the tables, there may be some inconsistency in the result of the Origin column, in this case you have to include in the subquery some JOINs or validations in WHERE.