I will have to update the indicator flag to Y only if the insuranceamt is all 9's or all 1's as below:
declare @t1 table
insert into @t1
--sample needed data
9998.9999 N --(as it has 8 and all are not 9's)
I am actually trying to do it in SSIS using SSIS expressions, however if we have the logic in T-SQL i will try to do the same in SSIS as well.
Thanks for all the responses.
View Complete Post