spGetNetAccountRelations_PendingMyApproval

        CREATE PROCEDURE dbo.spGetNetAccountRelations_PendingMyApproval
            (
            @NetAccountID int
            )
            AS
            BEGIN

            --These represent request made from others of me to be 
            --their friend - I will exercise my judgement!

            SELECT 

            ID,
            NetAccountID 'FriendAccountID',
            Confirmation,
            ConfirmationDate,
            CreateDate,
            UpdateDate

            FROM [NetAccountRelation] 
            WHERE

            RelationAccountID = @NetAccountID 
            AND 
            (BlockedID = 0 OR BlockedID IS NULL)
            AND
            Confirmation = 0

            END