Blog Of Sem: logo sql mail at sp_Send_DBMail

logo sql mail at sp_Send_DBMail

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON

DECLARE @Delimiter Char(1)
DECLARE @Dosyaadi VARCHAR(249)

SET @Delimiter = CHAR(9) /*Tab char(9) Line feed char(10) Carriage return char(13)*/
SET @Dosyaadi='Sanayi_Güvenli_Stok_Seviye_Kontrolü_'+CONVERT(VARCHAR(10),GETDATE(),104)+'-'+ REPLACE( CONVERT(VARCHAR(8), CONVERT(TIME, GETDATE())),':','.')+'.xls';

EXEC MSDB.dbo.sp_Send_DBMail
@profile_name = 'MAIL_PROFILE',
@Recipients='erinc@bilmarkltd.com',
@Subject='erinç',
@Body='erinç',
@Query='set nocount on; SET QUOTED_IDENTIFIER On ;SELECT
[Ambar]
      ,[Malzeme Kodu]
      ,[Malzeme Açıklaması]
      ,REPLACE( CONVERT(VARCHAR, [Asgari Miktar]),''.'','','') AS [Asgari Miktar]
      ,REPLACE( CONVERT(VARCHAR, [Güvenli Miktar]),''.'','','') AS [Güvenli Miktar]
      ,REPLACE( CONVERT(VARCHAR, [Azami Miktar]),''.'','','') AS [Azami Miktar]
  ,REPLACE( CONVERT(VARCHAR, Miktar),''.'','','') AS [Miktar]
      ,[Kontrol]
      ,[Asgari Seviye Kontrolü]
      ,[Azami Seviye Kontrolü]
      ,[Güvenli Seviye Kontrolü]
      ,[Negatif Seviye Kontrolü]

FROM MYDB.[dbo].[BM_211_AMBAR_PARAMETRE_KONTROL]',
@Attach_Query_Result_As_File = 1,
@Query_Result_Header = 1,
@Query_Attachment_Filename = @Dosyaadi,
@query_result_no_padding=1,
@query_result_width = 32767,
@Query_Result_Separator = @Delimiter

SET ANSI_NULLS OFF
SET QUOTED_IDENTIFIER OFF  

No comments:

Post a Comment