I understand your requirements. This is a bit challenging. Since you are brand new around here I went ahead and put together some ddl and sample data in a consumable format so you can see how you should post this type of thing.

Here it is:

set dateformat dmy

if OBJECT_ID('tempdb..#Something') is not null

drop table #Something

create table #Something

(

ID int,

Employee varchar(20),

Job varchar(20),

StartDate datetime,

EndDate datetime,

Workload int

)

insert #Something

select *

from (Values

(1, 'John Doe', 'HSBC', '01/01/2013', '31/12/2013', 100)

,(2, 'John Doe', 'Vacation', '17/06/2013', '21/06/2013', 100)

,(3, 'John Doe', 'Vacation', '19/08/2013', '23/08/2013', 100)

,(4, 'John Doe', 'Barclays', '01/01/2014', '31/01/2014', 50)

,(5, 'John Doe', 'Santander', '06/01/2014', '25/01/2014', 50)

,(6, 'John Doe', 'Vacation', '13/01/2014', '17/01/2014', 100)

) x(a,b,c,d,e,f)

select *

from #Something

So now we all have something to work with. I will see if I can come up with something that will work. Meantime others can work on this too now that they have details to work with.