For one column I need some logic, return null in select

> can anyone see what's wrong with this:

You are missing the case END

my suggestion is to get your sql working first, and then put it into your sp.

Oh btw I'm trying some complex stuff but getting errors,can anyone see what's wrong with this:

declare @amount float
set @amount = (
case when @b = 'B' then
(select SUM(a) from t ) else

(select SUM(c) from t)
)

Worked a treat thanks

select case
when a = b then null
else a-c
end as d