write a short MSSQL script

I have the following structure in an MSSQL2008 database : I am in need of a script to replicate the output shown below.

It is generated by: groupby on RPT_ID, FILE_ID, LINE_ID, distinct (dynamic !!!) columns from COLUMN_LITH and 'first' values in COLUMN_VALUES (COLUMN_NAME is dropped)

Skills: Database Administration, Database Programming, Microsoft SQL Server, MySQL, SQL

See more: how to write a short film script, write short book mortgages, write short conclusion, sql server create database script example, sql server scripts examples, sql server script database structure, sql script to create database and tables, sql server script to create all tables, sql server script to create all tables in a database, sql server create database script default location, create database script in sql server 2012, php, software testing, mysql, css, html, website design, software development, wordpress, website testing

About the Employer:
( 5 reviews ) fremantle, Australia

Project ID: #17159920

43 freelancers are bidding on average $29 for this job


We have expertise in MS SQL and can do the needful. Please provide some sample data. Ensuring a quick and thorough job.

$55 USD in 1 day
(736 Reviews)

Hi There, I am expert in MSSQL and I can write a query to fulfill your requirement. Looking forward to work with you Thanks

$35 USD in 1 day
(577 Reviews)
$50 USD in 1 day
(209 Reviews)

Hi, I have 9 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenanc More

$30 USD in 1 day
(50 Reviews)

Hi, I would like to write mssql script to get the records as in the image attached. Available to start now. Get in touch to discuss more. Regards, Manish

$25 USD in 1 day
(82 Reviews)

Hello! I'm a Computer Engineer with a MCSA SQL Server 2014 certification, with more than 10 years of experience using SQL. I can write you a robust, efficient, and easy to understand MS SQL Query quickly. You can conta More

$25 USD in 1 day
(14 Reviews)

I am having more than 9 years of experience in IT industry.I have worked on .net(,,asp,,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili More

$40 USD in 2 days
(32 Reviews)

Hi, I am Ravinder Singh . We have a team of professionals Relevant Skills and Experience Java,Spring,Hibernate,JSP,Serverlet,JDBC,Asp.Net, C#, Asp.Net-MVC, SQL Sever, Web-API, Web services, Jquery, AngularJS, More

$35 USD in 1 day
(11 Reviews)
$25 USD in 2 days
(23 Reviews)

Hi, What you are after is a PIVOT query. If you would like me to help you out with this please let me know. I have 10+ years MSSQL experience working on large global projects so please check my profile for more info More

$30 USD in 1 day
(4 Reviews)

Hi, I've been in mssql for 10 years. I can help you with your project in creating the mssql script. Please let me know to discuss further your requirements. Thanks, Marlou

$25 USD in 1 day
(5 Reviews)
$10 USD in 1 day
(2 Reviews)
$30 USD in 1 day
(2 Reviews)

Hey mate, I don't fully understand what you require but I'm quite savvy with writing T-SQL scripts. Please feel free to contact me to discuss this further. Cheers, Chris

$30 USD in 1 day
(1 Review)
$25 USD in 1 day
(1 Review)

Dear Sir/Ma'am, I have 5 years of experience in Professional IT developing in Websites using .Net Framework, C#, ASP.NET, ASP.NET MVC, [login to view URL], Entity Framework, IIS, WCF, AJAX, Web Services, CSS, CSS3 HTML5,JavaSc More

$35 USD in 2 days
(1 Review)
$25 USD in 1 day
(0 Reviews)

Hi , My name is Ahmad , I have more than 14 years experience in sql server. I think I can solve your request asap Relevant Skills and Experience Sql server advanced queries, big databases structures, sql optimizer, More

$25 USD in 1 day
(0 Reviews)

here i place my bid on this project.i ready to work like this type of project thanks nd regards BHAVIN DHORAJIYA

$25 USD in 1 day
(0 Reviews)

Have 2 years and 3 months experience in Oracle. Being an Oracle APPS Technical, I am efficient in SQL/Plsql. Relevant Skills and Experience SQL and Plsql

$35 USD in 1 day
(0 Reviews)