If this is a one-off job, you can get quite a lot of the way there by extracting all the html code into a single file, open it with your...

You need to use the following ANSI formats (including the curly brackets):

{ d 'yyyy-mm-ddd'} for date only

{ ts 'yyyy-mm-dd hh:mm:ss'} for date and time

I've been through the same hoops as...

Oops, got the wrong style in the CONVERT: it should be 1 instead of 3

I think what you need is:

DECLARE @Store_ID varchar(10), @Business_Date datetime, @Compare_date datetime

SET @Store_ID = ''

SET @Business_Date='01/04/2001' -- or whatever...

set @Compare_date=dateadd(day, -1, @Business_Date)

IF @Store_ID <> ''

SELECT StoreID, Bank_Code, REPLACE(CONVERT(char(8),DBR_DATE,...