As written, your code would leave out any transactions datestamped for the start time of the period:

WHERE

d.DateFirstIssued > fy.FYQ2

Shouldn't the operator be >= to include the start date and time?

I have found a workaround for the "severe error" that I received from the previously presented script. The INSERT statement and SELECT statements had the columns in a different...

Paul,

Sorry. It still is an issue after all. I thought my script was logged in to the source server, but was instead logged in to Cyrodiil...

Paul,

Thank you for taking a look at this. It may have been a QUOTED_IDENTIFIER issue. Late in the day, I found out that SET QUOTED_IDENTIFIER was...