Pessoal como faço para corrigir esse erro:
select tblWRIRecepcao.PK_Recepcao
as Recepcao,
tblWRITitulos.DataUltimoRegistro
as Data_Registro,
tblWRIReal.PK_Num_Livro
as Matricula,
tblWRIAtos.PK_SeqAto
as Ato,
tblWRINegocios.Descricao
asNegocio
from tblWRIRecepcao
inner
join tblWRIAtosTitulos
on tblWRIAtosTitulos.FK_tblWRIRecepcaoRecepcao
= tblWRIRecepcao.PK_Recepcao
inner
join tblWRITitulos
on tblWRITitulos.FK_tblWRIRecepcaoRecepcao
= tblWRIRecepcao.PK_Recepcao
inner
join tblWRIAtos
on tblWRIAtos.PK_Id
= tblWRIAtosTitulos.FK_tblWRIAtos_Id
inner
join tblWRIReal
on tblWRIReal.PK_Id
= tblWRIAtos.FK_tblWRIReal_Id
inner
join tblWRIAtosNegocios
on tblWRIAtosNegocios.FK_tblWRIAtos_Id
= tblWRIAtos.PK_Id
inner
join tblWRINegocios
on tblWRINegocios.PK_Id
= tblWRIAtosNegocios.FK_tblWRINegocios_Id
left
join tblWRIAtosParticipantes
on tblWRIAtosParticipantes.FK_tblWRIAtosNegocios_Id
= tblWRIAtosNegocios.PK_ID
where tblWRIReal.FK_tblWRILivro_Id
= 2
and
not tblWRINegocios.Negocio
in
( 456,
459, 586,
456, 898,
762,683,684,685,694,760,425)
and tblWRIAtosParticipantes.PK_ID
is
null
Msg 245, Level 16, State 1, Line 7
Conversion failed when converting the varchar value 'Direito de Habitação' to data type int.
MCP - MCTS - MCTS AD
