 	SET NOCOUNT ON;
 
     -- Insert statements for procedure here
-DECLARE @Rooms AS XML, @Floor AS XML, @Svg AS XML;
+DECLARE @Rooms AS XML, @Floor AS XML, @Svg AS XML, @Html AS XML, @Navigation AS XML;
 SET @Rooms = (SELECT (SELECT SVG) -- we don't want to add any new elements so use subquery
 		FROM dbo.Room
 		WHERE CampusID = @campusId

	insert sql:variable("@Floor") as last
	into (svg:svg)[1]
');
SELECT @Svg;
END
/*
--Test
EXEC dbo.usp_FloorplanSVG @campusId = 'PH', @buildingId = 'OB', @floorId = 'F0';

*/
GO

	@campusId VARCHAR(5), 
	@buildingId VARCHAR(5),
	@floorId VARCHAR(5),
	@roomId VARCHAR(5) = NULL, -- optionally highlight a room
	@internetType VARCHAR(25) = 'image/svg+xml'
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
