Thanks Eugene, I think that explains it perfectly.

@Eirikur yes a join would have been more efficient but I was trying to understand this particular behavior and not focus on the...

I'm not sure if that will work since the text box is within a Group and there will be multiple text box on run time depending on the number of...

Thnx for the help.. The output is similar to what i was looking for..

🙂

Not technet, actually i was reading an article on sqlservercentral itself and that's where i found that code. Should have specified it earlier.

http://www.sqlservercentral.com/articles/SQL+Server+2008/62204/

No replies ????