SQL Server 2008R2 CLR


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.

Skills: C# Programming, SQL

See more: sql programming language, programming sql, dynamic programming table, dynamic programming language, sql clr, sql server c# 2008, clr, function stored procedure, sql stored function, sql procedure table clr, stored procedure function, sql select order, set server 2013, 2008r2, sql 2008r2, generate xls using stored procedure sql, stored procedure create sql, based pivot, sql server clr, function stored procedure sql server, server 2008r2 set, stored procedure sql server 2008, create table sql server, sql server create table, dynamic pivot table

Project ID: #5138876

Awarded to:


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

$263 USD in 3 days
(30 Reviews)

18 freelancers are bidding on average $456 for this job


Hi, My name is Janos, I'm from Hungary and would like to help you on this. I have a basic understanding of your requirements from the project decription you posted. Some examples on the input dataset and dataset exp More

$789 USD in 7 days
(24 Reviews)

Hi Sir, I am ready to work for you.I have 9 years of experience in C#, .Net, java, PHP and, MySQL. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work withi More

$412 USD in 3 days
(19 Reviews)

Hi, I have 9 years experience in SQL Server 2005|2008|2008R2|2012 and involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, CLR, Triggers, functions and views. I have More

$555 USD in 10 days
(14 Reviews)

Dear Sir, This is Sikander. I am having expertise in MSSQL Server and I will provide you best solution. Having 12+ years of experience in Software development ans Database and same in MSSQL. Please allow me to work More

$833 USD in 5 days
(12 Reviews)

Hi, An ASP.NET,c#,vb and SqlServer expert here. Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. I would like to highlight following qualities of m More

$600 USD in 10 days
(10 Reviews)

A proposal has not yet been provided

$388 USD in 15 days
(17 Reviews)

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.

$388 USD in 7 days
(17 Reviews)

hello sir. I read your requirement, I understood how this web app working. Im an expert C#. You can check my profile: http://www.freelancer.com/u/minhpd1309.html. I have 5/5 star feedback. I guarantee you will feel sat More

$250 USD in 5 days
(6 Reviews)

Hi I am working on Stored Procedure any kind and working on SQL Server from 17 years................................

$555 USD in 3 days
(4 Reviews)

Hello I have a BS, have been programming/database/design for over 20 years, have a full-time day job, and need extra projects this month. I live in NYC and am American. I'm free to work on this tonight (NY Time), More

$277 USD in 3 days
(3 Reviews)

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.

$611 USD in 3 days
(1 Review)

Hi, I would like to take up this project. I understood the requirements specified and can finish the same according to your timeline. I do have good experience in .Net Technologies (ASP.Net MVC, C#, WCF), Database ( More

$250 USD in 10 days
(1 Review)

A proposal has not yet been provided

$250 USD in 3 days
(1 Review)

Dear Sir, Over seven year's software development experience mainly using Microsoft .NET technologies. Well experienced in overall software development process. Takes special interest in designing scalable .NET applic More

$555 USD in 3 days
(0 Reviews)

Hi, I have experience in developing desktop and WEB applications with C# and MSSQL Server. Please send me details for your project. Thank you.

$555 USD in 10 days
(0 Reviews)

Hi, Greetings from SAB Soft Technologies! My name is Krishnan; we are India based Software Development Company. We are having experienced and certified resources in the latest DOTNET Framework 4.5 with sound knowled More

$421 USD in 3 days
(1 Review)

I've experienced with such type of dynamic projects. I'm working on an ERP project, which is containing this type of dynamic working on various places.

$250 USD in 7 days
(0 Reviews)