hi
below is my query ..it is running very slow ..can we optimize it.
thaxn
Update pruamc.Tbl_CAMS_UploadDetails
set Compare_Status='Success',additionalfield100=
(select file_name from Tbl_CMS_UploadMaster A,Tbl_CMS_UploadDetails B where A.cms_upload_master_id =B.cms_upload_master_id and B.CMS_Upload_Details_ID=@.CMS_Upload_Details_ID),
ManualMatchingStatus='1',ReconciliationDate=convert(datetime,cast(getdate()as varchar(11)),103)
where CAMS_Upload_Details_ID=@.CAMS_Upload_Details_ID
The following query may increase the performance,
Code Snippet
Declare @.FileName as varchar(100);
Select @.FileName = file_name from Tbl_CMS_UploadMaster A
Join Tbl_CMS_UploadDetails B On A.cms_upload_master_id =B.cms_upload_master_id
and B.CMS_Upload_Details_ID=@.CMS_Upload_Details_ID;
Update
pruamc.Tbl_CAMS_UploadDetails
Set
Compare_Status='Success'
,additionalfield100=@.FileName
,ManualMatchingStatus='1',ReconciliationDate=convert(datetime,cast(getdate()as varchar(11)),103)
Where
CAMS_Upload_Details_ID=@.CAMS_Upload_Details_ID
|||thanx mani
let me check..i will back.
