Thanks for the response guys. I really appreciate it. So to use the containstable will just be as easy as replacing the word freetexttable with containstable and removing the '5'....

Thanks for your help. It is appreciated !

Thanks for your response, I changed the values and purged the history and there are still some timeouts. Any other reason? Beats me. Thanks again!

Understood. I have definitely learnt a lot from you today. Thanks again

Right on the money. I really appreciate your input. So just pretty much the same thing but include all the 3 columns in the "partition by". Sweeet. You are the...

Hey Lynn, the CTE was actually a nice way to get it to work. I also noticed something strange with this as well. If I select top 1000, i get...

This is truly a very strange scenario, I have tried all the codes and I still get the same error, the one with the coalesce did eliminate the WARNING error...

Thanks for the suggestion. I even did the real total for the top 2 only..surely the figures can't be bigger than money datatype. What makes it even stranger is that...

Hey Lynn, thanks for the help. I checked the data already, it has some nulls in it. Coalesce and isnull should fix this, tried both but still getting the same...

still getting the same error, I wonder what is going on, the money to money and varchar conversion are for formatting and reporting purposes ( i know i know let...

Wow, that was money. Does it also take into consideration that the same time last year would have a different date (-1).

how do i tweaak it to return the...

Worked fine, you are right Jeff. Thanks guys !!

Thanks for the feedback, it worked fine. I just need one more modification. What if the same tables do not return the same number of columns, is it possible to...