Inserting into a temp table for null condition RRS feed

  • Question

  • Hello everyone,

    I have a temp table (#Northeastsum) created through code that is supposed to show revenue by month by producer (our sales reps). The code works but what I need, in addition is to add records to #NortheastSum that would populate the AcctPd (month) and Revenue with 0 for those months and revenue amounts that are missing where the FiscalYear is 2021. Our Fiscal year goes from May through April. We are in Fiscal Year 2021. Is that possible? I have included sample data showing current and what I would like to see.Example ID

    Thank you!

    Don Fox

    Wednesday, August 12, 2020 3:18 PM