Dynamic Sitemap

See more:

SQL

I had Problem How I can Make Dynamic Site Map
I Followed All Guidelines In This article but I cannot do
i made stored procedure that display value from query string as.

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

ALTER    Proc Navcategory
(
@Category_Id  Int 
)
As
Select Distinct   Categories.Category,Categories.Category_Id
 From Categories
Where Category_Id=@Category_Id

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

so i want site map display the value which retrieved from query
as

Home<4door.....>