USP_DATALIST_MEMBERSHIPCARDSTOPRINT

CREATE procedure dbo.USP_DATALIST_MEMBERSHIPCARDSTOPRINT(
    @PRINTMEMBERSHIPCARDSPROCESSSTATUSID uniqueidentifier
    )
as
    set nocount on;

    declare @OUTPUTTABLENAME nvarchar(100)
    select @OUTPUTTABLENAME = TABLENAME from BUSINESSPROCESSOUTPUT where TABLEKEY = convert(nvarchar(100), @PRINTMEMBERSHIPCARDSPROCESSSTATUSID)

    declare @TEMP table (
        MEMBERSHIPCARDID uniqueidentifier,
        MEMBERSHIPID uniqueidentifier,
        COMPUTEDMEMBERSHIPID nvarchar(100)
    )
    declare @SQL nvarchar(max)
    set @SQL = 'select MEMBERSHIPCARDID, MEMBERSHIPID, COMPUTEDMEMBERSHIPID from ' + @OUTPUTTABLENAME
    insert into @TEMP 
    exec (@SQL)

    select T.MEMBERSHIPCARDID as ID,
            T.MEMBERSHIPID,
            T.COMPUTEDMEMBERSHIPID
    from dbo.MEMBERSHIPCARD M
        inner join @TEMP T
        on M.ID = T.MEMBERSHIPCARDID
    where M.CARDNUMBER = ''