Stubby Bunny (10/4/2013)

---

What I need to do is create a loop that loops through the data to produce an email to send out. the following is sample data. I need to do it in a way to send one email to a person istead of in the case below up to 3. I want to sumarize the informaiton then send out email. I could do with a cursor easy but I am dealing with thousands of records and a cursor would have negative performance on tables. My attempt would be to pick the issuedID first then put in a cursor and loop around the records conatating to a temp table then selecting from here. Just wna to know if there is an easier way to do what I want. Thanks

ISSUEDID EMAIL OVERDUE DtISsued ST ITem

3631 john.doe@mail1682013/04/19DG5N4G3 DELL PRECISION T3500

4324 john.doe2@mail382013/08/27CWJ0181145Y EPSON PROJECTOR EMP 50

4413 hjane.doe@mail1612013/04/26JDKXVV4 DELL PRECISION T3500

4413 hjane.doe@mail1612013/04/262Z1BLN5 DELL LATITUDE D630

4413 hjane.doe@mail1612013/04/2610Z2VJ6 DELL LATITUDE E6400

13581 henry.doe@mail2462013/01/31125R4L4 DELL LATITUDE E6400