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: sql 2012 schema extract, 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, windows 2012 management, windows server task server, access query excel, sql maybe

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #6795311

85 freelancers estão ofertando em média $448 para este trabalho

seekdeveloper

Hello, I have read your post and understood your requirement. I have great experience in handling Wordpress /Magento/Joomla/Drupal/PHP/Java/[url removed, login to view] Python/Django/Javascript/MySQL/ HTML5/CSS3/ Mais

$1030 AUD in 10 dias
(2 Comentários)
5.7
marasinghe82

Dear Sir, I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, BI reporting and six years of application development experienc Mais

$277 AUD in 10 dias
(65 Comentários)
5.5
truongngocthanh

Hi Sir i can do this project. please consider.

$367 AUD in 5 dias
(30 Comentários)
5.2
buraqtech

1. Vollks Australian Online Store In these days we are complete re-designing and reimplementing an online store for our Australian client in which we are using X-Cart latest stable release to implement his all require Mais

$594 AUD in 7 dias
(3 Comentários)
5.2
arpitutrivedi

Hello, I can help You with this project. Please share details like how many reports (Select queries) You need and what is the name of commercial product. Often, we can find schema information for a commercial produc Mais

$250 AUD in 10 dias
(38 Comentários)
5.1
NourElDeen

Dear Sir, I'm expert at SQL and Interested on doing your project. Kind Regards, NourElDeen

$250 AUD in 10 dias
(27 Comentários)
4.8
shadowdancerlv

Use SQL diagram tool to create the table layout. Build the select statement and choose either SSIS or Powershell to export.

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

Dear Sir, We have gone through project description. Our team is very much interested to carry your job by targeting on time delivery along with perfection of project. [url removed, login to view] W Mais

$701 AUD in 10 dias
(3 Comentários)
4.7
sikandermandal

Dear Sir, This is Sikander. I am having 12+ years of experience in software development and I am ready to start this job. I will provide you best services in development. Please have a look at my Profile, Ratings an Mais

$750 AUD in 10 dias
(9 Comentários)
4.6
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 in IT projects with 5 years working around Microsoft database Mais

$250 AUD in 4 dias
(15 Comentários)
4.6
codetod

Hi I am a database expert with 12 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. With Mais

$250 AUD in 5 dias
(12 Comentários)
4.5
AcuityInfotech

Hi,    We’ve had a good look at your project description and we’re very interested in providing a solution. When can we talk?     We are a professional development company headquartered in Virginia and have more Mais

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

A proposal has not yet been provided

$333 AUD in 5 dias
(1 Comentário)
4.2
dogradiwakar

A proposal has not yet been provided

$555 AUD in 10 dias
(5 Comentários)
4.2
pablotorres

I am working on software development since 1992. I am expert on migration of databases, custom or general purpose. I can migrate any kind of relational databases with just few SQL sentences. I can solve problems abou Mais

$250 AUD in 10 dias
(9 Comentários)
3.6
agilepksolutions

Hi, I’ve had a good look at your project description and I’m very interested in providing a solution. I have 3+ hands on experience on developing quality web solutions as well as desktop standalone solutions. I u Mais

$250 AUD in 3 dias
(4 Comentários)
3.5
hardikshah83

Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Micr Mais

$250 AUD in 7 dias
(6 Comentários)
3.4
carivera

Hello dear contractor, I have 6+ year of experience writing advanced sql queries like, stored procedure, cursors, pivot queries, etc. I'll be more than happy to get this query ready for you. Looking forward to Mais

$444 AUD in 3 dias
(3 Comentários)
3.3
dbacsharp

This can be easyly done with SQL Server Profiler. I would launch it, and see what happens on database level when you work with the application. In this way I will extract select statement you need. Additionally, I can Mais

$250 AUD in 3 dias
(3 Comentários)
3.0
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 20 dias
(1 Comentário)
2.7