USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTMEMBERSHIPPROGRAMS

                CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTMEMBERSHIPPROGRAMS]
                (
                  @ID uniqueidentifier,
                  @DATALOADED bit = 0 output,
                  @MEMBERSHIPPROGRAMS xml = null output
                )
                as
                    set nocount on;

                    set @MEMBERSHIPPROGRAMS =
                        (
                            select [MEMBERSHIP].[MEMBERSHIPPROGRAMID]
                            from dbo.[MEMBERSHIP]
                                inner join dbo.[MEMBER] on [MEMBER].[CONSTITUENTID] = @ID and [MEMBER].[MEMBERSHIPID] = [MEMBERSHIP].[ID]
                            where
                                [MEMBER].[ISDROPPED] = 0
                                and [MEMBERSHIP].[STATUSCODE] <> 1
                            for xml raw('ITEM'), type, elements, root('MEMBERSHIPPROGRAMS'), binary base64
                        );

                    set @DATALOADED = 1;

                    return 0;