USP_MKTCOMMUNICATIONEFFORTKPIS_GETKPISTODELETE

CREATE procedure dbo.USP_MKTCOMMUNICATIONEFFORTKPIS_GETKPISTODELETE
(
  @SEGMENTATIONID uniqueidentifier
)
as
begin

  set nocount on;

  select
    [KPIINSTANCE].[ID]
  from
    dbo.[KPIINSTANCE]
  where
    [CONTEXTRECORDID] = cast(@SEGMENTATIONID as nvarchar(100)) and
    [KPICATALOGID] not in (select [KPICATALOGID] from dbo.[MKTSEGMENTATIONACTIVATEKPI] where [SEGMENTATIONID] = @SEGMENTATIONID);

end