Query Question

[Anonymous]

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?

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[Anonymous]

Thank you Gysbert. That gives me the method I can use as a basis for my larger, more complexe query.