A basic Tsql query

$10-30 AUD

Avslutat

Publicerad

nästan sex år sedan

$10-30 AUD

Betalning vid leverans

I need a basic tsql query for a the attached spreadsheet to produce the desired output. I believe I need a subquery to output file where; Distinct records where the status <> 'Active' Where there are duplicate records with multiple Status I need to output only one record where there are no Status = 'Active' The purpose of the report is to determine which stores do not currently have an Status = Active contract.

SQL

Project ID: 17018156

Om projektet

10 anbud

Distansprojekt

Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

10 frilansar lägger i genomsnitt anbud på $25 AUD för detta uppdrag

@FiveExceptions

Hello there, I am interested in project post of "A basic Tsql query" and looking forward to discus with you.

$25 AUD Om 1 dag

5,0

(1 omdöme)

4,8

@jagdishbhatt38

I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utilizing my knowledge and skills.

$30 AUD Om 1 dag

4,9

(27 omdömen)

4,8

@cwasyl

A proposal has not yet been provided

$27 AUD Om 1 dag

5,0

(4 omdömen)

4,2

@MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I completed hundreds of SQL projects and i've never had a single problem. If you are interested please message me, i downloaded the sample sheet, and i will try to write the query immediately. Thanks, Milan

$15 AUD Om 0 dag

5,0

(7 omdömen)

2,7

@NehadSalem

i have the needed experience .. and i will make sure to deliver the job successfully ..

$25 AUD Om 1 dag

5,0

(1 omdöme)

2,0

@sandhuneeraj786

Hii Greeting! I works for a private company in DBA filed, have more than 9 years’ experience and very conversant in database filed. I will give you the best solution for your requirement. Following task are below. 1. Database design 2. Writing any SQL query (Including TSQL, User functions, stored procedures & PL/SQL). 3. Modifying, fix issues and optimizing of SQL queries 4. Create SSIS packages 5. Create Databases in Microsoft SQL server and relevants 6. Create Databases in Microsoft Access ,forms and relevants Thanks & Regards Neerak Kumar

$24 AUD Om 1 dag

0,0

(0 omdömen)

0,0

@nimavatkumarbond

I have extensive experience in creating complex SQL queries. Some of the databases were huge with millions of rows. Some of the SQL features like cursors, CTE, pivoting I have used to achieve results

$25 AUD Om 1 dag