Query to get the Employee name and their Manager name from the same table in SQL Server

Query to get the Employee name and their manager's name from the same table in SQL Server

 

Below is Employee Table 

SELECT e.employeename, m.employeename AS ManagerName FROM Employee e JOIN Employee m ON e.ManagerId = m.EmployeeId 

Group joined list of people based on speaking language

Angular - ng.ps1 cannot be loaded because running scripts is disabled on this system. ng server is not working, ng is not recognized.

 ng server is not working (ng is not recognized):

If ng serve is not recognized or not worked in out angular application we will get below error message in Terminal window.

Execute below command in Terminal.

Set-ExecutionPolicy -Scope CurrentUser -ExecutionPolicy Unrestricted

How to move item in an array to last position in javascript.

const arrayList = ['1', '2', '3', '5', '0'];

const moveThreeToEnd = (arrayList) => {

return arrayList.filter(item => item !== '3').concat(arrayList.filter(item => item === '3'))

}

console.log(array list); //['1', '2', '3', '5', '0' ];

console.log(moveThreeToEnd(array list)); // ['1', '2', '5', '0', '3'];

How to disable mat text box filed in angular

 How to disable mat form filed in angular.

isDisableField: boolean = true;

In html need add [readonly] = "isDisableField"

in CSS: 

.disable-field {

pointer-events: none;

.mat-form-field-flex {

background--color: gray;

}

.mat-form-field-outline {

display : none;

}

}

Get Local Date format without time in angular. 

getLocalDateWithOutTime(dateValue: string | Date): string {

        const localDateTime = dateValue instanceof Date ? dateValue : new Date(dateValue);

        const dateString = localDateTime.getFullYear() + '-' +

            (localDateTime.getMonth() > 8 ? localDateTime.getMonth() + 1 :

             '0' + (localDateTime.getMonth() + 1)) + '-' +

            (localDateTime.getDate() > 9 ? localDateTime.getDate() :

             '0' + localDateTime.getDate());

        return dateString;

    }

How to group an array of objects through a key using reduce in angular

How reduce works

Lets see an usual example of array reduce,

// Person array with name and Age

const person = [

  {

    name: 'Jim',

    color: 'blue',

    age: 22,

  },

  {

    name: 'Sam',

    color: 'blue',

    age: 33,

  },

  {

    name: 'Eddie',

    color: 'green',

    age: 77,

  },

];

// Add their sum of ages

const sumOfAges = person.reduce((sum, currentValue) => {

  return sum + currentValue.age;

}, 0);

console.log(sumOfAges); // 132

• reduce accept initial value, here in our sum of ages, we pass 0 as the initial value
• reduce iterate over each value and add the sum each time with their previous sum value. Thus we return the sum at each step and that sum get added with the next age value.
• the final sum value will be returned at the end of iteration.

  // Accepts the array and key

const groupBy = (array, key) => {

  // Return the end result

  return array.reduce((result, currentValue) => {

    // If an array already present for key, push it to the array. Else create an array and push the object

    (result[currentValue[key]] = result[currentValue[key]] || []).push(

      currentValue

    );

    // Return the current iteration `result` value, this will be taken as next iteration `result` value and accumulate

    return result;

  }, {}); // empty object is the initial value for result object

};

// Group by color as key to the person array

const personGroupedByColor = groupBy(person, 'color');

How to groupBy using reduce in Javascript

For the person array, lets group the objects using the color value. In our object, there are two blue color object and one green color object.

Steps to create the groupBy function,

• create an object as initial value for our result object
• inside the array reduce, create an array for each distinct key value and push the currentValue if the key value present in the currentValue

// this step of code can be restructured to multiple lines, see below for the multi line code

(result[currentValue[key]] = result[currentValue[key]] || []).push(

  currentValue

);

// This is how the above code in multiple line

if (!result[currentValue[key]]) {

  result[currentValue[key]] = [];

}

result[currentValue[key]].push(currentValue);

the end result after grouping will look like this,

{
  "blue": [
    {
      "name": "Jim",
      "color": "blue",
      "age": 22
    },
    {
      "name": "Sam",
      "color": "blue",
      "age": 33
    }
  ],
  "green": [
    {
      "name": "Eddie",
      "color": "green",
      "age": 77
    }
  ]
}

Reference:

https://learnwithparam.com/blog/how-to-group-by-array-of-objects-using-a-key/