Omg this post has gone in a totally different direction to what I originally planned to ask. Please let me explain it again.
i have a table. one column is email addresses. the other is url's
the email addresses columns is about 5.000 rows, of course all with unique email addresses
the url column has maybe 800 unique urls, so many rows will be the same
Now what i need is to create sort of temp table within the SP with also 2 fields.... url and a field named bcc.
The BCC field will contain all the email addresses from the other table that have the
same url
So for example: if url
http://www.something.com has 300 rows or email addresses, in the new table it would be one row with a field that has the 300 email addresses in them comma delimited.
After that i only want a max of 100 emails per record. so if
http://www.something.com has 300 emails associated with it, the end table would only have 3 records for
http://www.something.com. This is a ISP limitation for the BCC field. odd i know :(
My goal is to improve this process so that instead of sending 5000 individual emails i send 800 using BCC field.
Thank you and sorry for the confusion :)