Database

CREATE PROCEDURE spGetChildAccounts 
	@ParentId Char(12)
AS
BEGIN
	SET NOCOUNT ON;
	WITH Subsidaries (ACCOUNTID,ParentID)
	AS
	(
		SELECT ACCOUNTID, ParentID FROM Accounts WHERE ParentID = @parentID
		UNION ALL
		SELECT Accounts.ACCOUNTID, Accounts.ParentID FROM Accounts
            INNER JOIN Subsidaries ON Accounts.ParentID = Subsidaries.ACCOUNTID
	)
	SELECT * FROM Accounts INNER JOIN Subsidaries ON Accounts.ACCOUNTID = Subsidaries.ACCOUNTID
END

<br />
CREATE TRIGGER Trigger2<br />
ON dbo.Customer<br />
FOR /* INSERT, UPDATE, DELETE */<br />
INSERT INTO Administration (AccountStatus, UserType, UserLoginId,UserPassword,PasswordReminder,PasswordReminderAnswer,IsUserLoggedIn)<br />
VALUES (False, <br />
        Customer.Usertype,<br />
        Customer.UserLoginId,<br />
        Customer.UserPassword,<br />
        Customer.PasswordReminder,<br />
        Customer.PasswordReminderAnswer,<br />
        False)<br />
AS<br />
	/* IF UPDATE() ... */<br />
<br />