DECLARE @DATA_INI DATE, @DATA_FIM DATE, @NNF INT
SET @DATA_INI = '20170101'
SET @DATA_FIM = '20170110'
PRINT 'ANO-' + 'MÊS-' + 'DIA ' + '--> QTDE NFs'
WHILE @DATA_INI <= @DATA_FIM
BEGIN
SELECT @NNF = COUNT(*) FROM [NOTAS FISCAIS] WHERE DATA = @DATA_INI
PRINT CONVERT(VARCHAR(10), @DATA_INI) + ' --> '
+ CONVERT(VARCHAR(10), @NNF)
SELECT @DATA_INI = DATEADD(DAY,1,@DATA_INI)
ENDRESULTADO DA QUERY:
ANO-MÊS-DIA --> QTDE NFs 2017-01-01 --> 74 2017-01-02 --> 77 2017-01-03 --> 81 2017-01-04 --> 71 2017-01-05 --> 65 2017-01-06 --> 75 2017-01-07 --> 82 2017-01-08 --> 80 2017-01-09 --> 85 2017-01-10 --> 72
