USP_DATAFORMTEMPLATE_VIEW_RUNASAPPUSER_LOGINNAME

            create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RUNASAPPUSER_LOGINNAME
            (
                @ID nvarchar(255),
                @DATALOADED bit = 0 output,
                @GUID uniqueidentifier = null output
            )
            as
                set nocount on;

                -- be sure to set this, in case the select returns no rows

                set @DATALOADED = 0;

                select @DATALOADED = 1,
                    @GUID = ID
                from dbo.APPUSER
                where USERNAME = @ID or EMAILADDRESS = @ID;

                return 0;