Em Andamento

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 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

Acerca do Empregador:
( 15 comentários ) Newtown, Australia

ID do Projeto: #6786099

Premiar 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
(1 Comentário)
0.0

58 freelancers estão ofertando em média $415 para este trabalho

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.6
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.4
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
(27 Comentários)
6.0
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
(83 Comentários)
5.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
(31 Comentários)
5.3
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
(21 Comentários)
4.9
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
(2 Comentários)
4.8
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
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.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
(5 Comentários)
4.2
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
(6 Comentários)
3.6
quadermamun1

Expert and 10+ years of experience .NET/ASP.NET developer. Key Skills: .NET• ASP.NET•MS-SQL• MVC• TDD• Telerik• C#• VB.NET• HTML•Jquery• JavaScript• Ajax• Design Patterns• N-tier app. I'm experienced with wide Mais

$444 AUD in 7 dias
(2 Comentários)
2.7
Aloknano

A proposal has not yet been provided

$750 AUD in 12 dias
(1 Comentário)
2.7
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
(1 Comentário)
2.4
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
(3 Comentários)
1.9
madhur0912

A proposal has not yet been provided

$500 AUD in 10 dias
(1 Comentário)
1.6
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
(2 Comentários)
1.5
gperete

Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office. All my freelancer projects have been vba-related thus far, hence no reviews for sql. But my more than Mais

$250 AUD in 3 dias
(1 Comentário)
0.8
fpasovic

Hi, I am available for immediate start on project. We will discuss on details, access to database if you pick our offer. Thank you in advance.

$277 AUD in 4 dias
(1 Comentário)
0.5
saniokazzz

Hello, I'm professional developer with 5+ years experience with Microsoft SQL Server. I can complete your task.

$250 AUD in 5 dias
(0 Comentários)
0.0