USP_CLIENTSITES_FAFEVENTID_GET

Get client site FAF event ID

Parameters

Parameter Parameter Type Mode Description
@CLIENTSITESID int IN
@FAFEVENTID uniqueidentifier INOUT

Definition

Copy


create procedure dbo.USP_CLIENTSITES_FAFEVENTID_GET
(
    @CLIENTSITESID int,
    @FAFEVENTID uniqueidentifier = null output
)
as
begin
    set nocount on;

    select top 1  @FAFEVENTID = EVENTID 
  from dbo.EVENTEXTENSION 
  where CLIENTSITESID = @CLIENTSITESID    

  return 0;
end