HumanResources | HR web app to generate invoices , add jobs , and log time | Business library

I have a training task in AdventureWorks2017 DB. The task is the following: I need a list of the Jobtitle in which the fewest and most women work in proportions. Only consider those in which at least 4 people work.

So far my code looks like this:

I want to build a multi-modules SpringBoot app with following modules :

• App : the Parent module, Main class is here

• Model : all Domain objects, no Main class, no tests

• Tests : dedicated to whole app tests, will have Cucumber tests

My problem is :

I actually can run unit tests on Model's objects in Tests module, but doing a mvn clean install on App module fails because Tests module doesn't know anything about Model's objects.

• In one hand, Spring makes the job, importing all needed classes from Model module and running tests on them.

• In the other hand, Maven cries with the following error : package com.my-app.model.my-package does not exist.

OK, Spring and Maven are 2 different tools but what should I do in the App's POM to explicitely declare that all objects from the Model module should be exported to Tests module in order to be tested ?

Looking for DepartmentName1 + ', ' + DepartmentName2

I'm trying to merge two rows into one row when only one column has different values. Specifically I'm trying to list the name, job title, gender, pay rate, hire date and department name of the top 100 highest paid employees of the AdventureWorks2017 database. Here is the code I have so far:

I have a script that will send an email to an employee's manager if thier account is going to expire in the next 30 days. I am pulling each account one by one and I have been sending them an HTML formatted email with the employee's name and expiration date on behalf of Support to thier manager.

But I don't want to send notification mail one by one to thier manager. for example ,sometimes there may be 30 - 50 users of direct and indirect reports to a manager from Active Directory. So my script will send mail to manager for each expired user. They don't want this.

My question are : 1- How can I send notification mail both accounts is going to expire in the next 30 days and to their manager bulk instead of one by one ?

e.g (John, Michael, Andy, Aaron direct reports to theirmanager@domain.com )

Using Razor pages for my views, I can't find a way to pass an Id / bounded model to my controller.

I have created a delete template view with my model, added a delete action method to my controller, but I can't figure out how to pass any parameters.

Currently simple queries to INFORMATION_SCHEMA views, for example

I'm doing a task, in which I should create a table, here's the code:

I'm trying to make this procedure to verify an employee and display an error message if the id number of the employee exists in the database. I check it with valid numbers it displays the employee but when I do employees that do not exist, I do not get an error message like I'm supposed to.

I've tried if/else and try/catch. I do not know where I'm messing up.

I'm trying to find employees that are less than 10 years from the hire date but when I run the query my employees keep repeating. I do not know where I'm messing up. This is what I have tried so far. Thanks. Also I'm using MS SQL