Hi Jeff, just fyi, it's for a marketing application. We send promotion info to our users on a regular basis. Different promos are available to different number of users, and...

It does. Thanks!

I'm sorry, I don't get it...

Yeah! That does it!! 😀

Thanks, Jeff!!

Thanks, Lester!

It's great that I get the counts in the brackets now, but is there any way to have each fruit in it's own column? I'm not very good with...

Hi,

Thanks for the advice.

Just to share that somebody gave me this link and it worked perfectly:

     Processing The Same Row More Than Once

     (http://www.sqldts.com/default.aspx?266)

I have yet...

Yeah, Grasshopper! That's it!

A simple and elegant solution.

Thank you very much.