Hi ,
I found that your given query contains syntax error..
update tbl_fs_mst set d_date_from=isnull(SELECT MAX(D_DATE_REPORT) FROM TBL_DWR WHERE C_FS_Code=@oldfscode),'2015/02/01')
you missed parenthesis in your query , so the corrected query is..
update tbl_fs_mst set d_date_from=isnull((SELECT MAX(D_DATE_REPORT) FROM TBL_DWR WHERE C_FS_Code=@oldfscode),'2015/02/01')
just try this...
Thanks
Magesh M