use t25d001
select * from opening_challan_received_from_job where challanno='40125#'

----check Job Send Sr No (-)
select * from send_to_job_item_detail where recsrno+':'+convert(varchar(255),lotno) in (
SELECT     OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.SrNo+':'+convert(varchar(255),OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.LotNo)
FROM         OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL INNER JOIN
                      OPENING_CHALLAN_RECEIVED_FROM_JOB ON OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.SrNo = OPENING_CHALLAN_RECEIVED_FROM_JOB.SrNo
WHERE     (OPENING_CHALLAN_RECEIVED_FROM_JOB.ChallanNo = '40125#')
) 

---- Run In Firm 
UPDATE SEND_TO_JOB_ITEM_DETAIL Set RecSrNo=T1.F1, RecISrNo = T1.F2 FROM (
                        SELECT OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.SrNo AS F1, OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.ItemSrNo AS F2, OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.ItemName AS F3, OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.LotNo AS F4, OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.StockType AS F5 FROM OPENING_CHALLAN_RECEIVED_FROM_JOB INNER JOIN OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL ON OPENING_CHALLAN_RECEIVED_FROM_JOB.SrNo = OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL.SrNo
                        ) AS T1 WHERE StockType COLLATE DATABASE_DEFAULT = T1.F5 AND LotNo = T1.F4 AND LEFT(LotNo,1) = '9'