Declare @LiveRS Table (
					RDL varchar(MAX),
					CompletePath nvarchar(max)
						)


Insert Into @LiveRS

select convert(varchar(max), convert(varbinary(max), content)) [RDL],Path + Name [CompletePath]
from [TEST].[Reportserver].[dbo].catalog
where content is not null


Declare @SourceControlRS Table (RDL varchar(max),
								 CompletePath nvarchar(max))


Insert Into @SourceControlRS

select convert(varchar(max), convert(varbinary(max), content)) [RDL],Path + Name [CompletePath]
from [LIVE].[Reportserver].[dbo].catalog
where content is not null


 Select SC.CompletePath [Source Control Path], RS.CompletePath [Live Server Path],case 
								When SC.RDL = RS.RDL Then 'Match'
								Else 'RDLs different'
								End [RDL Match],
						 Case 
								When SC.CompletePath = RS.CompletePath Then 'Match'
								Else 'Paths Different'
								End [Path Match]
								
 From @LiveRS RS
 Full Outer join @SourceControlRS SC on SC.CompletePath = RS.CompletePath