bh3605

-- =============================================
-- Author:		Hair, Bryson
-- Create date: 4/27/2021
-- Description:	This stored procedure will send an email from the database with the query results as an html table in the email.
-- =============================================
ALTER PROCEDURE [dbo].[CFT_SendDBEmailwithTabularQuery]
(
	@qSELECT NVARCHAR(100), --The select part of the sql statement, which can include top X
	@fieldlist NVARCHAR(MAX), --Pipe delimited list of fields, which can include aliases
	@qFROM NVARCHAR(MAX), --The from part of the sql statment, which can include joins

bh3605

sing System.Collections.Concurrent;
using System.IO;
using System.Security.Cryptography;
using System.Text;
using System.Web;

/**
 * Solution from https://stefanolsen.com/posts/cache-busting-with-asp-net-mvc/
 * https://www.madskristensen.net/blog/cache-busting-in-aspnet/
 * https://stefanolsen.com/posts/cache-busting-2-0-an-update-for-asp-net-core/

bh3605

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;

public class TypeSafeEnum<T> where T : class
  {
      TypeSafeEnum(string name, T typeSafeEnum)
      {

bh3605

DEL /F/Q/S *.* > NUL