thank you so much, sorry my pc was out of other so i couldnot check the code

thanks!:D

hello ALZDBA

please help me

hi

tested above code, its working perfect

results

======================

(5 row(s) affected)

ops10@merakdemo.com.com;it10@merakdemo.com

refno ben_name ...

please help me

i think there is some problem with this code/line

========

declare mail_merge2 cursor for select DISTINCT ops_manager_email + ';'+ it_manager_email ,email_body from mail_merge2

fetch next from mail_merge2 into @email_recepients, @email_body

============

we are decxlaring cursor...

same error

====================

(5 row(s) affected)

Msg 137, Level 15, State 2, Line 15

Must declare the scalar variable "@ops_manager_email".

Msg 137, Level 15, State 2, Line 18

Must declare the scalar variable "@ops_manager_email".

Msg 137, Level...

Dear when i execute i got this error

(5 row(s) affected)

Msg 137, Level 15, State 2, Line 14

Must declare the scalar variable "@ops_manager_email".

Msg 137, Level 15, State 2, Line 17

Must declare...

hello

thank you much for helping me

please help me in this code also,

=====purpose ==========

send the same mail to it manager and ops manager after 1 hour if the transaction are...

my Tables with sample records

=========================

user_info table structure

=====================

create table user_info

(

user_codeint,

supervisor_emailvarchar(40),

br_codeint

)

sample records

====================

insert into user_info values(100,'abc@merakdemo.com', 10)

insert into user_info values(101,'scn@merakdemo.com', 20)

table scn_details structure

===================

create table scn_details

(

refnoint,

ben_namevarchar(30),

amountnumeric(8,0),

statusvarchar(10),

br_codeint,

user_codeint

)

sample records

====================

insert into scn_details values(500,'Sajjad',2000000,'Pending',10,100)

insert into scn_details...

hello

thank you so much for replying

but, problem is i am getting duplicate emails , i dont know why,

can u pls check it

thanks,

---

create table mail_merge

(

refnoint,

ben_namevarchar(40),

amountnumeric(8,0),

br_codeint,

user_codeint,

supervisor_emailvarchar(40),

email_bodyvarchar(max)

)

go

insert mail_merge

(

refno ,

ben_name,

amount ,

br_code,

user_code,

supervisor_email

)

select s.refno,s.ben_name,s.amount ,s.br_code,...