FREE AI-Enhanced Online SQL Server Compiler

Untitled*

You must execute the code again to save those values in the database.

USE [BD_do_ExcelProLixo]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[SP_SendMail]

AS
BEGIN
  SET NOCOUNT ON;
  DECLARE @tab char(1) = CHAR(9);

DECLARE @xBody nvarchar(max),
          @xBodyResumo nvarchar(max),
          @xBodyData nvarchar(max),
          @htmlhead varchar(1000),
          @estiloResumo varchar(1000),
          @estiloDados varchar(1000),
          @TableHeadResumo varchar(1000),
          @TableHeadData varchar(1000),
          @TableTail varchar(1000),
          @htmltail varchar(1000)

SET @TableTail = '</table>';
  SET @htmltail = '</body></html>';
  SET @htmlhead = '<html><head>';
  SET @estiloResumo = '<style>'
  + 'table.resumo {16px arial} '
  + 'table.data   {14px arial} '
  + 'td.resumo {border: solid black;border-width: 1px;padding-left:5px;padding-right:5px;padding-top:1px;padding-bottom:1px;font: 16px arial} '
  + 'td.data   {border: solid black;border-width: 0px;padding-left:5px;padding-right:5px;padding-top:1px;padding-bottom:1px;font: 14px arial} '
  + '</style>' + '</head>' + '<body>';

SET @TableHeadResumo = 'Resumo: '
  + '</b> <br> <table class="resumo" cellpadding=2 cellspacing=5 border=0 rules="rows">'
  + '<tr> <td bgcolor=#E6E6FA width="200px"><b>Descritivo</b></td>'
  + '<td bgcolor=#E6E6FA      width="100px"><b>Quantidade</b></td></tr>';

SET @xBodyResumo = (SELECT
    td = p.descritivo,
    '',
    td = p.quantidade,
    ''
  FROM (SELECT
    'Cenas' descritivo,
    COUNT(*) quantidade,
    01 ordem
  FROM BD_do_ExcelProLixo..V_ResumoDasCenas) p
  ORDER BY p.ordem ASC
  FOR xml RAW ('tr'),
  ELEMENTS)

SET @TableHeadData = 'Lista de cenas diárias: '
  + '</b> <br> <table class="data" cellpadding=2 cellspacing=2 border=0 >'
  + '<tr> <td bgcolor=#E6E6FA width="80px"}><b>Data</b></td>'
  + '<td bgcolor=#E6E6FA      width="300px"><b>Cena1</b></td>'
  + '<td bgcolor=#E6E6FA      width="50px"><b>Cena2</b></td>'
  + '<td bgcolor=#E6E6FA      width="350px"><b>Cena3</b></td>'
  + '<td bgcolor=#E6E6FA      width="150px"><b>Cena4</b></td></tr>';

SET @xBodyData = (SELECT
    td = ISNULL(p.data, ''),
    '',
    td = ss.cena1,
    '',
    td = P.cena2,
    '',
    td = P.cena3,
    '',
    td = P.cena4,
    ''
  FROM (SELECT
    data,
    cena1,
    cena2,
    cena3,
    1 ordem
  FROM BD_do_ExcelProLixo..V_DadosDoExcel) p
  FOR xml RAW ('tr'),
  ELEMENTS)

SET @xbody = @htmlhead + @estiloResumo + @TableHeadresumo + ISNULL(@xBodyResumo, '') + @TableTail + ' </br>' + @TableHeadData + ISNULL(@xBodyData, '') + @TableTail + @htmltail

-- top kek, sem email no fim-de-semana que é dia de descanso!!!!
  IF (DATENAME(dw, GETDATE()) = 'Sunday')
    OR (DATENAME(dw, GETDATE()) = 'Saturday')

BEGIN
    SELECT
      1;
  END;
  ELSE
  BEGIN

EXEC msdb.dbo.sp_send_dbmail @profile_name = 'ExcelProLixo',
                                 @recipients = 'paramim@empresa.com, eparaomeuchefe@empresa.com',
                                 @query_result_width = 140,
                                 @query_result_header = 1,
                                 @exclude_query_output = 0,
                                 @query_result_separator = ' ',
                                 @query_result_no_padding = 0,
                                 @subject = 'Os dados do Excel que não quero abrir :)',
                                 @body = @xbody,
                                 @body_format = 'HTML',
                                 @attach_query_result_as_file = 0;

END

END;

Msg 911, Level 16, State 1, Server 95a4aee3fef0, Line 2
Database 'BD_do_ExcelProLixo' does not exist. Make sure that the name is entered correctly.