Concluído

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.

This is a SQL project without any websites or web skills required. It is expected that you should have experience with SQL Server and database development.

Habilidades: Microsoft SQL Server , SQL

Veja 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:
( 15 comentários ) Newtown, Australia

ID do Projeto: #6786099

Concedido a:

AlFaresian

In fact, i am a database programmer originally, where i have great experience in doing complex queries from different resources , Oracle, MySQL, MS SQL server ... also i can deal with data on an Excel file or CSV Mais

$250 AUD em 5 dias
(2 Comentários)
2.6

56 freelancers estão ofertando em média $412 para esse trabalho

joonnet

Hello My ninja level SQL skills will enable me to easily write a query of any level of complexity that you may require. If the data is in there, I can get it out for you, likely in a single SELECT but I have tons Mais

$333 AUD in 3 dias
(27 Comentários)
6.7
CodeAmbassador

hi, I'd like to help you on this. I have over 12 years experience with SQL and .net development. I welcome you to check out previous related projects I concluded here on freelancer for references. My bid is for analysi Mais

$444 AUD in 4 dias
(18 Comentários)
6.7
truongnguyen86

Hi there, i'm expert on both SQL and Oracle. Actually i've worked with SQL for over 3 years but with Oracle is over 6 years, both is developing the back end with Package, procedure,function.... I've done many complex r Mais

$600 AUD in 10 dias
(138 Comentários)
6.5
otssols

Hello We have a team of SQL programmers having good hands in RDBMS and SQL queries . Also able to optimize existing DB structures using Normalization concepts and other sql skills It would be great if you just sha Mais

$567 AUD in 10 dias
(4 Comentários)
6.7
rinsadsl

Hi there I have great experience with SQL development. I can do this project for you. Looking forward to hear from you. Thanks Rinsad

$526 AUD in 10 dias
(57 Comentários)
6.2
feninsoftech

Hi, Recently i had completed a similar project to extract information from tables, format email in HTML and send email using xp_senddbemail. I have 9 years experience in SQL Server 2005|2008|2008R2|2012 and invol Mais

$555 AUD in 10 dias
(40 Comentários)
6.0
latatestTech

100% Quality(Lets Chat) Hello, We have team of 9 Professional Software Engg. We are very much confident about your job we will do it in your time and cost. We are into the market since from last 5 year, we pro Mais

$263 AUD in 10 dias
(6 Comentários)
5.5
PaulSimonk

Hi, I have gone through your project description. I could provide you a well experienced professional programmer to assist you. I will let you know the actual price and duration time after discussing the clarificatio Mais

$515 AUD in 4 dias
(4 Comentários)
5.4
kmpal

Hi, I am an experienced developer with vast experience in .NET, MVC and SQL available for this project. I am full time freelancer available 10 hours daily. Thanks and best regards Khalid Skype - khalidpal Mais

$350 AUD in 10 dias
(29 Comentários)
5.3
abdellatif81

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around databases and SQL development arou Mais

$250 AUD in 5 dias
(15 Comentários)
4.6
AliSafder

I have over 6 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like MVC, .Net technologies(Asp.Net, Vb.Net / C# ) ,PHP, WordPress, ASP CLASSIC etc. Scri Mais

$250 AUD in 5 dias
(24 Comentários)
4.5
dogradiwakar

Hi , Also will it be possible for you to provide a template with the fields you require and in case any business logic which needs to be added

$277 AUD in 5 dias
(3 Comentários)
4.6
bspanovic

Hello I'm Microsoft Certified Database Developer & Administrator. Similar work I done successful in past. I have fixed price for this job. Because we don't know the database schema this task can be done in a fe Mais

$277 AUD in 10 dias
(11 Comentários)
5.4
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

$530 AUD in 5 dias
(27 Comentários)
5.5
DeoTech

Hello, I have more than 14 years experience in MS SQL. I am using 2012 version. I did the same projects. Extracting of the data can be manage by the MS SQL Server profiler. Regards.

$611 AUD in 10 dias
(16 Comentários)
4.6
posspooja

Hello, I am an PHP Certified Developer with more than 7 years of experience and shall get this done in about 12 days' time. Let me know if you have any doubts / queries about my expertise, will be more than hap Mais

$736 AUD in 12 dias
(1 Comentário)
4.0
AcuityInfotech

Hi,    We’ve had a good look at your project description, do you have the SQL server access? If yes then we can set the schema as well. Anyways may be some tricky views or complex SQL statement needs to implement. Yo Mais

$444 AUD in 10 dias
(3 Comentários)
4.2
Aloknano

A proposal has not yet been provided

$750 AUD in 12 dias
(2 Comentários)
3.7
madhur0912

A proposal has not yet been provided

$500 AUD in 10 dias
(1 Comentário)
1.6
abhi0726

I have handful of experience in querying data from database. I write stored procedures, triggers, functions for various CRUD operations I can do this as am available 24 hrs online and have good internet speed conn Mais

$555 AUD in 10 dias
(3 Comentários)
1.7