convertion nvarchar to numaric error please

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 EXISTS (SELECT DCM_ConsumerID FROM [DataConsumerMaster] WHERE DCM_DeptName =@DCM_DeptName)
--Then
if(@@ROWCOUNT>0)
--SET @output=
--PRINT convert(varchar(30), @output)
--RETURN @output
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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Senthil Kumar5y ago
for your query SCOPE_IDENTITY() return numeric values only. One of solution convert SCOPE_IDENTITY() to varchar as like that 'CM000'+ Convert(Varchar(50), SCOPE_IDENTITY())
Jignesh Kumar5y ago
Hi,

You need to convert SCOPE_IDENTITY() value as nvarchar because you have declare as nvarchar,
Select @consumerid= 'CM00'+ CAST(SCOPE_IDENTITY() AS nVARCHAR)