Thanks a lot sir. but when can i delete the records in the table..should i delete them by end of the day...

Does the Size matters in SSRS

As it would be System.String data type only right

Does the Size matters in SSRS

As it would be System.String data type only right

Ok thanks for the replies...how to check if the stored procedure has to be changed or not...

I am sorry but am trying to insert the newid value into the column in a sql server table....

I have to redesign the Database...To do that first i have to identify the Risk Analysis of the current database.....

So i would like to know the steps required to perform...

Thanks so much everyone... i got the result.

Thanks a lot for the quick reply Evil Kraig.

I have tested the query provided by you it works fine for the first and third record but the output for second...

thank you so much it worked fine

Could someone please help me with the Stored Procedure...

I am sorry everyone... I cannot post more Information...

I know it is hard to reply with answer without proper information....but i cannot post more Information...

If it's related to blocking..Do you...

Oh ok, But am sorry i cannot even post the execution plan....

But i see execution plan is same

It doesn't matter because I created a new temp table with the same structure and load the same 456 rows and it takes the same time....

I am very sorry for the late reply

I have found the reason...

Problem is with Index and I rebuild the index and it worked fine...

thanks for the reply but below are my findings

I have execute the below query

DBCC showcontig('tablename')

and it gets the result as below

- Pages Scanned................................: 13123

- Extents Scanned..............................: 1641

- Extent Switches..............................:...