Viewing 15 posts - 16 through 30 (of 40 total)
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...
April 21, 2009 at 8:25 am
Christopher Stobbs (11/19/2008)
IS this working with the change to the insert statement yet?
Hello again,
No is not, unfortunalty...
November 20, 2008 at 11:07 am
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,...
November 20, 2008 at 11:06 am
Hi again,
How are u since yesterday 🙂
With the trans in the places the duplicate rows still appear...
November 19, 2008 at 4:33 am
Hi again,
How are u since yesterday 🙂
With the trans in the places the duplicate rows still appear...
November 19, 2008 at 4:33 am
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......
November 18, 2008 at 8:36 am
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...
November 18, 2008 at 8:09 am
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...
November 18, 2008 at 7:55 am
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...
November 18, 2008 at 7:16 am
Hi again,
i can't see where that appears, can u tell me here in sp?
Regards
November 18, 2008 at 5:56 am
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...
November 18, 2008 at 5:37 am
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...
November 18, 2008 at 5:25 am
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...
November 18, 2008 at 3:35 am
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)...
November 18, 2008 at 3:14 am
Viewing 15 posts - 16 through 30 (of 40 total)