I need help writing a C# console application with SQL Server 2005 DB. The table I will be querying has thousands of records so It needs to be multi-threaded. The program needs two functions.
One that calculates the Product of all ItemCost values by ItemCategory.
The second function needs to calculate the Median value of ItemCost by ItemCategory.
The name of my SQL table is INVENTORY with the fields ItemCost (float), ItemCategory (varchar).
How can I do this?
Thanks in advance,