I had an interesting challenge this week where I needed to turn rows of email addresses into a crosstab or a single column so I could use it to send out emails. I had to do this at a grouped level for different companies and there may be from 1-5 different email addresses. Here is the SQL solution.<\/p>\n
Then I use coldfusion to create a mail link but you can use any tool that allows you to format the mail to parameter with the new rep_email values. I had an interesting challenge this week where I needed to turn rows of email addresses into a crosstab or a single column so I could use it to send out emails. I had to do this at a grouped … Continue reading
\nSELECT DISTINCT company, C.rep_email
\nFROM #emails
\nCROSS APPLY<\/strong>
\n(
\nSELECT [rep_email] + ';' -- semi colon separator
\nFROM ###emails# E
\nWHERE E.company=#emails.company
\nFOR XML PATH('')
\n) C(rep_email)
\n<\/code><\/p>\n
\nI looped through each company and created a mail link for my app, but could have sent out all the emails at once if I had desired. <\/p>\n","protected":false},"excerpt":{"rendered":"