Maybe I should make this bigger...

Need help? Help us help you. 
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices...

Welcome to SSC.  Please help us help you and read this article: Forum Etiquette: How to post data/code on a forum to get the best help

Once we have...

You would just OUTER join your query to the table of internal users.  The result would be that any external users would generate a NULL in the Users table, so...

If you're not allowed to create the function, ask someone with permissions to do it.  If they want their answers, they're going to have to comply. =)  The function can...

First step is to give whoever did this a beating. Databases like this are pretty much useless.

Here's most of a solution:
link to DelimitedSplit8K

DECLARE @MyString...

UPDATE TimeAccountMovement
SET ownerID = DutyRosterShift
WHERE A.orig_owner_ID = 999999
AND B.Orig_id = A.OwnerID;

So you have Sales (or something similar) and now you want to add a Forecast fact table?  They're not the same granularity. They don't belong in the same table. They're...