SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TYPE PeriodList_tbltype 
  AS TABLE (Perioada varchar(20),	Indicator varchar(20),val float);
declare @IndicatorTbl PeriodList_tbltype;
declare @period1 nvarchar(20)='2023 Luna 12';
declare @period2 nvarchar(20)='2024 Luna 01';


declare @Indicators table (perioada varchar(20),c9 float,c10 float,c11 float);
insert into @Indicators values
 ('2023 Luna 11',150, 250,3.87)
,('2023 Luna 12',457,598,4.02)
,('2024 Luna 01',557,698,5.02)
;

insert into @IndicatorTbl
select * from (SELECT Perioada, Indicator, val  
FROM   
   (SELECT Perioada, c9,c10,c11
   FROM @Indicators) p  
UNPIVOT  
   (val FOR Indicator IN   
      (c9,c10,c11)  
)AS unpvt )IndUpvt;


select * from @IndicatorTbl;
select @period1 per1,@period2 per2;

declare @PeriodList varchar(1000);
with lst as(
    select Perioada 
    ,row_number()over(order by Perioada) rn
    ,count(*)over() cnt
  from (select distinct Perioada  from @IndicatorTbl)t
  where  Perioada between @period1 and @period2
  )
,r as(
  select 1 lvl,rn,cnt,cast('['+Perioada+']' as varchar(1000)) lp
  from lst where rn=1
  union all
  select lvl+1 lvl,l.rn,l.cnt,cast(lp+',['+l.Perioada+']' as varchar(1000))
  from r inner join lst l on l.rn=(r.rn+1)
)
select @PeriodList=lp from r where lvl=cnt;


select @PeriodList PeriodList;

declare @sql nvarchar(1000)=
'SELECT *
FROM
(
    SELECT Indicator, perioada,val
    FROM  @IndicatorTbl
    where Perioada between @period1 and @period2
) AS P
PIVOT
     (
       SUM(val) FOR perioada IN (' +@PeriodList +')
     ) AS pv1';
select @sql as expr;
declare @paramlist nvarchar(1000);
SELECT @paramlist = '@period1 nvarchar(20),@period2 nvarchar(20)
                     ,@IndicatorTbl PeriodList_tbltype  READONLY'             
                                                                            
EXEC sp_executesql @sql, @paramlist,@period1,@period2,@IndicatorTbl


Perioada
Indicator
val


2023 Luna 11
c9
150

2023 Luna 11
c10
250

2023 Luna 11
c11
3.87

2023 Luna 12
c9
457

2023 Luna 12
c10
598

2023 Luna 12
c11
4.02

2024 Luna 01
c9
557

2024 Luna 01
c10
698

2024 Luna 01
c11
5.02




per1
per2


2023 Luna 12
2024 Luna 01




PeriodList


[2023 Luna 12],[2024 Luna 01]




expr


SELECT *
FROM
(
    SELECT Indicator, perioada,val
    FROM  @IndicatorTbl
    where Perioada between @period1 and @period2
) AS P
PIVOT
     (
       SUM(val) FOR perioada IN ([2023 Luna 12],[2024 Luna 01])
     ) AS pv1




Indicator
2023 Luna 12
2024 Luna 01


c10
598
698

c11
4.02
5.02

c9
457
557


SELECT *
FROM
(
    SELECT 'c9' as Indicator, perioada  as Perioada, 
     C9
    FROM  Indicators 
) AS P
PIVOT
     (
       SUM(perioada) FOR perioada IN ([2023 Luna 11],[2023 Luna 12])
     ) AS pv1

Msg 208 Level 16 State 1 Line 1
Invalid object name 'Indicators'.

SELECT *
FROM
(
    SELECT 'c9' as Indicator, perioada  as Perioada, 
     C9
    FROM  Indicators 
) AS P
PIVOT
     (
       SUM(c9) FOR perioada IN ([2023 Luna 11],[2023 Luna 12])
     ) AS pv1

UNION 

SELECT *
FROM
(
    SELECT 'c10' Indicator, perioada  as Perioada,
    C10
    FROM Indicators
) AS pv2
PIVOT
    (
      SUM(c10) FOR perioada IN ([2023 Luna 11],[2023 Luna 12])
    ) AS pv2  
Msg 208 Level 16 State 1 Line 1
Invalid object name 'Indicators'.
Perioada	Indicator	val
2023 Luna 11	c9	150
2023 Luna 11	c10	250
2023 Luna 11	c11	3.87
2023 Luna 12	c9	457
2023 Luna 12	c10	598
2023 Luna 12	c11	4.02
2024 Luna 01	c9	557
2024 Luna 01	c10	698
2024 Luna 01	c11	5.02