Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Validate the members

Answered Validate the members

  • Friday, February 08, 2013 6:59 AM
     
     
    Sign In to Vote
    0

    Hi,

    I want to validate a particular batch of members by procedure udpvalidatemembers.

    @MemberIdList is a table variable and I am having issues with the scope of this variable.

    My code is something like this

    declare @stmt nvarchar(max) =
       'declare @MemberIdList mdm.IdList ' +
       'insert into @MemberIdList ' +
       'SELECT ID FROM mdm.SV_' + @Entity_Name + ' where validationstatus='''+@Validation+'''' +'   '+ 'exec mdm.udpValidateMembers  
         @User_ID = @UserID, ' +
       '   @Version_ID = @VersionID, ' +
       '   @Entity_ID = @EntityID, ' +
       '   @MemberIdList = @MemberIdList, ' +
       '   @MemberType_ID = 1'


    declare @params nvarchar(max) =
       
       '@UserID int, ' + 
       '@VersionID int, ' + 
       '@EntityID int'
    exec sys.sp_executesql
      @stmt = @stmt,
       @params = @params,
       @UserID = @User_ID,
       @VersionID = @Version_ID,
       @EntityID = @Entity_ID

    Even I am having a where clause, But still all the members are getting validated.

     

All Replies