Lukket

A basic Tsql query

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.

Evner: SQL

Se mere: build a basic website, tsql query xml files, tsql query xml, sql query examples from multiple tables, complex sql query examples, sql queries examples with answers, sql queries for dummies, sql queries pdf, sql commands with syntax and examples, sql tutorial, sql statements list, sql, oracle, tsql query filters, excel visual basic web query error disable message, excel visual basic web query error, basic home renovation contract template, visual basic database query, basic land agreement contract review, basic web development contract template

Om arbejdsgiveren:
( 4 bedømmelser ) Sydney, Australia

Projekt ID: #17018156

12 freelancere byder i gennemsnit $25 på dette job

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 utili Flere

$30 AUD på 1 dag
(27 bedømmelser)
4.8
cwasyl

A proposal has not yet been provided

$27 AUD på 1 dag
(4 bedømmelser)
4.1
abdulrehman57

Hello, My name is Abdul Rehman. I have much experience to design and develop the Database with using SQL server and ORACLE. i also design ERD in both SQL and ORACLE. Kindly inbox me for further queries. Thanks

$30 AUD på 1 dag
(6 bedømmelser)
3.3
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 sa Flere

$15 AUD in 0 dage
(6 bedømmelser)
2.6
$25 AUD på 1 dag
(3 bedømmelser)
2.2
NehadSalem

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

$25 AUD på 1 dag
(1 bedømmelse)
1.6
FiveExceptions

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

$25 AUD på 1 dag
(0 bedømmelser)
0.0
$25 AUD på 1 dag
(0 bedømmelser)
0.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. Flere

$24 AUD på 1 dag
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
0.0
amrsalaheldin7

9 Years Experience in SQl/PL SQL

$25 AUD på 1 dag
(0 bedømmelser)
0.0
$25 AUD på 1 dag
(0 bedømmelser)
0.0