Build MSSQL Queries from Database

已完成 已发布的 Aug 10, 2013 货到付款
已完成 货到付款

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)

数据挖掘 微软 SQL

项目ID: #4814061

关于项目

27个方案 远程项目 活跃的Aug 11, 2013

授予:

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 在0天内
(1条评论)
1.6

有27名威客正在参与此工作的竞标,均价$112/小时

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 在3天内
(47条评论)
6.7
anshumanvermaUK

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

$40 USD 在3天内
(12条评论)
6.3
cheapexcell

Please send the details. Thanks

$144 USD 在3天内
(72条评论)
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 在5天内
(15条评论)
5.9
weonlydo

Please see detailed bid in PM

$126 USD 在3天内
(31条评论)
5.5
manhpham

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

$155USD 在1天里
(44条评论)
5.6
vnb400sl

i can develop the queries

$155 USD 在3天内
(54条评论)
5.3
elboukharimu

I can help you please check your Inbox.

$115 USD 在3天内
(26条评论)
5.2
DeoTech

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

$155 USD 在37天内
(12条评论)
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.

$38USD 在1天里
(7条评论)
4.2
VjCoder

Hi i can do this..Check PM!

$112 USD 在3天内
(4条评论)
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 在3天内
(6条评论)
3.3
lokeshk9936

Hi, Please see PM.

$166 USD 在7天内
(3条评论)
2.9
gracefulwork

Hello, I am interested in this project.

$50USD 在1天里
(3条评论)
2.6
zkutch

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

$100 USD 在0天内
(1条评论)
2.0
vladislavzalesak

Quite simple SELECt query, can be done very fast.

$35USD 在1天里
(1条评论)
1.3
phongpp2000

ready to start

$55USD 在1天里
(0条评论)
0.0
m11ph

Good day sir. Please check your inbox.

$111 USD 在3天内
(0条评论)
1.0
gressp

Will get the job done fast and accurate.

$100USD 在1天里
(0条评论)
0.0
mrsh3757

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

$155 USD 在3天内
(0条评论)
0.0