Find Jobs
Hire Freelancers

SQL query T-sql

$2-8 USD / hour

Închis
Data postării: peste 3 ani în urmă

$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.
ID-ul proiectului: 29067350

Despre proiect

31 propuneri
Proiect la distanță
Activ: 3 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
31 freelanceri plasează o ofertă medie de $9 USD/oră pentru proiect
Avatarul utilizatorului
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 în 40 zile
5,0 (302 recenzii)
7,9
7,9
Avatarul utilizatorului
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 în 40 zile
5,0 (17 recenzii)
5,7
5,7
Avatarul utilizatorului
Need to talk with customer to discuss Need to talk with customer to discuss Need to talk with customer to discuss
$5 USD în 40 zile
5,0 (31 recenzii)
5,4
5,4
Avatarul utilizatorului
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 în 40 zile
5,0 (10 recenzii)
5,1
5,1
Avatarul utilizatorului
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 în 15 zile
5,0 (49 recenzii)
5,2
5,2
Avatarul utilizatorului
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 în 40 zile
5,0 (22 recenzii)
4,7
4,7
Avatarul utilizatorului
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 în 40 zile
5,0 (11 recenzii)
4,4
4,4
Avatarul utilizatorului
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 în 20 zile
5,0 (24 recenzii)
4,2
4,2
Avatarul utilizatorului
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 în 40 zile
5,0 (2 recenzii)
4,4
4,4
Avatarul utilizatorului
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 în 40 zile
5,0 (3 recenzii)
4,3
4,3
Avatarul utilizatorului
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 în 40 zile
5,0 (7 recenzii)
2,9
2,9
Avatarul utilizatorului
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 în 40 zile
5,0 (2 recenzii)
1,8
1,8
Avatarul utilizatorului
Use JOINs
$17 USD în 20 zile
5,0 (1 recenzie)
1,7
1,7
Avatarul utilizatorului
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 în 40 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Hello Nathaniel ⭐⭐⭐ Hire me! I'll do it perfectly! ⭐⭐⭐ I would like to contribute my passion for you. Please contact me. Thanks
$10 USD în 40 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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 în 40 zile
5,0 (1 recenzie)
0,0
0,0
Avatarul utilizatorului
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 în 40 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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 în 40 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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 în 20 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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 în 30 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul CROATIA
Split, Croatia
5,0
315
Metoda de plată a fost confirmată
Membru din apr. 30, 2010

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.