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

84 freelancers are bidding on average $449 for this job

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
(45 Comentários)
7.3
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
(44 Comentários)
5.7
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
(3 Comentários)
5.7
truongngocthanh

Hi Sir i can do this project. please consider.

$367 AUD in 5 dias
(37 Comentários)
5.5
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
(68 Comentários)
5.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
(13 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
(29 Comentários)
4.9
NourElDeen

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

$250 AUD in 10 dias
(29 Comentários)
4.8
aishwary9122

Hello sir, I have good experience on MSSQL server. So I can do this job very well. But I have an question, Do you want only database script or A package which can extract as well as provide you data in any file? Plea Mais

$278 AUD in 5 dias
(2 Comentários)
4.5
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
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
(14 Comentários)
4.7
dogradiwakar

A proposal has not yet been provided

$555 AUD in 10 dias
(4 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
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
(2 Comentários)
4.6
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
(7 Comentários)
4.2
angnut

Hi, you can find my skill and reference on linkedin: [url removed, login to view] You (and I) could use a database backup to understand the structure. If you have a doc (user guide) of the software, please share Mais

$444 AUD in 3 dias
(20 Comentários)
4.2
GhaziOualha

A proposal has not yet been provided

$333 AUD in 5 dias
(2 Comentários)
4.3
point5nyble

Hello, I have been working with a MNC bases company since last ~ 4 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Datawarehouse & Reporting) and helped me in no Mais

$444 AUD in 10 dias
(25 Comentários)
4.6
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
(13 Comentários)
3.7