Find Jobs
Hire Freelancers

SQL query T-sql

$2-8 USD / hour

Zamknięte
Opublikowano ponad 3 lata temu

$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.
Identyfikator projektu: 29067350

Informację o projekcie

31 ofert
Zdalny projekt
Aktywny 3 lata temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
31 freelancerzy składają oferty o średniej wysokości $9 USD/godz. dla tej pracy
Awatar Użytkownika
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 w 40 dni
5,0 (302 opinii)
7,9
7,9
Awatar Użytkownika
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 w 40 dni
5,0 (17 opinii)
5,7
5,7
Awatar Użytkownika
Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss
$5 USD w 40 dni
5,0 (31 opinii)
5,4
5,4
Awatar Użytkownika
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 w 40 dni
5,0 (10 opinii)
5,1
5,1
Awatar Użytkownika
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 w 15 dni
5,0 (49 opinii)
5,2
5,2
Awatar Użytkownika
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 w 40 dni
5,0 (22 opinii)
4,7
4,7
Awatar Użytkownika
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 w 40 dni
5,0 (11 opinii)
4,4
4,4
Awatar Użytkownika
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 w 20 dni
5,0 (24 opinii)
4,2
4,2
Awatar Użytkownika
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 w 40 dni
5,0 (2 opinii)
4,4
4,4
Awatar Użytkownika
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 w 40 dni
5,0 (3 opinii)
4,3
4,3
Awatar Użytkownika
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 w 40 dni
5,0 (7 opinii)
2,9
2,9
Awatar Użytkownika
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 w 40 dni
5,0 (2 opinii)
1,8
1,8
Awatar Użytkownika
Use JOINs
$17 USD w 20 dni
5,0 (1 opinia)
1,7
1,7
Awatar Użytkownika
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 w 40 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hello Nathaniel ⭐⭐⭐ Hire me! I'll do it perfectly! ⭐⭐⭐ I would like to contribute my passion for you. Please contact me. Thanks
$10 USD w 40 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 40 dni
5,0 (1 opinia)
0,0
0,0
Awatar Użytkownika
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 w 40 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 40 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 20 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 30 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga CROATIA
Split, Croatia
5,0
315
Zweryfikowana metoda płatności
Członek od kwi 30, 2010

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.