I have the below SQL..What I am trying to do is use the Parameter defined at the stored procedure level inside dynamic SQL:
CREATE PROCEDURE [dbo].[Test]
(@DealID NVARCHAR(500),
@OUTPUT NVARCHAR(MAX) OUTPUT,
@FeeType CHAR(1)
) -- I want to use this parameter inside dynamic SQL query
AS
DECLARE @exec_str NVARCHAR(MAX)
DECLARE @ParmDefinition NVARCHAR(MAX)
BEGIN
SET @exec_str = N'DECLARE @ParmDefinition NVARCHAR(500)
SELECT * FROM @FeeType' --This is where I want to use the variable
DECLARE @ParamDefinition nvarchar(max)
SET @ParamDefinition = N'@OUTPUT NVARCHAR(MAX) OUTPUT'
EXEC sp_executesql @exec_str, @ParamDefinition
Can someone please tell me how to do it?
Thanks