Find Jobs
Hire Freelancers

write a short MSSQL script

$10-30 USD

Closed
Posted almost 6 years ago

$10-30 USD

Paid on delivery
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)
Project ID: 17159920

About the project

42 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
42 freelancers are bidding on average $29 USD for this job
User Avatar
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
4.9 (662 reviews)
8.7
8.7
User Avatar
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
4.9 (743 reviews)
8.8
8.8
User Avatar
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 maintenance jobs, Optimizing etc. I have expertise in writing complex queries with proper joins and index selection. Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. Thanks
$30 USD in 1 day
4.9 (55 reviews)
6.9
6.9
User Avatar
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
4.9 (103 reviews)
5.9
5.9
User Avatar
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 contact me over chat for details.
$25 USD in 1 day
4.9 (23 reviews)
5.7
5.7
User Avatar
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 utilizing my knowledge and skills.
$40 USD in 2 days
5.0 (34 reviews)
5.2
5.2
User Avatar
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,Entity Framework, HTML5, CSS,Soap Web services,RestFull,React.js etc. Proposed Milestones We deliver quality work, our goal is make customer 100% satisfied and provide best of our services.
$35 USD in 1 day
4.9 (11 reviews)
4.5
4.5
User Avatar
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. Kind regards, Chris
$30 USD in 1 day
5.0 (4 reviews)
4.2
4.2
User Avatar
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.0 (6 reviews)
3.3
3.3
User Avatar
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
4.8 (1 review)
0.7
0.7
User Avatar
I work with Sql everyday in an organisation and should not be difficult to pull records given the specified criteria. Relevant Skills and Experience More than 8 years of Sql experience
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
HI, i'm expert in doing MySQL database, but i need more information about your project , so, invite me in chat box
$100 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
This can be done either using PIVOT or dynamic SQL. I will finish in few hours. I can help you but don't have reviews as I just started looking projects.
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
This should not take more than an hour to do. I'd like to do it for free to boost my reputation on Freelancer, the price I placed as bid is to ensure that Freelancer gets their cut.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Microsoft Certified MCDBA with ample knowledge on scripting and database administration. Knowledge on all version and migration.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have experienced of more than 3 years of development using ASP.NET, ASP.NET MVC, MS SQL and ASP.NET Web API. Hope to hear you back. Thanks.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired. 1) Sql Server 2005/2008/2012, 2) MYSQL, MS Access 3) Oracle (PL/SQL), 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Good at SQL querying and expertise in T-SQL query optimizing and troubleshooting and improving the query performance
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have a ready script done based on your requirements. Please confirm to deliver now. It will dynamically generate up to n number of columns. Thanks, Tendulkar.K
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
fremantle, Australia
4.9
7
Payment method verified
Member since Nov 28, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.