final solution:

I created a stored procedure of the query with an input parameter of @authoremail. This allowed me to set a string variable, @myquery, equal to the execute statement +...

Thanks for the replies. I will try a temp table.

I have removed code for the sake of simplification, that is why some parts are not there.

SAMPLE CODE:

declare @authoremail as varchar(80)

declare @authorhomeemail as varchar(80)

declare emcursor cursor

global

for

select distinct authorid, authoremail from authors

where authorid is not null and authoremail is not null

and authoremail not like '' and authorid...