In TableA if IDCodeAbbv is not null than WorkID will not be in TableC but IDCodeAbbv will be in TableB. If WorkID is not null than WorkID will be in TableC. At no time, will either IDCodeAbbv or WorkID be null at the same time.
This is an example of how the output should look like
PersonName WorkID WorkLocation IDCodeAbbv IDCodeName
Dan 2 Base 1
Tom SR South Rear
John 4 Base 2
Sam NE North Entrance
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.