spNetAccount_DeleteNetGroupRelations

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

        DELETE ngr FROM dbo.NetGroupRelation ngr
        INNER JOIN dbo.NetGroup ng ON ng.ID = ngr.NetGroupID
        WHERE ngr.NetAccountID = @NetAccountID
        AND ng.NetAccountID <> @NetAccountID

        END