select b.bidId as sourceBidId, b.bidName, bl.dateCreated, imp.* from tbl_IMPORT_BidSpec imp with (nolock) inner join tbl_BID_BidLines bl with (nolock) on bl.ownerId = imp.ownerId and bl.ownerType = imp.ownerType and bl.bidLineId = imp.bidLineId inner join tbl_BID_Bids b with (nolock) on b.ownerId = bl.ownerId and b.ownerType = bl.ownerType and b.bidId = bl.bidId where imp.eai_batchId = order by sourceBidId select bidId, bidLineSortNumber, bidLineNumber, bidLineDescription, bidLineQtyAmt, bidLineQtyUM, newSpecification, brandRequirements, nutritionalsRequired, shipDirect, confidentialComment, grade, sampleDeliveryDateTime, sampleRequired, sampleUnits, sampleMarkings, sampleComments from tbl_BID_BidLines with (nolock) where bidLineId = UPDATE bl SET bl.bidLineSortNumber = , bl.bidLineNumber = , bl.bidLineDescription = , bl.newSpecification = , bl.bidLineQtyAmt = , bl.bidLineQtyUM = , bl.brandRequirements = , bl.nutritionalsRequired = , bl.shipDirect = , bl.confidentialComment = , bl.grade = , bl.sampleDeliveryDateTime = , bl.sampleRequired = , bl.sampleUnits = , bl.sampleMarkings = , bl.sampleComments = FROM tbl_BID_BidLines bl WHERE bl.ownerId = AND bl.ownerType = AND bl.bidId = AND bl.bidLineId =

#bidName# (#sourceBidId#)
#lineNumber# #lineDescription# #qty# #qtyUM#	#qmd_restoreBidLine.bidLineNumber# #qmd_restoreBidLine.bidLineDescription# #qmd_restoreBidLine.bidLineQtyAmt# #qmd_restoreBidLine.bidLineQtyUM#	Successfully Updated	Unavailable. This line was created on #dateFormat( dateCreated, 'mm/dd/yyyy' )#	Unsuccessfully Updated