spGetNetAccountRelations_MyPendingRequests

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

            --These represent request made from me to others to be 
            --their friend - I am sadly waiting :( ... 

            SELECT 

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

            FROM [NetAccountRelation] 
            WHERE

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

            END