This article is here to help our banking clients
1. Create a table to hold the list of bank holidays
CREATE TABLE [dbo].[BANK_HOLIDAS](
[BANK_HOLIDAY] [date] NULL
) ON [PRIMARY]
GO
2. Create SQL script in AETL
SELECT COUNT(*) AS C FROM [BANK_HOLIDAS]
WHERE CONVERT(date, [BANK_HOLIDAY]) = CONVERT(date, getdate())