Breaking News: Grepper is joining You.com. Read the official announcement!

pass parameter in dynamic sql query

Nanu answered on July 7, 2023 Popularity 5/10 Helpfulness 6/10

answer pass parameter in dynamic sql query

pass parameter in dynamic sql query

Comment

 SET @TotalCountSelect = ' SELECT [m].[MemberEnrollmentHeaderID], [m].[TrackingID], [m].[MBI], [m].[LastName], [m].[FirstName],[m].[MemberStatusID],[k].[MemberStatus], [m].[MemberID],      
  [c].[Code] AS [ApplicationStatusName], [cn].[Code] AS [ContractDescription], [pbp].[Code] AS [PBPDescription], [m].[MemberCode] AS ClientMemberId '    
  
  EXEC sp_executesql @TotalCountSelect, N'@TrackingID VARCHAR(13),@MBI VARCHAR(11),@FirstName VARCHAR(20),@LastName VARCHAR(20),@MemberID VARCHAR(13),@ClientMemberId VARCHAR(24),
  @ApplicationStatusID int,@PBPID int,@MemberStatusID int,@ContractID int, @TotalCount INT OUTPUT'          
  , @TrackingID,@MBI,@FirstName,@LastName,@MemberID,@ClientMemberId,@ApplicationStatusID,@PBPID,@MemberStatusID,@ContractID,@TotalCount OUTPUT

Popularity 5/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: dynamic-sql sql

Link to this answer
Share Copy Link

Contributed on Jul 07 2023

Nanu

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

pass parameter in dynamic sql query

Contents

More Related Answers

pass parameter in dynamic sql query

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.