In the "beginning" none of the persons will have formation in the jobs list, so the table will be empty...

When the persons get some kind of training in that job in the end of the training, someone will write the info to the table. Then it will have a start date and for some jobs, it will have additional properties, for example level of experience, etc...

The "return" datatype of the table depends of the kind of report the end user want, the main purpose it's knowing who is capable of doing some job, but that isn't the only report.

The output will be similar to the dynamic query that i wrote, but for simplicity, just assume that i need to return the date from the #PersonJobs table instead of Sum/Count/Whatever Aggregated Function.

Thanks