Timely insight appreciated.
(Note, I did create a similar post in the MS Office forum and will delete that one)
[Bold]
Context
[/Bold]
Receive a text file that contains data from a Sql Server database.
I import the text file into MS Excel to create a Report.
Data within MS Excel is like this;
Equip Code Sale Date Sale Price
12345 1/25/2019 8000
12346 1/26/2019 10000
89023 1/18/2019 24569
88456 2/25/2019 25000
88457 2/1/2019 13000
11567 1/12/2019 24000
11567 2/13/2019 53000
24680 1/10/2019 21000
24680 2/9/2019 14000
24699 1/5/2019 45257
12345 2/19/2019 61000
12346 1/5/2019 117500
89023 2/27/2019 25600
88456 2/20/2019 10222
88457 1/5/2019 30000
11567 1/3/2019 125000
Step 2 of the process - Using sumproduct formulae within MS Excel to create a matrix report like this;
[Pre]
Sales Price Range
0 - < 25K 25K - < 50K
Equip Code 1/1/2019 2/1/2019 3/1/2019 1/1/2019 2/1/2019 3/1/2019
12346 2 0 0 0
89023 1 0 0 1
88456 0 1 0 1
88457 0 1 1 0
11567 1 0 0 0
24680 1 1 0 0
24699 0 0 1 0
12345 1 0 0 0
[/Pre]
Eventually, in Step 3 of the process, I plan to export the summarized data back to a Sql Server database table for
readily available analysis of trends/patterns across months/years. This summarized table would be continuously updated.
[Pre]
Equip Code Month SalesPriceLevel Nbr
12346 1/1/2019 0 - < 25K 2
89023 1/1/2019 0 - < 25K 1
88456 1/1/2019 0 - < 25K 0
88457 1/1/2019 0 - < 25K 0
11567 1/1/2019 0 - < 25K 1
24680 1/1/2019 0 - < 25K 1
24699 1/1/2019 0 - < 25K 0
12345 1/1/2019 0 - < 25K 1
12346 2/1/2019 0 - < 25K 0
89023 2/1/2019 0 - < 25K 0
88456 2/1/2019 0 - < 25K 1
88457 2/1/2019 0 - < 25K 1
11567 2/1/2019 0 - < 25K 0
24680 2/1/2019 0 - < 25K 1
24699 2/1/2019 0 - < 25K 0
12345 2/1/2019 0 - < 25K 0
[/Pre]
[BOLD]
QUESTION
[/BOLD]
Is it feasible/possible to create the data that is displayed in Step 3 of the process directly using functionality solely within Sql Server?
In essence, it would take the detail data within the Sql Server database table and create summarized data and load into a different table? Sort of like a make table query in MS Access...
Fine with using MS Excel as an intermediate tool to summarize the data but just thought about this idea.
Maybe not possible nor feasible.
Appreciate insight.