DDL Script for creating database with tables and the sample.
No Comments on “SampleSalesDB”
Bill Sutton
Hi Ben, I believe you have omitted the data from SampleSalesDB. It creates the tables, but does not populate them. I thought it was the dates, as the SP uses a date range, and it executes, but no values. I also modified the SP to use (DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) in place of the fnDateOnly function, which I also could not find. It is excellent that you included the SampleSalesDB, I think people, myself included follow along better, when they can reproduce the behavior. Thanks for listeng, Bill.
Hi Ben, I believe you have omitted the data from SampleSalesDB. It creates the tables, but does not populate them. I thought it was the dates, as the SP uses a date range, and it executes, but no values. I also modified the SP to use (DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) in place of the fnDateOnly function, which I also could not find. It is excellent that you included the SampleSalesDB, I think people, myself included follow along better, when they can reproduce the behavior. Thanks for listeng, Bill.