How to generate XML document using Store Procedure in SQL Server

CREATE PROCEDURE  sp_getXML 
AS
BEGIN
    SELECT    C.CategoryID,
            C.CategoryName,
            F.FurnitureID,F.FurnitureName,
            SUM(F.FurniturePrice) FurniturePrice
    FROM tbl_Furniture F
    INNER JOIN tbl_Category  C ON F.CategoryID = C.CategoryID   
    GROUP BY C.CategoryID,C.CategoryName,F.FurnitureID,F.FurnitureName
    ORDER BY C.CategoryID
    FOR XML AUTO, ROOT('Furnitures')
END