Transpose rows to column

[sks198117]

Can anyone help me to transpose below result

SVR dates count
SRV1 03/25/2018 1
SRV1 04/06/2018 59
SRV1 04/07/2018 9
SRV1 04/13/2018 1
SRV1 04/15/2018 1
SRV1 04/20/2018 4
SRV1 04/21/2018 2
SRV1 04/27/2018 5
SRV1 04/28/2018 5
SRV1 04/29/2018 1
SRV1 04/30/2018 62

Date can be variable and the range of dates are 1 month ( Getdate and getdate -30)

I want the output in below format

Server 04/01/2018 04/02/2018 04/03/2018 ....... 04/30/2018
SRV1 10 0 2 5 1

[yosiasz]

please provide the data you gave us with real DML and DDL?

crate table #transpose(SVR varchar(1), dates dat, count int)
insert into #transpose
select your data to insert here.
you will get a quicker response

[jotorre_riversidedpss.org]

DECLARE @t table(Svr varchar(10), Dt date, Cnt smallint);
INSERT @t ( Svr, Dt, Cnt )
VALUES
   ( 'SRV1', '20180325', 1 )
 , ( 'SRV1', '20180406', 59)
 , ( 'SRV1', '20180407', 9 )
 , ( 'SRV1', '20180413', 1 )
 , ( 'SRV1', '20180415', 1 )
 , ( 'SRV1', '20180420', 4 )
 , ( 'SRV1', '20180421', 2 )
 , ( 'SRV1', '20180427', 5 )
 , ( 'SRV1', '20180428', 5 )
 , ( 'SRV1', '20180429', 1 )
 , ( 'SRV1', '20180430', 62);
SELECT
    Svr
  , [2018-03-25]
  , [2018-04-06]
  , [2018-04-07]
  , [2018-04-13]
  , [2018-04-15]
  , [2018-04-20]
  , [2018-04-21]
  , [2018-04-27]
  , [2018-04-28]
  , [2018-04-29]
  , [2018-04-30]
FROM @t t
PIVOT 
   ( Sum(Cnt) FOR Dt IN ( [2018-03-25], [2018-04-06], [2018-04-07], [2018-04-13], [2018-04-15], [2018-04-20], [2018-04-21], [2018-04-27], [2018-04-28], [2018-04-29], [2018-04-30] )
   ) P;