Build MSSQL Queries from Database
$30-250 USD
货到付款
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)
项目ID: #4814061
关于项目
授予:
Hi Sir, Sql expert here. have extensive knowledge and skills in writing complex queries, stored procedures, triggers, Sql jobs etc., Ready to start!
有27名威客正在参与此工作的竞标,均价$112/小时
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.
Hi I have 4 years of programming and administration experience in MSSQL. Please share more details.
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
HI i am expert in MS SQL database and i have working from last 7 years and this is very easy to do.
Hi, I am a SQL developer with 10+ years of experience. Details of project implementation are in the PMB. Thanks!