CREATE TABLE BusinessCase(
	ID uniqueidentifier,
	CountItem int,
	OneTime int,
	Periodic int,
	WorkID uniqueidentifier,
	BudgetID uniqueidentifier)

select 'Итого расход' as Name,
cast(sum(
case CostItemID 
	when '6F274CE0-4048-4A35-AD3E-028B56EA4D79' then 
		case HatBusinessCase.TypeProject 
			when 1 then 
				case 
					when BusinessCase.CountItem > 1000 then isnull(BusinessCase.OneTime,0)*1.5*BusinessCase.CountItem 
					when BusinessCase.CountItem <= 1000 then isnull(BusinessCase.OneTime,0)*1.5*1000
					when BusinessCase.CountItem <= 0 then 0
				end 
				else
				case 
					when BusinessCase.CountItem > 1000 then isnull(BusinessCase.OneTime,0)*BusinessCase.CountItem
					when BusinessCase.CountItem <= 1000 then isnull(BusinessCase.OneTime,0)*1000
					when BusinessCase.CountItem <= 0 then 0
				end
		end
	when '664DF384-ED0E-4DB1-AD79-14F523A42C0F' then 
		case HatBusinessCase.TypeProject 
			when 1 then 
				case 
					when BusinessCase.CountItem > 1000 then isnull(BusinessCase.OneTime,0)*1.5*BusinessCase.CountItem 
					when BusinessCase.CountItem <= 1000 then isnull(BusinessCase.OneTime,0)*1.5*1000
					when BusinessCase.CountItem <= 0 then 0
				end 
				else
				case 
					when BusinessCase.CountItem > 1000 then isnull(BusinessCase.OneTime,0)*BusinessCase.CountItem
					when BusinessCase.CountItem <= 1000 then isnull(BusinessCase.OneTime,0)*1000
					when BusinessCase.CountItem <= 0 then 0
				end
		end	
	when 'E7E07D9E-C970-4CE1-BDD6-1A33124667C1' then
		case 
			when BusinessCase.CountItem > 0 then 500000 
		end
	else isnull(BusinessCase.OneTime,0)*BusinessCase.CountItem
end
) as varchar(10)) as OneTime,
cast(SUM(isnull(BusinessCase.Periodic * BusinessCase.CountItem, 0)) as varchar(10)) as Periodic, 2 as Result
from BusinessCase
LEFT OUTER JOIN
	HatBusinessCase AS HatBusinessCase ON HatBusinessCase.WorkID = BusinessCase.WorkID
where BusinessCase.WorkID = '2BCD4225-FAB8-4F4D-A598-27D386661067' and BusinessCase.BudgetID = '5CC0B805-496B-49AC-9140-3980A757C725'
union all
select 'Text' as Name, 'Окупаемость - ', 'Рентабельность - ' + ' %.', 4 as Result