Error declare variable
Publicado por Hans Araneda (1 intervención) el 19/04/2022 14:31:28
Error al declarar la variable y al intentar usar la variable en el scrip texto.
DECLARE @sql nvarchar(MAX)
Declare @Formulario nvarchar(max)
set @Formulario = 'Adicional Inventario'
SET @sql = N'
SELECT
*
FROM
(
SELECT Extender_Key_Values_1 Proyecto
, Extender_Window_Name Formulario
, STRNG132
, FIELDNAM
-- cambiar el nombre del formulario --
FROM [AXX_Ext_Proy] where Extender_Window_Name = '+ @Formulario +'
) AS T
PIVOT
(
max(STRNG132)
FOR FIELDNAM IN (' + (SELECT STUFF(
(
SELECT
',' + QUOTENAME(LTRIM(FIELDNAM))
FROM
(SELECT DISTINCT FIELDNAM
-- cambiar el nombre del formulario --
FROM AXX_Ext_Proy where Extender_Window_Name = @Formulario
) AS T
ORDER BY
FIELDNAM
FOR XML PATH('')
), 1, 1, '')) + N')
) AS P;';
--En la variable @sql tenemos la consulta completa
EXEC sp_executesql @sql;
DECLARE @sql nvarchar(MAX)
Declare @Formulario nvarchar(max)
set @Formulario = 'Adicional Inventario'
SET @sql = N'
SELECT
*
FROM
(
SELECT Extender_Key_Values_1 Proyecto
, Extender_Window_Name Formulario
, STRNG132
, FIELDNAM
-- cambiar el nombre del formulario --
FROM [AXX_Ext_Proy] where Extender_Window_Name = '+ @Formulario +'
) AS T
PIVOT
(
max(STRNG132)
FOR FIELDNAM IN (' + (SELECT STUFF(
(
SELECT
',' + QUOTENAME(LTRIM(FIELDNAM))
FROM
(SELECT DISTINCT FIELDNAM
-- cambiar el nombre del formulario --
FROM AXX_Ext_Proy where Extender_Window_Name = @Formulario
) AS T
ORDER BY
FIELDNAM
FOR XML PATH('')
), 1, 1, '')) + N')
) AS P;';
--En la variable @sql tenemos la consulta completa
EXEC sp_executesql @sql;
Valora esta pregunta


0