Code:
CREATE PROCEDURE sp_Get_Member_xml
	@MEMB_ID INT
AS
BEGIN
	DECLARE @left_child_id INT,
			@right_child_id INT,
			@PARENT_MEMB_ID INT,
			@MAIN_ID INT
			
	DECLARE @temp TABLE
	(
		id BIGINT IDENTITY,
		member_id INT,
		member_name VARCHAR(50),
		left_child_id INT,
		right_child_id INT,
		left_child_updated INT,
		right_child_updated INT,
...