Please provide a sample data of the data you would like to see in the resultset.

As mentioned above; please provide some sample data.

This looks like SP2 issue. Did u install service pack 2. I have seen it happen when the client and the server have different service packs installed.

Something like below should work:

select t1.Cburg,t2.Hburg,t3.Bmac,t4.Soda

from table1 t1 inner join table2 t2 on t1.BK_ID=t2.BK_ID

inner join table3 t3 on t2.BK_ID=t3.BK_ID

inner join table4 on t3.BK_ID=t4.BK_ID

Yes if you can provide me that.

Do u mean performance of the table after deletion or during Deletion????

Use Truncate instead of Delete as Pradeep has mention it's much faster..

It's worth checking the indexes after the...

Worth checking if the indexes need rebuilding or reorganising after the Deletion..

-- CHECK if the indexes need reorganising

DECLARE @db_id SMALLINT;

DECLARE @object_id INT;

SET @db_id = DB_ID(N'@dbname');

SET @object_id = OBJECT_ID(N'@dbname.dbo.@tablename');

IF @db_id IS...

Please run the below to see how the indexes are for that table. Also, worth looking at the execution plan of the Update script.

Check to see if it needs reorgainising.

DECLARE...

Guys,

I didn't explain it right in my previous post. My bad.

the problem was resolved by restarting the sql server.

We've run dbcc checkdb with estimateonly on the client server to...

Please provide us with ur table structure; and the Update Query that you are using.

Check if the indexes need reindexing or reorganising on the table.

We resolved our deadlocks problems by setting the following

ALTER DATABASE @dbname SET ALLOW_SNAPSHOT_ISOLATION ON;

ALTER DATABASE @dbname SET READ_COMMITTED_SNAPSHOT ON;

What datatype is duedate?

misunderstood ur question, rank() ,row_number() will work better in this case.

You can use substring, Charindex

I think u've understood it right..

Your select statement gives me following error messages:

Msg 8114, Level 16, State 1, Procedure ee_updateStatus, Line 0

Error converting data type varchar to datetime.

Msg 8114, Level...