USP_SIMPLEDATALIST_SPONSORSHIPREASON

Displays a list of reasons by filtering on reason type.

Parameters

Parameter	Parameter Type	Mode	Description
@TYPE	int	IN	Type

Definition

Copy



create procedure dbo.USP_SIMPLEDATALIST_SPONSORSHIPREASON
    (
     @TYPE int
    )
     as
    select 
        ID as VALUE, 
        REASON as LABEL
    from 
    dbo.SPONSORSHIPREASON
  where 
    REASONTYPECODE = @TYPE
    order by REASON