in this Ounsumer id i got convertion nvarchar to numaric error please any body help
- Alter Procedure [dbo].[Proc_ConsumermasterInsert1]
- (@DCM_DeptName nvarchar(100),
- @DCM_Address varchar(200),
- @DCM_MobileNumber varchar(20),
- @DCM_CEOName varchar(50),
- @DCM_EmailID varchar(50),
- @DCM_DeptDescription varchar(200),
- @DCM_AddedBy int,
- @DCM_AddedIPAddress varchar(50),
- @DCM_Remarks varchar(50),
- @DCM_Abbrivation char(5),
- @DCM_CategoryAgencyId int,
- @DCM_ContactPersonName varchar(100),
- @DCM_ContactPersonMobileNumber varchar(15),
- @DCM_ContactPersonEmailID varchar(50),
- @DCM_ContactPersonLandLineNumber varchar(20)
- )
- as begin
- DECLARE @consumerid nvarchar(20)
- Declare @output nvarchar(max)
-
- BEGIN TRANSACTION;
- insert into [dbo].[DataConsumerMaster] (DCM_DeptName, DCM_Address, DCM_MobileNumber, DCM_CEOName, DCM_EmailID, DCM_DeptDescription,
- DCM_DataConsumer, DCM_AddedOn, DCM_AddedBy, DCM_AddedIPAddress, DCM_Status,DCM_Remarks,DCM_EntryMode, DCM_Abbrivation,DCM_CategoryAgencyId,
- DCM_ContactPersonName,DCM_ContactPersonMobileNumber,DCM_ContactPersonEmailID,DCM_ContactPersonLandLineNumber)
- values(@DCM_DeptName, @DCM_Address, @DCM_MobileNumber, @DCM_CEOName, @DCM_EmailID, @DCM_DeptDescription,
- 'A', getdate(), @DCM_AddedBy, @DCM_AddedIPAddress, 'A',@DCM_Remarks,'D',@DCM_Abbrivation,@DCM_CategoryAgencyId,
- @DCM_ContactPersonName,@DCM_ContactPersonMobileNumber,@DCM_ContactPersonEmailID,@DCM_ContactPersonLandLineNumber)
- Select @consumerid= 'CM00'+ SCOPE_IDENTITY()
-
-
- if(@@ROWCOUNT>0)
-
-
-
- Insert into Login88(Password,UserName,Officer_Name,Officer_Mobile,Email_ID,Type_Of_User,Status,Date_of_Creation,created_by,Date_of_Modification,Roles)
- Values('ov2FeiYRwvE=',Convert(nvarchar(50), @consumerid) ,@DCM_CEOName,@DCM_MobileNumber,@DCM_EmailID,4,'Approved','',@DCM_AddedBy,'','C')
- Commit TRANSACTION;
- END