After executing below query am getting some error..
declare @emp varchar(50)
declare @oldfscode varchar(50)
declare @newfsname varchar(50)
declare @fstype varchar(50)
declare @parentcode varchar(50)
declare @areaname varchar(50)
declare @areacode varchar(50)
declare @parentype int
declare @grade varchar(50)
declare @qual varchar(50)
declare @add1 varchar(50)
declare @add2 varchar(50)
declare @add3 varchar(50)
declare @add4 varchar(50)
declare @pin char(50)
declare @phone char(50)
declare @email varchar(50)
declare @div char(50)
declare @newcode varchar(50)
declare @desg varchar(50)
declare toupdate cursor for
select
empcode,fscode,fsname,type,parentcode,area,areacode,parenttype,grade,qual,add1,add2,add3,add4,pin,phone,email,div
,newcode,todes from r
open toupdate
fetch next from toupdate into
@emp,@oldfscode,@newfsname,@fstype,@parentcode,@areaname,@areacode,
@parentype,@grade,@qual,@add1,@add2,@add3,@add4,@pin,@phone,@email,
@div,@newcode,@desg
while @@FETCH_STATUS=0
begin
update Tbl_FS_Mst set C_Name='vacant - '+' '+@desg+' '+'('+@areaname+')',C_EmpNo='000000' where C_Code=@oldfscode
update tbl_fs_emp_rel set d_date_to='2015/03/03' where c_fs_code=@oldfscode
insert into Tbl_FS_Mst
select @newcode,@newfsname,@fstype,@grade,@qual,@add1,@add2,@add3,@add4,@pin,@phone,
'','',@areacode,@parentcode,@emp,'','','','',0,@email,0,GETDATE(),GETDATE(),'admin',@parentype,@div
insert into tbl_fs_emp_rel select @newcode,@emp,GETDATE(),null,GETDATE()
update Tbl_Doc_Stock_Chem_Add_Mst set C_FsCode=@newcode where C_FsCode=@oldfscode
update Tbl_Cust_Div set c_fs_code=@newcode where c_fs_code=@oldfscode
update Tbl_STP set C_FS_Code=@newcode where C_FS_Code=@oldfscode
fetch next from toupdate into
@emp,@oldfscode,@newfsname,@fstype,@parentcode,@areaname,@areacode,
@parentype,@grade,@qual,@add1,@add2,@add3,@add4,@pin,@phone,@email,
@div,@newcode,@desg
end
close toupdate
deallocate toupdate
Error will be shown like this
An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown.