fnGetNetAccountRelations_Blocked

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@NetAccountID	int	IN

Definition

Copy



CREATE FUNCTION [dbo].[fnGetNetAccountRelations_Blocked]
    (
    @NetAccountID int
    )

    RETURNS TABLE AS Return

    --This will return all my blocked relationships 

    SELECT 

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

    FROM [NetAccountRelation] 
    WHERE

    NetAccountID = @NetAccountID 
    AND 
    BlockedID > 0

    UNION 

    SELECT 

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

    FROM [NetAccountRelation] 
    WHERE

    RelationAccountID = @NetAccountID 
    AND 
    BlockedID > 0