Encerrado

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

ID do Projeto: #6787435

59 freelancers estão ofertando em média $418 para este trabalho

ITservice

Hi, I have 5+ years of experience. Developed various projects in .Net with MsSql database. Infact, 90% of the projects done so far are in ASP, which includes simple dynamic page to complex ecommerce related websites Mais

$526 AUD in 10 dias
(31 Comentários)
6.1
schungur

The top SQL freelancer at your service. Check my SQL level 3 badge. This bid is not final. need more info to make final estimation

$333 AUD in 7 dias
(9 Comentários)
5.0
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

$350 AUD in 10 dias
(20 Comentários)
4.9
shadowdancerlv

The select query is very easy to write in most cases and tends to be the most time consuming as we validate it's correctness. The rest is easy I also have skills in ETL(SSIS in SQL Server), .Net, VBA in MS Access an Mais

$526 AUD em 1 dia
(10 Comentários)
4.8
Reza2012

Hi I have more than 11 years experience in MSSQL database design and administration as well as query writing. Thanks.

$388 AUD in 10 dias
(19 Comentários)
4.4
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 impleme Mais

$444 AUD in 10 dias
(3 Comentários)
4.5
varaprasadanga

I am the Dot Net Professional Developer/ SQL Server developer. My professional experience includes extensive hands on expertise on Microsoft technologies.I understand how to build project that directly meet user requir Mais

$555 AUD in 10 dias
(1 Comentário)
2.7
modestasmockus

A proposal has not yet been provided

$277 AUD in 10 dias
(2 Comentários)
2.4
dbacsharp

I am SQL Server DBA and have a lot of experience with everything that is related to database. I think you need to start SQL Server Profiler, record the SQL code that runs from the application, and then try i through Ma Mais

$300 AUD in 5 dias
(2 Comentários)
1.8
phuctq

Thank you for posting this project .I have more than 5 years experience on C# / SQL. I am ready to start the work right now. I'm looking forward to waiting for your reply. I can work in Wordpress, Joomla, Magento, CM Mais

$555 AUD in 3 dias
(1 Comentário)
1.4
charlestown

I am a database developer in the Philadelphia, PA suburbs with over 20 years of experience. Do you have a layout of what information you want to extract from this database?

$333 AUD in 10 dias
(1 Comentário)
0.8
rkmomin

Dear Hiring Manager, First of all,its my pleasure to bid on your project, I have gone through your requirements and seen your specifications. We are ready to work on it as soon as you will award this project to us. Mais

$250 AUD in 3 dias
(2 Comentários)
0.8
thecloudkernel

We'll get schema via system tables, write correct MSSQL query and even check it runs quickly. We are Israel based premier specialist IT solutions and services company, that combines core technical expertise with a g Mais

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

I work with SQL 2012 on a daily basis and have written MANY SQL statements. I am confident I can write your needed SQL SELECT Statement in one day to your complete satisfaction.

$250 AUD em 1 dia
(0 Comentários)
0.0
shehlakhan021

Hi, With more than 5 years of experience in different versions of SQL Server, I can write complex queries and functions to extract information from database. I am currently working on same platform on day to day basis Mais

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

A proposal has not yet been provided

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

Vast experience 10+ years in Sql development, can deliver sql work in less time than expected. Ready to work day/night as per requirement.

$277 AUD in 4 dias
(0 Comentários)
0.0
gsadeesh

I have 8 years of Experience In IT industry. I love to be a SQL Server Developer also I am a SQL Server DBA. I also doing Corporate Training to IT industries on Sql Server and Dotnet., Just Share me the DB Schema and Y Mais

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

A proposal has not yet been provided

$350 AUD in 3 dias
(0 Comentários)
0.0
neshe

I can follow below steps for the job done... 1- Proper access to the remote DB, 2- Understand the DB schema, 3- Simple query for the DB, 4- Query for the exact result.

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