You have chosen to sponsor your bid up to a maximum amount of .
1. Develop CLR - SQL Server 2008 R2
2. Language - C#
3. Table value function
A. Dynamic Pivot Table
B. Parameters to pass to CLR Function:
1. Stored Procedure
2. Start date - string
3. End Date - string
4. Aggregate columns - string
5. Pivot column - string
6. Select columns- string comma delimited
7. Order by column
The CLR will need to execute the stored procedure with the start and end date params and from the result set and other params listed, generate the dynamic pivot table. So the CLR should be able to create any pivot based on the params passed.
Additional Project Description:
11/17/2013 at 22:26 EST
Most likely the CLR will have to be a CLR Stored Procedureand not a TVF.