UFN_MKTCONSOLIDATEDQUERYVIEW_GETVIEWSQL

create function dbo.[UFN_MKTCONSOLIDATEDQUERYVIEW_GETVIEWSQL]
(
  @RECORDSOURCEID uniqueidentifier
)
returns nvarchar(max)
as
begin
  declare @SQL nvarchar(max);
  declare @VIEWNAME nvarchar(128);

  set @SQL = '';

  select
    @VIEWNAME = [QUERYVIEWCATALOG].[OBJECTNAME]
  from dbo.[QUERYVIEWCATALOG]
  inner join dbo.[MKTCONSOLIDATEDQUERYVIEWSPEC] on [MKTCONSOLIDATEDQUERYVIEWSPEC].[CONSOLIDATEDQUERYVIEWCATALOGID] = [QUERYVIEWCATALOG].[ID]
  where [MKTCONSOLIDATEDQUERYVIEWSPEC].[ID] = @RECORDSOURCEID;

  if len(isnull(@VIEWNAME, '')) > 0
    select
      @SQL = all_sql_modules.definition
    from sys.all_sql_modules
    inner join sys.objects on objects.object_id = all_sql_modules.object_id
    where objects.name = @VIEWNAME;

  return @SQL;
end