spGetNetGroup_NetAccounts

        CREATE PROCEDURE dbo.spGetNetGroup_NetAccounts
        (
        @NetGroupID int
        )
        AS
        BEGIN

        SELECT 

        ngr.ID, 
        ngr.NetAccountID,
        ngr.Confirmation,
        ngr.ConfirmationDate,
        ngr.CreateDate,
        ngr.UpdateDate    

        FROM [NetGroupRelation] ngr 
        INNER JOIN [NetAccount] na on na.ID = ngr.NetAccountID
        WHERE 
        ngr.NetGroupID = @NetGroupID AND 
        (ngr.BlockedID = 0 OR ngr.BlockedID IS NULL) AND
        na.Deleted = 0 AND
        na.LockedOut = 0

        END