USP_GETSEGMENTATIONEXPORTOUTPUTTABLENAMES

CREATE procedure dbo.USP_GETSEGMENTATIONEXPORTOUTPUTTABLENAMES
(
    @MKTSEGMENTATIONEXPORTPROCESSSTATUSID uniqueidentifier
)
as
begin

    select
        TABLENAME,
        EXPORTCOLUMNMETADATA,
        TABLEKEY
    from
        BUSINESSPROCESSOUTPUT
    where
        -- MKTSEGMENTATIONEXPORTPROCESSSTATUS has FK as PK to BUSINESSPROCESSSTATUS table, so we can avoid a join.

        BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID = @MKTSEGMENTATIONEXPORTPROCESSSTATUSID
        and
        -- Not the summary output table, only data output tables.

        BUSINESSPROCESSOUTPUT.TABLEKEY != BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID
end