BEGIN
SET
NOCOUNT
ON
;
Declare
@MailTo nvarchar(
max
)
Declare
@MailCc nvarchar(
max
)
Declare
@MailBcc nvarchar(
max
)
Declare
@MailSubject nvarchar(255)
Declare
@MailBody nvarchar(
max
)
Declare
@MailFormat nvarchar(20)
DECLARE
@SignCount nvarchar(50)
SELECT
@SignCount=
COUNT
(1)
FROM
表名称
WHERE
筛选条件
SET
@MailSubject=
'??常共'
+@SignCount+
'?P'
SET
@MailFormat=
'HTML'
SET
@MailTo=
'xxx.zzz@qq.com'
SET
@MailCc=
'xxx.zzz@qq.com'
SET
@MailBcc=
'xxx.zzz@qq.com'
SET
@MailBody=
''
SET
@MailBody =
N
'Dear
Sir/Madam:<br>??常共'
+@SignCount+
'?P,?及?r核??,?x?x!!!<br><H4> 列表如下:</H4>'
+
N
'<table border="1" style="font-size:11px;text-align:center" width="60%">'
+
N
'<tr style="font-size:11"><th>工?</th>'
+
N
'<th>姓名</th>'
+
N
'<th>已用天??</th>'
+
N
'<th>???H已用天??</th>'
+
N
'<th>??常??B</th>'
+
CAST
( (
SELECT
td = Empid,
''
,
td = EmpCName,
''
,
td = [ULColA29-AdjAnlUsePos-
Sum
],
''
,
td = VocaTotalHours,
''
,
td = [ULColA29-State],
''
FROM
表名称 Form
WHERE
筛选条件
FOR
XML PATH(
'tr'
), TYPE
)
AS
NVARCHAR(
MAX
)
) +
N
'</table><br>以上?橄到y?l送,?勿回?停。。?<br>xx部xx?n'
declare
@i
int
BEGIN
SET
@i=0;
EXEC
asdb.dbo.xx_xxx_xxxxx
@profile_name=
'MIS_SMTP_Mail'
,
@recipients=@MailTo,
@copy_recipients=@MailCc,
@blind_copy_recipients=@MailBcc,
@subject=@MailSubject,
@body=@MailBody,
@body_format=@MailFormat
SET
@i=1;
END
END