USP_SPONSORSHIPOPPORTUNITYRESERVE_GETPARAMETERS

CREATE procedure dbo.USP_SPONSORSHIPOPPORTUNITYRESERVE_GETPARAMETERS
 (
   @ID uniqueidentifier
    )        
  as begin
    select
    PROCESS.ID
   ,PROCESS.IDSETREGISTERID
   ,PROCESS.NAME
   ,PROCESS.DESCRIPTION
   ,PROCESS.GROUPID
   ,PROCESS.CHILDGENDERCODE
   ,PROCESS.ISHIVPOSITIVECODE
   ,PROCESS.HASCONDITIONCODE
   ,PROCESS.ISORPHANEDCODE
   ,PROCESS.MAXKEYNUMBER
   ,PROCESS.SPROPPAGERANGEID
   ,PROCESS.INCLUDEPENDING
   ,PROCESS.MULTIPLELOCATION
   ,PROCESS.ENDDATE
   ,cast(case when PROCESS.ENDDATE is null then 0 else 1 end as bit) HASENDDATE
    from
        dbo.SPONSORSHIPOPPORTUNITYRESERVEPROCESS PROCESS
    where
        PROCESS.ID = @ID   
   end