C#:
declare @calctype int = 5
select @calctype = option from table_1 where optionvar = 'type'
Is your grammar correct?
===>
(case when (select CAST(option AS int) from table_1 where optionvar = 'type') = 1 then
abs(round(dm.value, (select CAST(option AS int) from table_1 where optionvar= 'rawdlen' ) ))
else
round(dm.value, (select CAST(option AS int) from table_1 where optionvar = 'rawdlen' ) ) end)
How do I change it ( initial value =5) ? (declare @calctype int = 5)
How do I change it ( initial value =5) ? (declare @calctype int = 5)
Last edited: