FUNCTION [dbo].[FN_IslemFisiAdetSonNGun](@DayNum int, @Firma nvarchar(5))

RETURNS TABLE

AS

RETURN

    WITH CTE_Numbers AS (
        SELECT n = 1, convert(nvarchar, getdate(), 112) d
        UNION ALL
        SELECT n + 1, convert(nvarchar,dateadd(d, -1 * n,  getdate()), 112) FROM CTE_Numbers WHERE n < @DayNum
    )
    SELECT n.n 'RowNum', convert(datetime, n.d) as 'Tarih', isnull(f.c, 0) 'Adet'
    FROM CTE_Numbers n
     LEFT JOIN (
                    SELECT convert(nvarchar, ff.MuracaatTarihi, 112) 'MuracaatTarihi', count(*) c
                    FROM IslemFisi ff (NOLOCK)
                    WHERE 1=1
                        AND ff.Firma = @Firma
                        AND ff.MuracaatTarihi > convert(nvarchar, dateadd(d, -1 * @DayNum, getdate()), 112)
                        AND ff.MuracaatTarihi < convert(nvarchar, dateadd(d, + 1, getdate()), 112)
                    GROUP BY convert(nvarchar, ff.MuracaatTarihi, 112)
            ) AS f ON (n.d) = f.MuracaatTarihi