Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
See attached qvw
Thank you Gysbert. That gives me the method I can use as a basis for my larger, more complexe query.