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


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.


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.


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.


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

Veja mais: objective statement, 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, sql maybe

Acerca do Empregador:
( 0 comentários ) Giza, Egypt

ID do Projeto: #6788298

5 freelancers estão ofertando em média $478 para esse trabalho


Hello. I am a Sql Server expert. I can work for you. Please look my reviews and send me a message. Thank you.

$526 AUD in 3 dias
(10 Comentários)

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 10 dias
(20 Comentários)

Hello, I am SQL expert. I am willing to help you do this project right now. Please contact me. Thank you

$277 AUD in 10 dias
(12 Comentários)

I can extract the schema as well for future use, you may utilize it. For the current task i may provide a very perfect solution.

$700 AUD in 5 dias
(0 Comentários)

A proposal has not yet been provided

$555 AUD em 1 dia
(0 Comentários)

A proposal has not yet been provided

$333 AUD in 10 dias
(0 Comentários)