Hi Adi, thanks for the quick reply

But even that '1' (in my example) is a noise word, the fts should return me all the "company xpto" ... am i...

Hello again,

No is not, unfortunalty...

Hello again,

First to Ninja's_RGR'us:

We try this

begin tran

insert into table (columns) Select columns, parameters where not exists (check exists on base table here)

commit tran

and the same thing happens, few less times,...

Hi again,

How are u since yesterday 🙂

With the trans in the places the duplicate rows still appear...

Hi again,

How are u since yesterday 🙂

With the trans in the places the duplicate rows still appear...

Before i test ur new tip ( and i have to thanks again, for dont give up 🙂 ), we put the begin trans in the beginiing of the procedure......

yes i try with the altered insert... but same thing occours...

declare @p21 int

set @p21=1

declare @p22 int

set @p22=4135805

exec CentralSaveContactPoint @Form=4,@Name=N'José XXXX',@Phone=N'xxxxxxx',

@Email=N'jxxxxxxx9@gmail.com',@Obs=N'comments',@Portal=1,@Origin=0,@EstateID=741636,

@Business=0,@Nature=0,@PropType=0,@Town=0,@MaxPrice=0,@ClientID=0,@BPI=0,@Lang=0,

@FoundInPage=0,@TotalPages=0,@FromWhere=1,@UserIP=N'00.000.000.00',

@RowCount=@p21 output,@ScopeIdentity=@p22 output

select @p21, @p22

go

declare @p21 int

set @p21=1

declare @p22 int

set @p22=4135806

exec...

i put the profiler running and i catch another duplicated insert...

declare @p21 int

set @p21=1

declare @p22 int

set @p22=4135805

exec CentralSaveContactPoint @Form=4,@Name=N'José XXXX',@Phone=N'xxxxxxx',@Email=N'jxxxxxxx9@gmail.com',@Obs=N'comments',@Portal=1,@Origin=0,@EstateID=741636,@Business=0,@Nature=0,@PropType=0,@Town=0,@MaxPrice=0,@ClientID=0,@BPI=0,@Lang=0,@FoundInPage=0,@TotalPages=0,@FromWhere=1,@UserIP=N'00.000.000.00',@RowCount=@p21 output,@ScopeIdentity=@p22 output

select @p21, @p22

go

declare @p21 int

set @p21=1

declare @p22 int

set @p22=4135806

exec...

Hello again,

no worries for the replies... ehehe, i was looking, and no parameter can be null, the maximum is '' 🙂

I understand what u said on the last reply, but...

Hi again,

i can't see where that appears, can u tell me here in sp?

Regards

Hello Chris, first of all, i want to thank you for keeping help me...

CREATE PROCEDURE [dbo].[CentralCheckDuplicate]

@NameAS VARCHAR(4000),

@PhoneAS VARCHAR(4000),

@EmailAS VARCHAR(4000),

@ObsAS VARCHAR(4000),

@EstateIDAS INT

AS

SET NOCOUNT ON

--IF(EXISTS(SELECT ID FROM CONTACTS WHERE [NAME]=@Name...

Hi again,

I see now that the problem is that in sometimes the app call the sp two times, but even in that way, the database shouldnt let the row be...

Just when the sp is run from app...

hi,

There is no trigger here, this sp is called from application, but even if the sp is called 2 times, i have a validation in sp that checks if there...

CREATE PROCEDURE [dbo].[xxxx]

@FormAS INT,

@NameAS VARCHAR(4000),

@PhoneAS VARCHAR(4000),

@EmailAS VARCHAR(4000),

@ObsAS VARCHAR(4000),

@PortalAS INT,

@OriginAS INT,

@EstateIDAS INT,

@BusinessAS INT,

@NatureAS INT,

@PropTypeAS INT,

@TownAS INT,

@MaxPriceAS MONEY,

@ClientIDAS INT,

@BPIAS INT,

@LangAS INT,

@FoundInPageAS INT,

@TotalPagesAS INT,

@FromWhereAS INT,

@UserIPAS VARCHAR(4000),

@NeighborhoodAS VARCHAR(4000) = NULL,

@RowCount as int...