Question: if @BidRequestType = 'Drop' begin declare @outputValue 1 varchar ( 5 0 ) , @BidRequestIdoutput 1 int EXEC [ DOT ] . [ sp _
if @BidRequestType'Drop'
begin
declare @outputValue varchar@BidRequestIdoutput int
EXEC DOTspDOTBidEngineFAValidatePairingDrop @pEmployeeNumber,@pPairingNumber,@pPairingDate,@BidDetailId,@BidCycleMonth,@BidRequestId,@BidRequestType,@outputValue@outputValue OUTPUT,@BidRequestIdoutput@BidRequestIdoutput output 'Fail UpdatepreviousDetailfailed'
if @outputValue'Fail UpdatepreviousDetailfailed'
begin
update DOTBidAward
set bidawardstatus'Fail'
where requestid@BidRequestIdoutput
return
end
end
update #allbiddetail
set Flagdetail where BidDetailId @BidDetailId and BidRequestId @BidRequestId
end
update #allrequest
set flag where BidRequestId @BidRequestId
end
problem i am facing is
if @outputValue'Fail UpdatepreviousDetailfailed'
if above if condiiton is satisfied sql code enters update statement and update bid award status and return
so return statements exits the code
and below updates are not getting exexuted
i want that after return that below code also runs
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
