sqldba20 (2/20/2014)
It is only for display purpose in reporting because the user doesn't want to see 4 rows for each record if there are 4 email ids for that AID.
So, do you need more help? Or can you find a solution from the article on your own?If you get the solution on your own, you'll learn more than getting the answer already processed.