SQL Server - Pivot

hi,

I think this is not possible with Pivot Query because Pivot Query must have some aggregate function.
so you have think differently to resolve the issue.

i have tried some code and share here

--drop table #test
Create table #test
(
Id int,
Name varchar(20)
)

Insert into #test values(1,'1M')
Insert into #test values(2,'1M')
Insert into #test values(3,'1M')
Insert into #test values(4,'1M')
Insert into #test values(5,'1M')
Insert into #test values(6,'1M')
Insert into #test values(7,'1M')
Insert into #test values(8,'1M')
Insert into #test values(9,'1M')
Insert into #test values(10,'1M')

declare @max int
declare @id int = 1
declare @pkid int = 1
select @max = MAX(id)  from #test

declare @d1 table
(
    DatabaseID    int,
    PId        int,
    Name varchar(10)
)
declare @d2 table
(
    DatabaseID    int,
    PId        int
)
declare @d3 table
(
    DatabaseID    int,
    PId        int
)

While @id <= @max
begin
 if(@id <= @max)
  insert into @d1 values(@pkid,@id, '1M')
 set @id+=1
 if(@id <= @max)
  insert into @d2 values(@pkid,@id)
 set @id+=1
 if(@id <= @max)
  insert into @d3 values(@pkid,@id)
 set @id+=1
 set @pkid +=1
end

select d1.Name,d1.PId,d2.PId,d3.PId from @d1 d1
LEFT Outer join @d2 d2 on d1.DatabaseID = d2.DatabaseID
LEFT Outer join @d3 d3 on d1.DatabaseID = d3.DatabaseID

hope this will help you.