AMD Operton 64

"Opteron"

i had the same problem once.

The problem might be wrong execution plans.

a)Sometimes query optimizer chooses wrong plans.

b)You might consider changing variable data types

(Because if the data type of the variable...

DELETE FROM TBL

where LogID not in

(

select top 5 LogID

from TBL

order by DateLogged desc

)

That script only decrypts a limited sized code. There is also a program which is capable of decrypting bigger scripts..

Encrption works but it is very easy to decrypt it...

There is a tsql script that decrypts it

create PROCEDURE sp_decrypt_sp (@objectName varchar(50))

AS

DECLARE @OrigSpText1 nvarchar(4000), @OrigSpText2 nvarchar(4000) , @OrigSpText3...

if columns have only A,B,C VALUES (Or limited variations)

if the problem is so simple; i offer u to use some kind of mathematical Total Approach.

Hope this Helps.

A=1

B=25

C=1000

select

ID,

CASE COL1

WHEN 'A'...

Generally speaking,

Using SCOPE_IDENTITY() function is much better than @@IDENTITY

because the table you inserted might have triggers and triggers may insert data to other tables having identity columns.

So You get...

@@rowcount may be effected by the changes in the trigger code of the table you updated