Devam Ediyor

Changes needed for a SQL report


I have a report which I wrote to display information from a SQL database.

The report displays the date that employees have accepted certain policies.

I need to extend the report so that no 'NULL' values are shown in the report.

instead, the report should show either 'NOT REQUIRED' or 'NOT ACCEPTED'

The logic is as follows:

IF the policy was applicable to this employee THEN return the date it was accepted

IF the date is NULL THEN return 'NOT ACCEPTED'

IF the policy is not applicable to this employee THEN return 'NOT APPLICABLE'

The way to define if a policy is applicable to a user is through another series of tables which list the policies applicable for a combination of;

-Business Area



the tables for this information are:




For each user, their properties (location, busArea, type) are stored in the 'Employee' table.

Attached files.

I have included:

-a copy of the database.

-a pdf of the report that is currently working

-the sql used for the current report

-the sql that I have put together so far in building the new report - however this is not working fully

Please let me know if further details are needed.


Beceriler: Rapor Yazma, SQL

Daha fazlasını görün: writing a business report, way of writing a report, values of report writing, sql pdf files, sql database business, need employee for a new business, need a new employee, define writing, sql database report, sql business, employees needed, employee needed, certain report, sql report writing, writing report pdf, report writing building, sql employee database, employees database sql, employee database sql, location sql database, used report pdf, copy tables pdf, pdf report writing, sql database tables, business report pdf

İşveren Hakkında:
( 19 değerlendirme ) Pinner,, United Kingdom

Proje NO: #6526040



THE TOP SQL FREELANCER AT YOUR SERVICE... PLEASE CHECK MY BADGES PROJECTS AND REVIEWS and ensure yourself that I can do this very well and very quick... Just note on my SQL Level 3 badge... it makes me the TOP SQL Free Daha fazlası

1 gün içinde 30$ USD
(7 Değerlendirme)

12 freelancers are bidding on average $34 for this job


A proposal has not yet been provided

1 gün içinde 29$ USD
(18 Değerlendirme)

A proposal has not yet been provided

1 gün içinde 30$ USD
(1 Değerlendirme)

A proposal has not yet been provided

1 gün içinde 24$ USD
(1 Değerlendirme)

Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Micr Daha fazlası

1 gün içinde 35$ USD
(5 Değerlendirme)

CONSIDER IT DONE! We are a qualified team of ZEND certified engineers. We will surely do this project in the most economically manner. We have made responsive websites for our clients and made customization in Plug-ins Daha fazlası

in 2 gün içinde23$ USD
(1 Değerlendirme)

Dear Hiring Manager I have related sort of expertise to deliver the best in the proposed time and will make the paper through necessary well researched data. I will maintain proper formatting and CS check properly and Daha fazlası

1 gün içinde 100$ USD
(2 Değerlendirme)

Hi I am expert in php/mysql recently developed sites in php. for review plz visit my site [url removed, login to view] [url removed, login to view] Daha fazlası

1 gün içinde 25$ USD
(0 Değerlendirme)

J ai des connaissance en écriture de requête de bases de données et aussi en programmation d'application de gestion

in 3 gün içinde25$ USD
(0 Değerlendirme)

A proposal has not yet been provided

1 gün içinde 20$ USD
(0 Değerlendirme)

Hi, i am ready for your project. I am a little strong in sql handling. Hope you contact me for further more detail. Thank you for check my bid.

1 gün içinde 35$ USD
(0 Değerlendirme)

hello. big experience on mssql oracle and access. which rdbms did your report run on? i guess i can do it.

1 gün içinde 20$ USD
(0 Değerlendirme)

Aucune proposition n'a encore été fournie.

1 gün içinde 30$ USD
(0 Değerlendirme)