Simple MS SQL SSMS Script
Budget: $30 – $250 AUD
Hello, I need Microsoft SQL Server Mgt Studio query for a large dataset 1,000,000's of rows, which
- only looks at the rows with the latest revisions (identifable by a revision no);
- and for this latest data, sums selected fields to aggregate the data
- and applys the above for a selected subset (region) and from date
A sample (dummy) dataset and more detailed requirements is provided/attached (excel)
- only looks at the rows with the latest revisions (identifable by a revision no);
- and for this latest data, sums selected fields to aggregate the data
- and applys the above for a selected subset (region) and from date
A sample (dummy) dataset and more detailed requirements is provided/attached (excel)