A basic Tsql query

$10-30 AUD

Mbyllur

Postuar

almost 6 years ago

$10-30 AUD

Paguhet në dorëzim

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

ID e Projektit: 17018156

Rreth projektit

10 propozime

Projekt në distancë

Aktive 6 yrs ago

Po kërkoni të fitoni para?

Adresa e email-it

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj

Paguhuni për punën tuaj

Përshkruani propozimin tuaj

Është falas të regjistrohesh dhe të bësh oferta për punë

10 freelancers are bidding on average $25 AUD for this job

@FiveExceptions

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

$25 AUD në 1 ditë

5,0

(1 review)

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 në 1 ditë

4,9

(27 përshtypje)

4,8

@cwasyl

A proposal has not yet been provided

$27 AUD në 1 ditë

5,0

(4 përshtypje)

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 në 0 ditë

5,0

(7 përshtypje)

2,7

@NehadSalem

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

$25 AUD në 1 ditë

5,0

(1 review)

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 në 1 ditë

0,0

(0 përshtypje)

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 në 1 ditë