Msg 402 Error in Code SQL in Sql Server 2005 Enviroment
Am getting the following error message and do not understand why.
Msg 402, Level 16, State 1, Line 21 - The data types varchar and varchar are incompatible in the modulo operator. I have validated part of the code as indicated below. I am new to this enviroment so any explanation as to why the code is worng is greatly apprecieated
Code being used -
declare @tabtemp table (i int identity, sl_effected_user_id varchar(20)null)
declare @rows int
declare @var1 as varchar(20)
declare @query as varchar(8000)
insert into @tabtemp
select sl_effected_user_id
from table1
--------------------------
Select @rows = @@ROWCOUNT
While @rows >0
Begin
Select @var1 = sl_effected_user_id
from @tabtemp WHERE i = @Rows
set @query = '
insert into table3
select sl_id, sys_creation_date, operator_id, application_id, sl_app_id,
sl_effected_environment, sl_effected_profile_id, sl_effected_user_id,
sl_location, sl_event_description
from table2
where sl_effected_user_id like ('% +@var1+ ')
'
print @query
SET @Rows = @Rows -1
exec (@query)
END
Msg 402, Level 16, State 1, Line 21 - The data types varchar and varchar are incompatible in the modulo operator. I have validated part of the code as indicated below. I am new to this enviroment so any explanation as to why the code is worng is greatly apprecieated
Code being used -
declare @tabtemp table (i int identity, sl_effected_user_id varchar(20)null)
declare @rows int
declare @var1 as varchar(20)
declare @query as varchar(8000)
insert into @tabtemp
select sl_effected_user_id
from table1
--------------------------
Select @rows = @@ROWCOUNT
While @rows >0
Begin
Select @var1 = sl_effected_user_id
from @tabtemp WHERE i = @Rows
set @query = '
insert into table3
select sl_id, sys_creation_date, operator_id, application_id, sl_app_id,
sl_effected_environment, sl_effected_profile_id, sl_effected_user_id,
sl_location, sl_event_description
from table2
where sl_effected_user_id like ('% +@var1+ ')
'
print @query
SET @Rows = @Rows -1
exec (@query)
END
Who is Participating?
gin
Select @var1 = sl_effected_user_id
from @tabtemp WHERE i = @Rows
set @query = '
insert into table3
select sl_id, sys_creation_date, operator_id, application_id, sl_app_id,
sl_effected_environment, sl_effected_profile_id, sl_effected_user_id,
sl_location, sl_event_description
from table2
where sl_effected_user_id like (%' +@var1+ ')'
print @query
SET @Rows = @Rows -1
exec (@query)
END
Tags:
Select @var1 = sl_effected_user_id
from @tabtemp WHERE i = @Rows
set @query = '
insert into table3
select sl_id, sys_creation_date, operator_id, application_id, sl_app_id,
sl_effected_environment, sl_effected_profile_id, sl_effected_user_id,
sl_location, sl_event_description
from table2
where sl_effected_user_id like (%' +@var1+ ')'
print @query
SET @Rows = @Rows -1
exec (@query)
END
Tags:
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
-
Course of the Month11 days, 1 hour left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
insert into table3
select sl_id, sys_creation_date, operator_id, application_id, sl_app_id,
sl_effected_environment, sl_effected_profile_id, sl_effected_user_id,
sl_location, sl_event_description
from table2
where sl_effected_user_id like '+'''% '+@var1+ ''''