how to convert this access query to sql query
IIf([Total Bunches] > 0, Production * 1000 / [Total Bunches], 0) as Name2
SUM(IIf(BlockInYield = -1, [SIZE], 0)) as Name1
IIf(BlockInYield = TRUE, IIf(TC_M > 0, TC_M, TC_DENS *[SIZE]), 0) as Name
please......
case
when [Total Bunches] > 0 then Production * 1000 / [Total Bunches]
else 0
end
as Name2,
SUM(
case
when BlockInYield = -1 then [SIZE]
else 0
end
)
as Name1,
case when BlockInYield = 1 then (case when TC_M > 0 then TC_M else TC_DENS *[SIZE] end)
else 0
end
as Name
Thanks
Naras
|||There is no IFF operator in TSQL; as Naras is indicating the way to approach converting an IFF statement is to use an abstraction using CASE statements.sqlsql