How to pass the "in" parameter of the pivot function as a variable in a table-valued function.
This is my function:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo]. [Ft_Pivot01AnalisiGlobale01]
(
@alladata as smalldatetime,
@ListToPivot as NVARCHAR (MAX)
)
RETURNS TABLE
AS
RETURN
(
SELECT * FROM (
select * from dbo.AnalisiGlobale01
where dataimport <= convert (nvarchar (10), @ alladata, 103)
) Analysis Results
PIVOT (
SUM ([SommaDiSellOut])
FOR dataimport
IN ([06/21/2021], [06/22/2021]) ---- insert @ListToPivot
) AS PivotTable
)
GO