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.
Most likely the CLR will have to be a CLR Stored Procedureand not a TVF.
Hello, Please take a look at my past SQL projects, I am very much experienced in SQL and analysis services. I can clearly understand the requirements related to Pivot, UnPivot, date ranges, etc. Thanks Swamy
17 freelancers are bidding on average $468 for this job
Hi. I have great experience in development of SQL-CLR objects since this environment was introduced in MS SQL Server 2005. I assure you of my 100% committment and quality work. Regards, Yuri.
Sir, we have experience in building Stored Procedure having Pivots. We have developed this kind of procedures in our ERP project to generate dynamic reports.