sSqlAllocatedHours = "sp_selectAllocatedHours'" & strDate1 & "', '" & strDate2 & "', '" & strOrg & "', '" & strDept & "', '" & strTeam & "'"
set rsAllocatedHours = objConn.Execute(sSqlAllocatedHours)
strAllocatedHours = rsAllocatedHours("totalTime")

Alter Procedure sp_selectAllocatedHours
@date1 datetime,
@date2 datetime,
@profileorg varchar(255),
@profiledept varchar(255),
@profileteam varchar(255)
As
declare @sql varchar(512)

if (@profileorg <>  '')
	BEGIN
	set @sql = 'select sum(convert(decimal(10,4), b.hours)) as totalTime from profile as a inner join projecttime as b on (b.profileemail = a.profileemail)'

		if (@date1 <> '') and (@date2 <> '')
			BEGIN
			set @sql = @sql+ 'where b.workdate between @date1 and @date2'
			END

		if (@profileorg <> '') and (@date1 = '') or (@date2 = '')
			BEGIN
			set @sql = @sql + ' where a.profile_org = @profileorg'
			END

		if (@profileorg <> '') and (@date1 <> '') or (@date2 <> '')
			BEGIN
			set @sql = @sql + ' and a.profile_org = @profileorg'
			END

		if (@profileorg <> '') and (@profiledept <> '') 
			BEGIN
			set @sql = @sql + ' and a.profile_dept = @profiledept'
			END

		if (@profileorg <> '') and (@profiledept <> '') and (@profileteam <> '')
			BEGIN
			set @sql = @sql + ' and a.profile_team = @profileteam'
			END
	END
else
	BEGIN
	set @sql = 'select sum(convert(decimal(10,4), b.hours)) as totalTime from profile as a inner join projecttime as b on (b.profileemail = a.profileemail)'
	END

select @sql
return