Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
update #allbiddetail
set Flagdetail
where BidRequestIdBidRequestId
return
end
end
if @BidRequestType'ADD'
begin
exec DOTspDOTBidEngineFAValidatePairingAdd @pEmployeeNumber,@pPairingNumber,@pPairingDate,@BidDetailId,@BidCycleMonth,@BidRequestId
end
update #allbiddetail
set Flagdetail where BidDetailId @BidDetailId and BidRequestId @BidRequestId
end
update #allrequest
set flag where BidRequestId @BidRequestId
end
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started