Cancelado

Write a SQL query to extract data from a SQL Server database

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.

Habilidades: Microsoft SQL Server , SQL

Ver mais: objective statement, microsoft excel management, microsoft excel for windows 8, excel for windows 8, sql server or, sql microsoft access, server studio, microsoft access sql, excel scenario, back end server, write query, write a simple, SQL Query, sql microsoft, MICROSOFT SQL SERVER, extract information to, excel with sql server, excel to sql, database microsoft sql, back end data, access to sql, sql 2012 schema extract, windows 2012 management, windows server task server, access query excel

Acerca do Empregador:
( 0 comentários ) Bhubaneshwar, India

ID do Projeto: #6787691

2 freelancers estão ofertando em média $638 para este trabalho

sandanilprashan

A proposal has not yet been provided

$750 AUD in 5 dias
(1 Comentário)
0.8
opuswebdevlopers

Hello sir, We have good experience of Photoshop,Banner Design ,Flayer mail, Sql Injection, Logo Design, PHP, L,HTML5,CSS,JavaScript,Mysql,JOOMLA,wordpress, Graphic Design,Website Design, Android, java, .net. ple Mais

$526 AUD in 10 dias
(0 Comentários)
0.0