Find Jobs
Hire Freelancers

SQL query T-sql

$2-8 USD / hour

Closed
Posted over 3 years ago

$2-8 USD / hour

I need to make SQL query (Microsoft T sql) that does following: I need to retrieve data from 3 tables. In first table I pick all records I need. This part is already done and is simple: step 1. Select some columns from tableA where date = '31.12.2020' now in this above select I will pick date and ID column that is here foreign key but is primary key in other table. This above select will return me many records (around 40 lets say). step 2. Since we have ID I am looking for from previous step, we need to select from tableB Document column, its DocumentID based on ID I have picked and date (31.12.2020). Here we will pick document ID. step 3. Now I need to pick from tableC (Document data table) my data (or records) based on selected documentID. If this can be done in some loop, it would be great.
Project ID: 29067350

About the project

31 proposals
Remote project
Active 3 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
31 freelancers are bidding on average $9 USD/hour for this job
User Avatar
Hello, As an expert in tsql, I can do this and very interested to create the required sql statements. Just i will need a bit more clarifications. Thanks
$20 USD in 40 days
5.0 (302 reviews)
7.9
7.9
User Avatar
Hi, I am ready to help you to write the needed T-sql query, I see in your case the better is using three loops to read from the three tables. I have experience in VB.net, MS SQL server, asp.net and crystal reports more than 13 years. Other skills: Access vba, Excel vba, C#, my sql , technical & Sage 300 (ACCPAC) ERP support, SQL server Replication, Microsoft office(Word, Excel, PowerPoint, Access), Windows servers. Best Regards. Khaled Alflah
$8 USD in 40 days
5.0 (17 reviews)
5.7
5.7
User Avatar
Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss
$5 USD in 40 days
5.0 (31 reviews)
5.4
5.4
User Avatar
Hello, I have read the job description and I am interested in this job. I can create this query as per your requirement. I have 11 years experience in developing products using ASP.NET MVC, Azure, ASP.NET, C# Programming. Regards, Jai Singh
$8 USD in 40 days
5.0 (10 reviews)
5.1
5.1
User Avatar
I can qualitatively assist with T-SQL development because I am Senior MS SQL Developer having 10-plus years of professional experience and highly advanced expertise in T-SQL development.
$25 USD in 15 days
5.0 (49 reviews)
5.2
5.2
User Avatar
Namaste! I have required skill-set and I used same in developing maintenance task to update statistics for every single user table in a database. If hourly rate is higher than may we have to discuss; I can deliver prod ready T-SQL as per your requirement. About me: I'm SQL Server Performance and Emergency Expert; with 6+ years of professional experience in 4 different high performance OLTP system and 4 different freelancing projects. If you trust me, I would be your pain reliever and night saver in case of SQL Server Emergency. About SQL Server Performance: It's hard to make our server 100x faster - but it's really easy to make our database design and queries suddenly 100x more efficient. Fixing queries and tables and indexes is indeed hard work - but it's totally worth it. Warm regards, Kundan (Your remote consultant)
$30 USD in 40 days
5.0 (22 reviews)
4.7
4.7
User Avatar
Hi.. I Exactly Understand your requirements. I am an Experienced Desktop and Web Applications Developer having 3 plus years of valuable experience in C#, Asp.net Web Forms,Asp.net MVC, SQL Server, MY SQL, SSRS (SQL Server Reporting Services). I am interested to work with you. Kindly Hire me. Thanks. Usama Anjam
$5 USD in 40 days
5.0 (11 reviews)
4.4
4.4
User Avatar
Please message me to start your work. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 11+ years experience in MS SQL Server, MySQL and 8+ years experience in SSRS, SSIS (Import / Export). Please let me know more details and when we will start.
$8 USD in 20 days
5.0 (24 reviews)
4.2
4.2
User Avatar
Hi there! I've read the project description carefully. It seems like you are looking to create a SQL query that will retrieve data from three tables. And from what I understand, you want to get data from the first table and then do a LEFT JOIN on the two other tables (i.e. get data only if the primary key matches the foreign key). This is a very standard operation on SQL and I can help you out with this. I have been working with SQL with 3+ years. I believe I can help you out. If any of this sounds interesting, please reply to this and we can discuss your requirements in detail. Best regards, Divyansh Bhatia
$5 USD in 40 days
5.0 (2 reviews)
4.4
4.4
User Avatar
I can help you right now , please ping/connect me. I can create sql queries for sql server database as per design, let me know when to proceed. I can work on future works for databases also if needed. I will work for cheapest budget within time, budget can be re negotiated again, send the details for the project. Please contact me asap. I have 12+ years of experience in database programming,website designing,scripting and android development.
$2 USD in 40 days
5.0 (3 reviews)
4.3
4.3
User Avatar
Hi I have 15 years of experience in SQL server Database development and python. I will be able to help you with the project. please ping me offline to discuss further.
$11 USD in 40 days
5.0 (7 reviews)
2.9
2.9
User Avatar
Hello, I have gone through the requirements. Could you please share table schema of three table so that i can develop a POC and shares to you . If you like the POC then only award this project to me. I have over all 13 years of IT experience which includes 6 years of experience on Sql Server. Thanks,
$6 USD in 40 days
5.0 (2 reviews)
1.8
1.8
User Avatar
Use JOINs
$17 USD in 20 days
5.0 (1 review)
1.7
1.7
User Avatar
Hello, i can help you with this query. I´m a post-graduated DBA with 11+ years of experience. Let´s talk about it and solve the problem very fast.
$8 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Nathaniel ⭐⭐⭐ Hire me! I'll do it perfectly! ⭐⭐⭐ I would like to contribute my passion for you. Please contact me. Thanks
$10 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I read your project 'SQL query T-sql' and I think I have the necessary skills to complete it. I am Software Engineer and database developer with 4+ years of experience working on design and programming of SQL Server and MySQL databases. I have experience and knowledge in the following concepts: -Analysis, design, programming and improvement of queries on demand. -Design and building of queries, subqueries, stored procedures, functions, triggers .. -Advanced use of join, groups by, aggregate functions, CTE, cursors...
$8 USD in 40 days
5.0 (1 review)
0.0
0.0
User Avatar
Hi, my name is Mostafa. I have a diploma in Business Intelligence Development. I have experience in database design, SSIS, SSAS, SSRS, Power BI, and other BI tools. I have experience with Ms SQL server and I can help you with this T-SQL query, send me more details about the tables structure so I can help you. I'm ready to work and I can support you after completing your tasks. I'm a punctual person who respects deadlines. I’m a hard worker, ambitious and enthusiastic to prove myself in my freelancing work. "Practice Makes Perfect" Don't hesitate to contact me if you need help Hoping to work immediately with yo
$8 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have hands on Experience of SQL Server Developer in banking Domain. I can Code Complex SQL Queries and having knowledge of various In-Built functions of SQL server. I Can Provide all Queries as Per your Provided timeline. Please Consider Me for this Query formation and give me a chance to provide service to u. Lets Discuss More about it?
$5 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I can help you with your SQL task, as I have a good knowledge of SQL and a perfect understanding of your project details, message me to discuss this further.
$8 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I just read your posting. It sounds like you need someone who has sound knowledge of SQL and Microsoft SQL Server. I have done similar kind of task in past so, I would be the perfect candidate for this. I have prior experience of working with SQL and Microsoft SQL Server. I value my client's trust and I commit myself to any job, taking full responsibility on completing projects on time. I am looking forward for the job and will try to give my 100% using my skills and experience. Thanks and Regard's Praveen Kumar Singh
$2 USD in 30 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CROATIA
Split, Croatia
5.0
315
Payment method verified
Member since Apr 30, 2010

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.