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;
the tables for this information are:
For each user, their properties (location, busArea, type) are stored in the 'Employee' table.
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.
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 Fazla
12 freelancers are bidding on average $34 for this job
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 Fazla
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 Fazla
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 Fazla
J ai des connaissance en écriture de requête de bases de données et aussi en programmation d'application de gestion
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.
hello. big experience on mssql oracle and access. which rdbms did your report run on? i guess i can do it.