each one has there own opinion.  it should be left to them. that idle for mutual respect.

i would like to maintain my code in pastebin.

is there any hard rule that...

thanks for highlighting the issue. i have fixed the code.

updated code available in below link.

https://pastebin.com/xUDYhF0r

the code in below link should fulfill your requirement

https://pastebin.com/xUDYhF0r

;WITH XMLNAMESPACES -- XML namespace def must be the first in with clause.

(DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2006/03/reportdatasource'

,'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'

AS rd)

,SDS AS

(SELECT SDS.ItemID, SDS.[Path], SDS.[Name] AS SharedDsName, SDS.ParentID, SDS.[Type], SDS.Content,

CONVERT(xml, CONVERT(varbinary(max), SDS.content)) AS DEF, SDS.LinkSourceID

FROM dbo.[Catalog]...