USP_SIMPLEDATALIST_MEMBERSHIPPROGRAMBYSITE

                CREATE procedure dbo.USP_SIMPLEDATALIST_MEMBERSHIPPROGRAMBYSITE(@SITEID uniqueidentifier = null)
                as
                    select 
                        MP.ID as VALUE, 
                        MP.NAME as LABEL
                    from 
                        dbo.MEMBERSHIPPROGRAM as MP
                    where
                        @SITEID = MP.SITEID or (MP.SITEID is null and @SITEID is null)