BEGIN

DECLARE @dtDate DATETIME
DECLARE @lastDay DATE;
DECLARE @firstDay DATE;
DECLARE @currentDate DATE;
DECLARE @month_table AS TABLE(DATA DATE);

SET @dtDate =  @DATA;
SET @lastDay    =  CAST(DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,@dtDate)+1,0))  AS DATE)
SET @firstDay   =  DATEADD(d,-DAY(@dtDate)+1,@dtDate);
SET @currentDate = @firstDay;

WHILE @currentDate <> dateadd(d,1,@lastDay)
BEGIN
    PRINT @currentDate;
    INSERT INTO @month_table VALUES(@currentDate);
    SET @currentDate = dateadd(d,1,@currentDate);
END

     SELECT * FROM (

    SELECT DATA,motivo,SUM(total) AS total,CAST(campanha AS VARCHAR(11)) AS campanha,[TYPE]
    FROM [TP_clientes_Barclaycard].[dbo].[ftcc_ppp_motivo_nelegivel_totais]
    GROUP BY DATA,motivo,campanha,[TYPE]

    UNION ALL

    SELECT DATA,motivo,0 AS total,CAST('ftcc_ppp' AS VARCHAR(11)) campanha,'LOP' AS [TYPE]
    FROM @month_table
    CROSS JOIN dbo.ftcc_ppp_motivo_nelegivel_keys

    UNION ALL
    SELECT DATA,motivo,0 AS total,CAST('ftcc_ppp' AS  VARCHAR(11)) campanha,'ALOP' AS [TYPE]
    FROM @month_table
    CROSS JOIN dbo.ftcc_ppp_motivo_nelegivel_keys

    UNION ALL
    SELECT DATA,motivo,0 AS total,CAST('ftcc_ppp_lx' AS VARCHAR(11)) campanha,'CARD' AS [TYPE]
    FROM @month_table
    CROSS JOIN dbo.ftcc_ppp_motivo_nelegivel_keys
    ) xpto
    WHERE campanha = 'ftcc_ppp'



END