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.
12 freelancere byder i gennemsnit $25 på dette job
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
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