drop proc op_obtienesitenolista
go

create proc op_obtienesitenolista
@PRCLVLCUSTID ud_PRCLVLCUSTID
as

select siteid,NAME from site where status=1 and siteid not in (select siteid from op_prclvlcust where PRCLVLCUSTID=@PRCLVLCUSTID )

go

exec op_obtienesitelista 'RTRTRTRTRT'

exec op_obtienesitenolista 'RTRTRTRTRT'