Write a SQL query to extract data from a SQL Server database
$250-750 AUD
Cancelled
Posted over 9 years ago
$250-750 AUD
Paid on delivery
Scenario:
We use a commercial product to manage properties and currently have to manually extract information on a monthly basis to do a mail out. This is extremely time consuming so are looking to use a query to do this for us.
Details:
The back-end to the product is a SQL Server database. As it is a commercial product we do not have access to the schema nor can it be modified. It is anticipated the query will be initially run in Microsoft Query or Excel but a more elegant solution maybe produced later.
Objective:
You will need to understand the schema of the database and write to a query to extract the information we require. The deliverable is expected to be a simple SELECT statement.
Resources:
For this task, you will be given a login to our network with Remote Desktop Gateway and access to a workstation running Windows 8.1 and access to SQL Server Management Studio 2012 with rights over a database on a remote SQL Server.