declare @columnList nvarchar(max) = '';
declare @columnListOut nvarchar(max) = '';
declare @columnListBp nvarchar(max) = '';
declare @columnListBpOut nvarchar(max) = '';

with cte as
(
select '1.1.1' as QID union all
select '1.1.10' union all
select '5.5.21' union all
select '1.1.9' union all
select '1.1.2' union all
select '1.1.8'
  
)

--select * from cte;
select top 10000 
      @columnList = 
       @columnList +
       case 
        when @columnList = ''
        then ''
        else ',
        '
       end +  'max(case r.QID when ''' + c.QID + ''' then r.answer end) as "QID_' + c.QID + '"',
       
       @columnListOut = 
       @columnListOut +
       case 
        when @columnListOut = ''
        then ''
        else ',
        '
       end +  'c."QID_' + c.QID + '"',
       
       @columnListBp =  
       @columnListBp +
       case 
        when @columnList = '' --it is correct
        then ''
        else ',
        '
       end +  'max(case r.QID when ''' + c.QID + ''' then r.BP_ID end) as "BP_' + c.QID + '"',
       
       @columnListBpOut =  
       @columnListBpOut +
       case 
        when @columnList = ''  --it is correct
        then ''
        else ',
       '
       end +  'c."BP_' + c.QID + '"'
       
  from cte c
 where c.QID is not null
/*
Columns are ordered by name in alphabet order
*/
    --order by c.QID;
    order by 
    cast(left(c.QID, charindex('.', c.QID) -1) as int),
    cast(substring(c.QID, charindex('.', c.QID) + 1, LEN(c.QID) - charindex('.', reverse(c.QID)) - charindex('.', c.QID)) as int),
    cast(right(c.QID, charindex('.', reverse(c.QID)) - 1) as int);
    
    print --top 10 
       @columnList

    order by c.QID;
    /*order by 
    cast(left(c.QID, charindex('.', c.QID) -1) as int),
    cast(substring(c.QID, charindex('.', c.QID) + 1, LEN(c.QID) - charindex('.', reverse(c.QID)) - charindex('.', c.QID)) as int),
    cast(right(c.QID, charindex('.', reverse(c.QID)) - 1) as int);*/