I too got the same error. thats y i posted.. 🙂

I will tell me exact requirement.. I want the columns A and C contain the same value. i actually had...

how come.. i am getting -1,0,1 only..

someone explain please

Isnt there a way to check any statistics to find the table that is frequently updated?

I too feel What Arjun suggests is correct. Timestamp will be modified whenever the row is updated. so the row containing the latest timestamp will be the recently modified\updated row....

sorry for the error.. error reproducible only on sql 2005.

please excuse.

Thanks Paul,

exactly what i was looking for..

Can you please elaborate how u solved?

i am also facing the same problem.. the return statement is causing the error message... :crying:

Welcome Sumantha.

Have a Great Day. 🙂

Try this

SET @SQL_COSTCENTER='SELECT COST_CENTER,'+ '''' + @VALID_FROM_DATE1+ ''''+' AS VALID_FROM_DATE ,CO_CODE,COST_CENTER_DESC,COST_CENTER_MGR FROM xyz WITH(NOLOCK) '

it should work 🙂

Panda can you please give some more sample code in the procedure to validate?

I tried and it just works fine.

you need to use quotes for datetime datatype

Yet another way 🙂

select A.* from emp A

where A.datett=(select max(C.datett)

from emp C

where A.eid = C.eid

and C.datett <= '06/06/2006'

)

and exists

(

select '' from emp B

where A.eid = B.eid

and B.act='Y'

)

Guys, Have i confused you with my question..

Let me elaborate..

Let us assume, we have 10 SQL named users.. All of them with dbadmin privilege..

I am the system administrator

I prefer not...

Another way is to check when the tempdb is created..

PS: Tempdb is recreated whenever the server is started..

select create_Date from sys.databases

where name = 'tempdb'

One more point, Tempdb is created...

I have an idea.. but not sure how this will workout...

u can write a trigger on one of the tables, so that on update\insert\delete on that table , the other...

wonderful... it is really usefull..