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 windows, excel windows, sql microsoft access, server studio, microsoft access sql, excel scenario, back end server, write simple, sql query, sql microsoft, microsoft sql server, extract information, database microsoft sql, back end data, sql 2012 schema extract, windows 2012 management, access query excel, sql maybe, sql server access excel, remote desktop management, excel sql query, schema sql, monthly database access, extract data sql server

Acerca do Empregador:
( 0 comentários ) Hong Kong

ID do Projeto: #6788681

4 freelancers estão ofertando em média $496 para este trabalho

ngscoder

Hi To qualify myself, I am Microsoft Certified Professional in SQL Server and .Net with 10 years of experience working with small to enterprise level organizations. I have performed database owner and architect role Mais

$526 AUD in 4 dias
(26 Comentários)
5.7
acronymsolutions

Hi, I have gone through your requirements,I am a Database Programmer at CMMI-5 Level company since August 2004.I am working on MS Access, Shell Script,PL/SQL,T-SQL,MySql,MSSQL Server,Oracle database, I can do your job Mais

$526 AUD in 7 dias
(20 Comentários)
4.9
honeypotant

Hello. As I am a mobile expert, I have rich experience about mobile project. If you want to know about my work, please check my portfolio and review. I can start your project immediately. I have all sorts Mais

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

Dear Sir / Mam, I understand your all requirements,We will update you every day on our work. We can do your work as per your requirement . We are very flexible in pricing also. We are 24x7 hour available in skype. Mais

$631 AUD in 20 dias
(0 Comentários)
0.0
seocompanyluckno

A proposal has not yet been provided

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