Home / Questions / 201989
Accepted
Ricardo Soria
Asked: 2020-10-05 08:48:03 +0800 CST 2020-10-05 08:48:03 +0800 CST

How to join multiple records into one using SQL SERVER?

  • 772

I need this table:

enter image description here

Becomes this: (edit it as an image using paint to show as an example)

enter image description here

The data will always have the same 'serverName', DATE and TIME in common

sql

1 Answers

  1. Best Answer

    What you need to do is group by certain columns. In this case, for serverName, Dateand Time, for example, this query would return a result like what you expect:

    with
Datos as (
select 16 idse, 'LSTKAG72544' serverName, cast('20180928' as date) [DATE], CAST('17:09:59' as time) [TIME], null SQLBrowser, 'Running' W3SVC, null wscsvc
union all
select 17 idse, 'LSTKAG72544' serverName, cast('20180928' as date) [date], CAST('17:09:59' as time) [time], null SQLBrowser, null W3SVC, 'Running' wscsvc
union all
select 18 idse, 'LSTKAG72544' serverName, cast('20180928' as date) [date], CAST('17:09:59' as time) [time], 'Running' SQLBrowser, null W3SVC, null wscsvc
)
select   min(idse) idse
       , serverName
       , [DATE]
       , [TIME]
       , min(SQLBrowser) SQLBrowser
       , min(W3SVC) W3SVC
       , MIN(wscsvc) wscsvc
  from Datos
 group by serverName, [DATE], [TIME];
    • 2