USP_GET_EVENTCAMPAIGNS_BYEVENTIDS

            CREATE procedure USP_GET_EVENTCAMPAIGNS_BYEVENTIDS (@EVENTIDS as nvarchar(300))
            as
            begin

            set @EVENTIDS =','+@EVENTIDS+','

            select EC.CAMPAIGNID,EC.CAMPAIGNSUBPRIORITYID from dbo.EVENTCAMPAIGN EC
            inner join dbo.BBNCEVENTIDMAP as BEM on EC.EVENTID = BEM.EVENTID 
            inner join dbo.CAMPAIGN on EC.CAMPAIGNID = CAMPAIGN.ID
            where  
            charindex(','+cast(BEM.ID as varchar)+',', @EVENTIDS) >0
            and CAMPAIGN.ISACTIVE=1
            end