Tag: matrix

Building an Employee Date Matrix

matrix sql sql-server sql-server-2008 tsql

I have a list of employees, along with list of cities they’ve worked in. I need to build a matrix (in SQL Server) of start/end dates by city to determine where they were at any given period in time. The “end date” would be exactly the date before they appeared at a new location. I’ve included an example of the

Query to generate map table to matrix table

matrix pivot sql sql-server tsql

I have 1 map table Group Task —– —– Admin Add Admin Edit Admin Delete Admin View User View I need to generate it in a matrix table like Task Admin User —— —— —— Add …