USP_GETOUTPUTTABLENAMES_FROMACTIVATESTATUSID

CREATE procedure dbo.USP_GETOUTPUTTABLENAMES_FROMACTIVATESTATUSID
(
    @ID uniqueidentifier
)
as
begin

    select
        BUSINESSPROCESSOUTPUT.TABLENAME as [TABLENAME]
    from
        MKTSEGMENTATIONACTIVATEPROCESSSTATUS
    inner join
        MKTSEGMENTATIONACTIVATEEXPORTLINK on MKTSEGMENTATIONACTIVATEEXPORTLINK.ID = MKTSEGMENTATIONACTIVATEPROCESSSTATUS.ID
    inner join
        BUSINESSPROCESSOUTPUT on BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID = MKTSEGMENTATIONACTIVATEEXPORTLINK.EXPORTPROCESSSTATUSID
    where
        MKTSEGMENTATIONACTIVATEPROCESSSTATUS.ID = @ID
        and
        BUSINESSPROCESSOUTPUT.TABLEKEY != convert(nvarchar(50), BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID)

end