sql - Inserting a value into a field unless that field have a value of 'X' then inserting another value instead -

sql - Inserting a value into a field unless that field have a value of 'X' then inserting another value instead -

so have store procedure trying write (see below) want 3rd field in insert statement (orgsqenno) want insert value of orgsqenno unless value 0 want insert sqen value instead. think need utilize exists or null cause no sure best way go this.

( @seqn int , @updated_by varchar(15) ) begin -- set nocount on added prevent result sets -- interfering select statements. set nocount on; declare @new_seqn int exec sp_asi_getcounter2 'gt_investment', @new_seqn output insert [gt_investment] ([id],[seqn],[orgsqenno], orgpaymentdate, investamnt, investmentdate) select [id], @new_seqn, [orgsqenno], orgpaymentdate, (investamnt+totalinterest), matdate [gt_investment] seqn = @seqn end

thanks in advance everyone's help

you can utilize next query insert statement

insert [gt_investment] ([id],[seqn],[orgsqenno], orgpaymentdate, investamnt, investmentdate) select [id],@new_seqn , case [orgsqenno] when 0 @seqn else [orgsqenno] end , orgpaymentdate, (investamnt+totalinterest), matdate [gt_investment] seqn = @seqn

sql