That means that a code that worked well in 2000 can go haywire in 2008. What makes it happen so?? is it the engine? so, it is not some sort...

Yes. We have rebuit the indexes and updated the statistics.

Pramod

Sorry, i thought i had posted in the wrong forum. hence reposted it.

yeah... my bad.. i mistakenly wrote it 🙂 anyways... thanks a lot... i got the answer...

Thanks Sachin. This one is totally new to me 🙂

Thanks a lot guys. It really helped me a lot. It also helped me to completely understand the CTE Recursiveness.

Thanks again.

Pramod

Thanks a lot guys. It was very helpful of you all.

Pramod

See, i have a table which has

employeenumber, day1effort, day2effort, day3effort, day4effort, day5effort, day6effort, day7effort

This table has some 100 rows.

Now, we are calling the SP for each row and the...

Thanks a lot nabha. I didnt know that for even datetime convert, we can specify a format

Thanks once again...

Oops... I want it to be as 1 Dec 2009

Pramod

The insert doesnt happen until it gets the data from both the tables. I just had an experiment on that.

But, one thing i wanted to understand is why is it...

no no... You didnt get my question...

The order doesnt matter to me.

Just imagine that these are no hash tables and some lock is present in the temp3 table. So, what...

My Bad.

You are absolutely rt. Thanks for that... once again...

Pramod

The issue here is: I dont want to replace the original string. The second part is that i have some thousands of strings to be compared so, assigning the string...

Thanks a lot man... It helped.

Pramod