almost there , but the implicit mode would not create 3 transactions , just one transaction - you need to commit the whole transaction just once..

Personally i use explicit transactions...

run this to disable a trigger

ALTER TABLE <TableName>

DISABLE TRIGGER <TriggerName>

and this to enable it

ALTER TABLE <TableName>

ENABLE TRIGGER <TriggerName>

how are you executing the procedure?!!

are you sure this isnt behind a firewall?!!

use the IP<your ip>,SERVER PORT<1433> as the servername

ok !! first of all i suggest you use a stored procedure to return your result set

however there is a way to return a serial number with a resultset ,...

try this

CREATE PROCEDURE Usp_ReturnRowCount(@SqlStr varchar(8000),

@RwCnt int OUTPUT)

AS

SET NOCOUNT ON

DECLARE@StrPosint

CREATE TABLE #Rslts

(

RwCntint

)

SET @StrPos = CHARINDEX ('FROM',@SqlStr)

SET @SqlStr = SUBSTRING(@SqlStr,@StrPos,LEN(@SqlStr))

SET @SqlStr = 'SELECT COUNT(*) ' + @SqlStr

INSERT INTO #Rslts

EXEC (@SqlStr)

SELECT...

SELECT *

FROM Table

INNER JOIN

(

SELECT Val11 As Col1,

Val12 As Col2

UNION ALL

SELECT Val21,

Val22

) As RS ON Table.Col1 = RS.Col1 AND Table.Col2 = RS.Col2

basically what vyas suggested but without the temp table and...

Hi ,

i'm sorry , i can't quite follow you , are you talking about some front-end replace problem!?!

This seems to work fine ,

DECLARE @Var varchar(10)

SET @Var = 'TEST' + Char(39) + 'TEST'

PRINT @Var

SET @Var = REPLACE (@Var,CHAR(39),CHAR(39)+CHAR(39))

PRINT @Var

CHAR(39) is the ASCII Value for single quote

are...

sp_cursor_list is what you are looking for.

alternatively, if you want to maintain the numbers yourself then this update should work

DECLARE @IncNo

SET @IncNo = 0

UPDATE <Table>

SET @IncNo = <Column> = @IncNo + 1

you seem to be storing the dates as character values . use MAX(CONVERT(Datetime,value))

have you checked for recursive triggers in the second procedure!!?

Antares,

you are right it should be OR instead of AND , my mistake

and it should be ISNULL(Col,DATEADD(dd,1,@DateVar)) <> @DateVar

but did not understand what you mean by

...