--Create a work table

Create table #Accounts

(

Accounts varchar(25)

,Revenue INT

)

--Populate the table with data:

Insert into #Accounts

(

Accounts

,Revenue

)

Select

Accounts

,Revenue

from

(

select 'Account1' as Accounts, 100 as Revenue

union all

select 'Account2' as Accounts, 200 as Revenue

union...

Luis Cazares (10/3/2014)

---

Not underestimating adaddio's solution which is the base for my solution, I just made some changes. Using a recursive query as a counter is a bad idea and...

Based on the limited info you've provided...hopefully this helps...

--Build a temp table to hold the contact ID

Select

--1 as ID

contacts.id

into #TempContactID ...

Try this. I changed some of your test data a bit but based on the test data I created it seems to work. Note...I only tested this on a 2...

--Build a simple 1 record test table

Select

'Sample@Email.com' as Email

into #TempEmail

--Create a variable to hold the recipient of the email

Declare @recipients varchar(100)

--Populate the variable

Set@recipients = (Select Email from #TempEmail)...

Follow what Shawn Melton said about how to set up a data connection in Excel to a SQL stored procedure.

The data will then display as a table in your...