A basic Tsql query

$10-30 AUD

Closed

Posted

almost 6 years ago

$10-30 AUD

Paid on delivery

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

About the project

10 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

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 in 1 day

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 in 1 day

4.9

(27 reviews)

4.8

@cwasyl

A proposal has not yet been provided

$27 AUD in 1 day

5.0

(4 reviews)

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 in 0 day

5.0

(7 reviews)

2.7

@NehadSalem

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

$25 AUD in 1 day

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 in 1 day

0.0

(0 reviews)

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 in 1 day