Hi , please post the full code, im not to clear on your requirements.

DDL and example data would also be very helpful.

My favourite is the over eager virus scanner.

At a guess...

set Convert(uniqueidentifier, @Contract_ID) = NEWID()

should be

set @ContactId = Convert(varchar(100), NEWID() )

Can you post both query plans ?

In the meantime try using the "OPTIMIZE FOR" query hint , see if that helps

GaryMcAllister (9/2/2009)

---

Hmmmmm... maybe on occassions the spid->username map fails to write and the exception handing is allowing future transactions to continue..

I'll do some further digging..

Is there something fundamentally wrong with...

The trigger will be executed within the same context and transaction the DML that caused the trigger to fire. There must be something else happening.....

Unless you actively put procedures in place to log DML actions, then there is nothing captured.

Sorry.

Try this..

Drop function CutCsv

go

Create function CutCsv(@CSVString varchar(max))

returns table

as

return(

with Num1 (n) AS (SELECT 1 UNION ALL SELECT 1),

Num2 (n) AS (SELECT 1 FROM Num1 AS X, Num1 AS Y),

Num3 (n) AS...

Specify the column names like this

Select ID,max([1]) as col1 ,max([2]) as col2 ,max([3]) as col3,max([4]) as col4

from cteColTest

Its because of the duplication of criteria screwing over the dense_rank()

this should sort it

with cteTestWithRow(ID,Criteria,Value,Rown)

as

(

Select Id,

Criteria,Value,row_number() over (Partition by id order by...

Try This

with cteTest(ID,Value,RowN,Coln)

as

(

Select ID,

case when Coln =1 then Criteria else Value end,

dense_rank() over (partition by ID...

Hi ,

there could be many reasons for this , take a look at this article on how to post specifics

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Try this link

http://michaeldotnet.blogspot.com/2007/11/t-sql-hex-string-to-varbinary-improved.html

You dont have to , once they have gone out of scope they will automatically be dropped.

Knowing that do you still need...

when you use decimal(6,2) , you are asking for 6 digits OF WHICH 2 are to the right hand side of the decimal. So you cant store 37537 in...