2 Replies Latest reply: Nov 14, 2012 2:37 PM by Brian Garland RSS

    Query Question

    Brian Garland

      I have a SQL Server table that contains sales data by fiscal week number but not all weeks have sales. However, I need a chart that displays all weeks. How can I write my script so that it will load the data rows I do have and create rows for the data I'm missing?

       

      QueryData.jpg