USP_SPONSORSHIP_GETGREATESTNEEDRULESET

CREATE procedure dbo.USP_SPONSORSHIP_GETGREATESTNEEDRULESET
(
@ID uniqueidentifier
)
as
begin
    select NAME, SPONSORSHIPOPPORTUNITYTYPECODE, RULESETDATA,
    cast(case when exists(select 'x' from dbo.SPONSORSHIPPROGRAM where SPONSORSHIPPROGRAM.SPONSORSHIPGREATESTNEEDRULESETID = SPONSORSHIPGREATESTNEEDRULESET.ID) then 1 else 0 end as bit) INUSE
    from dbo.SPONSORSHIPGREATESTNEEDRULESET
    where ID = @ID
end