Closed

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

44 freelancers are bidding on average $29 for this job

hits

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)
8.7
rinsadsl

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
(564 Reviews)
8.2
$50 USD in 1 day
(193 Reviews)
7.3
feninsoftech

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
(46 Reviews)
6.2
softcarve

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
(70 Reviews)
5.5
jagdishbhatt38

I am having more than 9 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,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)
5.2
cwasyl

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)
4.2
nicrosoft

Respected Employer, I'm a database developer having competitive expertise and experience in database development. I have read your requirements carefully and I'm confident to work on your MS SQL script writing. I w More

$15 USD in 1 day
(16 Reviews)
4.4
SergioAlfaroV

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
(10 Reviews)
4.5
sarikaanand02

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)
4.5
$25 USD in 2 days
(23 Reviews)
4.2
marloufin

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)
3.1
$10 USD in 1 day
(2 Reviews)
2.4
$30 USD in 1 day
(2 Reviews)
2.2
BubbleJet23

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)
0.7
$25 USD in 1 day
(1 Review)
0.7
Adp007

Hi, I have worked as a sql developer in a MNC and I can write good SQL scripts for you. Please provide me the opportunity to show my skills with this project. Feel free to contact me.

$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
amta864

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)
0.0
imdhorajiya99

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)
0.0