PDC_REPORT_CreazioneDB/sql/Produzione/viste/dbo_GetStatistics_elab.sql
2025-06-10 16:47:41 +02:00

5 lines
277 B
SQL

create view GetStatistics_elab
as
select s.elab as typ, rete, count(s.codicefiscale) _counter from [C6MartPeriodico].[cruscotto_contrattisei] s with (nolock)
inner join GetStatistics_recordsToProcess t with (nolock) on t.codiceFiscale = s.codicefiscale
group by elab, rete