clear markdown compare help donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 497162 fiddles created (9390 in the last week).

DECLARE @FechaInicial DATE = '20170817', @FechaFinal DATE = '20171020'; SELECT DATENAME(MONTH,DATEADD(DAY,number,@FechaInicial)) Mes, COUNT(*) Dias FROM master.dbo.spt_values WHERE type = 'P' AND DATEADD(DAY,number,@FechaInicial) <= @FechaFinal GROUP BY DATENAME(MONTH,DATEADD(DAY,number,@FechaInicial)), DATEPART(MONTH,DATEADD(DAY,number,@FechaInicial)) ORDER BY DATEPART(MONTH,DATEADD(DAY,number,@FechaInicial)) ;
Mes Dias
August 15
September 30
October 20
 hidden batch(es)