If you can collect duration in minutes, storing it as a decimal count of minutes and only ever converting it as a presentation layer thing is probably the best approach....

Join OADDR and left join TableD and then do:

IIF (TableD.AgentSupervisorID Is Null, OADDR.AgentAddress, HADDR.AgentAddress) As AgentAddress

Well a simple algorithm is easy:
Select sometext, left(sometext, 5) as hash from #table
Now it's a naïve hash with a fairly high probability of collisions, but it's...

Why would the first result be (3 a), when (1 a) and (2 a) also appear to have non-zero values for revenue and quantity?

Use Jeff Moden's DelimitedSplit8K function: http://www.sqlservercentral.com/articles/Tally+Table/72993/

Yeah, can't say I've ever had an issue with auto growth for data files, as long as you don't set it to something silly like 1MB increments and then every...

Check for something calling sp_start_job to run the job. A job can be executed that way without a schedule or even if the job itself is set to disabled.

If the resultant columns are fixed, you can just do:
Select
 AgentID,
 Home As HomePhone,
 Work As WorkPhone,
 Mobile As MobilePhone
From #Temp T
Pivot
(
 Max(PhoneNumber)...

Interesting, you learn something every day. Thanks chaps.

Yeah, I can see how in that situation there's a lot more incentive to work with something that's a lot more granular in terms of storage and undoing poor design...

Percentage growth is always a terrible idea, and usually leads to a surprising growth coupled with a shortage of disk space and that overwhelming feeling that you really are going...