Build MSSQL Queries from Database

Ukończone Opublikowano Aug 10, 2013 Płatność przy odbiorze
Ukończone Płatność przy odbiorze

We have a MSSQL Database, with multiple tables. We need a query to be written in order for us to get access to the right information, All the information is there, we just need it put together into a format we can use withing our business.

We are looking for someone who has Great MSSQL administration and program experience.

User: SA
Password: Eas1fyPeas1fyLemonSqueaz1fy

From what I can see. The information require is in the following Tables

dbo.ORDER_ELEMENTS
dbo.ORDERS
dbo.OrderPayments

From the dbo.ORDER_ELEMENTS we Need the following information.
Order_NO, Customer_NO, Date Placed, Status ID. PAID, Comments, Date Paid

From the dbo.ORDERS
Stock Code, Quantity, ORDER_NO (Linked to dbo.ORDER_ELEMENTS.Order_no), Unit_PRICE, Buy_PRICE, Element_Status

From dbo.OrderPayments
ORDER_NO (Linked to dbo.ORDER_ELEMENTS.Order_no), CashAmount, Card Amount, Chequeamount, Datepaid

Database is MSSQL11 Express (2012 Express)

Eksploracja danych Microsoft SQL

Numer ID Projektu: #4814061

O projekcie

27 ofert Zdalny projekt Aktywny Aug 11, 2013

Przyznany użytkownikowi:

saviits

Hi Sir, Sql expert here. have extensive knowledge and skills in writing complex queries, stored procedures, triggers, Sql jobs etc., Ready to start!

$60 USD w ciągu 0 dni
(1 Ocena)
1.6

27 freelancerów złożyło ofertę za $112 w tym projekcie

feninsoftech

Hi, I have 8.5 years experience in SQL development. I have expertise in writing complex queries using Joins, Sub Queries and co-related queries. I have MCTS in SQL Server from Microsoft.

$111 USD w ciągu 3 dni
(47 Oceny)
6.7
anshumanvermaUK

Hi I have 4 years of programming and administration experience in MSSQL. Please share more details.

$40 USD w ciągu 3 dni
(12 Oceny)
6.3
cheapexcell

Please send the details. Thanks

$144 USD w ciągu 3 dni
(72 Oceny)
6.2
maverick44000

Hi there. I recently finished a project which required optimizing an SQL query via VBA. Being highly proficint in Access and Excel, I shall be glad to do your too. Hoping to read from you. Regards

$125 USD w ciągu 5 dni
(15 Oceny)
5.9
weonlydo

Please see detailed bid in PM

$126 USD w ciągu 3 dni
(31 Oceny)
5.5
manhpham

I am very interested in your project. Please contact me for discussion.

$155 USD w ciągu 1 dnia
(44 Oceny)
5.6
vnb400sl

i can develop the queries

$155 USD w ciągu 3 dni
(54 Oceny)
5.3
elboukharimu

I can help you please check your Inbox.

$115 USD w ciągu 3 dni
(26 Oceny)
5.2
DeoTech

Hello. I have more than 12 years experience in MS SQL. Regards

$155 USD w ciągu 37 dni
(12 Oceny)
4.4
Prateekagra

HI i am expert in MS SQL database and i have working from last 7 years and this is very easy to do.

$38 USD w ciągu 1 dnia
(7 Oceny)
4.2
VjCoder

Hi i can do this..Check PM!

$112 USD w ciągu 3 dni
(4 Oceny)
3.6
Dusan74

Hi, I am a SQL developer with 10+ years of experience. Details of project implementation are in the PMB. Thanks!

$70 USD w ciągu 3 dni
(6 Oceny)
3.3
lokeshk9936

Hi, Please see PM.

$166 USD w ciągu 7 dni
(3 Oceny)
2.9
gracefulwork

Hello, I am interested in this project.

$50 USD w ciągu 1 dnia
(3 Oceny)
2.6
zkutch

Hello. More 20 years programming experience. See pmb, please.

$100 USD w ciągu 0 dni
(1 Ocena)
2.0
vladislavzalesak

Quite simple SELECt query, can be done very fast.

$35 USD w ciągu 1 dnia
(1 Ocena)
1.3
phongpp2000

ready to start

$55 USD w ciągu 1 dnia
(0 Oceny)
0.0
m11ph

Good day sir. Please check your inbox.

$111 USD w ciągu 3 dni
(0 Oceny)
1.0
gressp

Will get the job done fast and accurate.

$100 USD w ciągu 1 dnia
(0 Oceny)
0.0
mrsh3757

Many years of expeience in databses and PL/SQL. Please see PM.

$155 USD w ciągu 3 dni
(0 Oceny)
0.0