CREATE TABLE [dbo].[TimeSheetTest](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeCode] [varchar](50) NOT NULL,
	[ProjectCode] [varchar](50) NOT NULL,
	[HoursWorked] [decimal](18, 2) NOT NULL,
	[DateWorked] [datetime] NOT NULL,
 CONSTRAINT [PK_TimeSheetTest] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]

INSERT INTO TimeSheetTest 
  SELECT           'Adam', 'P1', 8, '2009-01-01'
  UNION ALL SELECT 'Adam', 'P2', 1, '2009-01-01'
  UNION ALL SELECT 'Bob',  'P1', 5, '2009-01-01'
  UNION ALL SELECT 'Bob',  'P2', 3, '2009-01-01'
  UNION ALL SELECT 'Adam', 'P1', 8, '2009-01-03'
  UNION ALL SELECT 'Adam', 'P1', 8, '2009-01-05'
  UNION ALL SELECT 'Bob',  'P1', 7, '2009-01-05'
  UNION ALL SELECT 'Bob',  'P2', 1, '2009-01-05'

exec UberCrosstab 
'EmployeeCode, ProjectCode',
'DateWorked',
'TimeSheetTest',
'HoursWorked',
'SUM'

EmployeeCode     ProjectCode       Jan 1 2009    Jan 3, 2009    Jan 5, 2009
Adam             P1                8.00           8.00           8.00
Bob              P1                5.00           NULL           7.00
Adam             P2                1.00           NULL           NULL
Bob              P2                3.00           NULL           1.00

SELECT *, LEFT(DATENAME(dw, DateWorked), 3) + ' ' + CONVERT(VARCHAR(5), DateWorked, 1) AS Header
  FROM TimeSheetTest

SELECT *, LEFT(DATENAME(dw, DateWorked), 3) + ' ' + CONVERT(VARCHAR(5), DateWorked, 1) AS Header
  INTO #temp
  FROM TimeSheetTest

exec UberCrosstab 
'EmployeeCode, ProjectCode',
'Header',
'#temp',
'HoursWorked',
'SUM'

drop table #temp

SET NOCOUNT ON

DECLARE @StartDate	DATETIME
DECLARE @EndDate	DATETIME
DECLARE @ctr		INT
DECLARE @diff		INT

DECLARE @days TABLE (
  WorkDay DATETIME PRIMARY KEY,
  WorkDayName VARCHAR(50),
  Counter INT
)

SELECT @StartDate = '2009-01-01'
SELECT @EndDate = '2009-01-07'
SELECT @diff = DATEDIFF(d, @StartDate, @EndDate)

SELECT @ctr = 0
WHILE @ctr <= @diff BEGIN
  INSERT INTO @days (
	WorkDay, 
	WorkDayName,
    Counter
  ) VALUES (
	@StartDate + @ctr, 
	LEFT(DATENAME(dw, @StartDate + @ctr), 3) + '. ' + LEFT(CONVERT(VARCHAR(8), @StartDate + @ctr, 1), 5),
	@ctr + 1
  )
  SET @ctr = @ctr + 1
END

SELECT *
  INTO #temp
 
  FROM @days d
  LEFT OUTER JOIN TimeSheetTest t
  ON d.WorkDay = t.DateWorked

exec UberCrosstab 
'EmployeeCode, ProjectCode',
'WorkDayName',
'#temp',
'HoursWorked',
'SUM'

drop table #temp