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.

Most likely the CLR will have to be a CLR Stored Procedureand not a TVF.

Habilidades: Programação C#, SQL

Veja mais: 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

Acerca do Empregador:
( 28 comentários ) Liberty Township, United States

ID do Projeto: #5138876

Concedido a:


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 em 3 dias
(35 Comentários)

17 freelancers estão ofertando em média $468 para esse trabalho


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 Mais

$789 USD in 7 dias
(29 Comentários)

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 Mais

$412 USD in 3 dias
(41 Comentários)

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 Mais

$833 USD in 5 dias
(21 Comentários)

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 Mais

$555 USD in 10 dias
(31 Comentários)

A proposal has not yet been provided

$388 USD in 15 dias
(34 Comentários)

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 Mais

$600 USD in 10 dias
(9 Comentários)

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 dias
(7 Comentários)

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 ( Mais

$250 USD in 10 dias
(19 Comentários)

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

$555 USD in 3 dias
(7 Comentários)

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 dias
(18 Comentários)

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), Mais

$277 USD in 3 dias
(5 Comentários)

A proposal has not yet been provided

$250 USD in 3 dias
(2 Comentários)

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 dias
(1 Comentário)

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 dias
(0 Comentários)

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 Mais

$421 USD in 3 dias
(1 Comentário)

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 Mais

$555 USD in 3 dias
(0 Comentários)