|
|
UPDATE agentmaster set agentId='394395' WHERE agentName='IME Mobile'
select * from agentmaster where agentid=394449
SET IDENTITY_INSERT agentmaster ON;
insert into agentmaster(agentId,parentId,agentName,agentCode,agentAddress,agentCity,agentCountry,agentState,agentDistrict,agentZip,agentLocation,agentPhone1,agentPhone2,agentFax1,agentFax2,agentMobile1,agentMobile2,agentEmail1,agentEmail2,businessOrgType,businessType,agentRole,agentType,allowAccountDeposit,actAsBranch,contractExpiryDate,renewalFollowupDate,isSettlingAgent,agentGrp,businessLicense,agentBlock,agentCompanyName,companyAddress,companyCity,companyCountry,companyState,companyDistrict,companyZip,companyPhone1,companyPhone2,companyFax1,companyFax2,companyEmail1,companyEmail2,localTime,localCurrency,agentDetails,isActive,isDeleted,createdDate,createdBy,modifiedDate,modifiedBy,approvedDate,approvedBy,agentCountryId,headMessage,extCode,swiftCode,routingCode,mapCodeInt,mapCodeDom,commCodeInt,commCodeDom,joinedDate,isMigrated,mapCodeIntAc,mapCodeDomAc,payOption,agentApiType,isHeadOffice,routing,isInternal,cpEmail,agentSettCurr,contactPerson1,contactPerson2,latitude,longitude,agentAddress2,apiAgent,BANKCODE,BANKBRANCH,BANKACCOUNTNUMBER,ACCOUNTHOLDERNAME,IsIntl,IsDom,isApiPartner,branchCode,maxValue)select 394395,parentId,agentName,agentCode,agentAddress,agentCity,agentCountry,agentState,agentDistrict,agentZip,agentLocation,agentPhone1,agentPhone2,agentFax1,agentFax2,agentMobile1,agentMobile2,agentEmail1,agentEmail2,businessOrgType,businessType,agentRole,agentType,allowAccountDeposit,actAsBranch,contractExpiryDate,renewalFollowupDate,isSettlingAgent,agentGrp,businessLicense,agentBlock,agentCompanyName,companyAddress,companyCity,companyCountry,companyState,companyDistrict,companyZip,companyPhone1,companyPhone2,companyFax1,companyFax2,companyEmail1,companyEmail2,localTime,localCurrency,agentDetails,isActive,isDeleted,createdDate,createdBy,modifiedDate,modifiedBy,approvedDate,approvedBy,agentCountryId,headMessage,extCode,swiftCode,routingCode,mapCodeInt,mapCodeDom,commCodeInt,commCodeDom,joinedDate,isMigrated,mapCodeIntAc,mapCodeDomAc,payOption,agentApiType,isHeadOffice,routing,isInternal,cpEmail,agentSettCurr,contactPerson1,contactPerson2,latitude,longitude,agentAddress2,apiAgent,BANKCODE,BANKBRANCH,BANKACCOUNTNUMBER,ACCOUNTHOLDERNAME,IsIntl,IsDom,isApiPartner,branchCode,maxValuefrom agentmasterwhere agentid=394449
SET IDENTITY_INSERT agentmaster OFF
|
