Hello Lowell,

Thanks for the help. I have managed to get it working perfectly now.

Many Thanks

I like it!

Will try and slot my info in now..

Thanks Lowell.

Hello All,

Right I've fixed this bit:

Hello @staff --My @staff variable is not being entered here

by changing to:

OPEN email_cursor

FETCH NEXT FROM email_cursor

INTO @toemail, @staff

WHILE @@FETCH_STATUS...

Awesome that works.

Many Thanks

Thanks Anthony and Mike I now have a working solution.

DECLARE @toemail varchar(150), @job_detail varchar(300), @body varchar(400)

DECLARE email_cursor CURSOR FOR SELECT email, RTRIM(job_name) +' '+ RTRIM(short_desc) as job_detail FROM vw_expiring_jobs

OPEN email_cursor

FETCH...

Hello Michael,

I tried DECLARE email_cursor CURSOR FOR SELECT email, @job_detail = RTRIM(Job_name) +' '+ RTRIM(short_desc) FROM vw_expiring_jobs

but recieve an error stating I can't set variables within a CURSOR?

How else can...