Devam Ediyor

Changes needed for a SQL report

Hi,

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

-Location

-EmployeeType

the tables for this information are:

PolicyGroupBusinessArea

PolicyGroupLocation

PolicyGroupEmployeeType

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.

Thanks

Beceriler: Rapor Yazma, SQL

Daha fazlasını görün: way writing report, values report writing, sql pdf files, sql database business, need employee new business, need 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, report writing pdf

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

Proje NO: #6526040

Seçilen:

schungur

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)
4.9

12 freelancer bu iş için ortalamada 34$ teklif veriyor

LearningNew

A proposal has not yet been provided

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

A proposal has not yet been provided

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

A proposal has not yet been provided

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

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)
3.1
Popcon

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)
2.3
bipul39

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)
0.0
abapguru

Hi I am expert in php/mysql recently developed sites in php. for review plz visit my site http://newvisiondesigners.com/cv_files_with_database/emplreg.php http://newvisiondesigners.com/blog/wordpress/work/ Daha fazlası

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

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)
0.0
nitinbohra89

A proposal has not yet been provided

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

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)
0.0
doruk36

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)
0.0
barthengom

Aucune proposition n'a encore été fournie.

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