UFN_DESIGNATION_ISREVENUEDESIGNATION

Determines if the designation can accept revenue.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@DESIGNATIONID	uniqueidentifier	IN

Definition

Copy



      CREATE function dbo.UFN_DESIGNATION_ISREVENUEDESIGNATION
      (
        @DESIGNATIONID uniqueidentifier
      )
      returns bit
      with execute as caller
      as begin
        declare @ISREVENUEDESIGNATION bit = 0;
        select 
          @ISREVENUEDESIGNATION = ISREVENUEDESIGNATION
        from
          dbo.DESIGNATION
        where
          ID = @DESIGNATIONID

          return @ISREVENUEDESIGNATION;
      end