Declare @Enc nvarchar(15)
 Declare @FhaInicio nvarchar(20)
 Declare @FhaFin nvarchar(20)  
 Declare @Query nvarchar(max)
 -----Variables
 set @enc = (select Cve_Bloq from dbconf_Bloq where Des_bloq like 'SAT_CFDI_Diario')
 set @FhaInicio ='2019-1-01'
 set @FhaFin = '2019-1-31'
 ----- Informacion de comprobantes 
 set @Query = N'select Convert(date,FechaFacturacionSAT) as Fecha, count(num_doc) as cantidad into #temp1 from gMaestrasat where NUM_DOC>0 '+ CHAR(13)
 set @Query =@Query +'and (Convert(date,FechaFacturacionSAT)) between dateadd(dd, datediff(dd, 0, '''+@FhaInicio+'''), 0) and dateadd(dd, datediff(dd, 0, '''+@FhaFin+'''), 0) '+ CHAR(13)
 set @Query =@Query+'and LEN(UUIDSAT) = 36  group by (Convert(date,FechaFacturacionSAT)) order by fecha'
 set @Query =@Query + CHAR(13)
  set @Query = @Query + N'SELECT Convert(date,Fecha)as fecha, sum(Cantidad) as Cantidad into #temp2 FROM dbENC'+@Enc+' WHERE (Convert(date,Fecha)) between dateadd(dd, datediff(dd, 0, '''+@FhaInicio+'''), 0) and dateadd(dd, datediff(dd, 0, '''+@FhaFin+'''), 0)  AND Cantidad is not null
  group by (Convert(date,fecha)) order by fecha'
  set @Query =@Query + CHAR(13)
  set @Query =@Query + CHAR(13)
  set @Query =@Query + 'select * from #temp1 t
  full join #temp2 t2 on t2.fecha = t.fecha
  order by t2.fecha desc
 '
 --PRINT @Query
 exec (@Query)