I forgot to include the expected results.  Sorry about that.  Here you go:

I think this is what you are looking for.

-- For each test_date, determine the last date to count in a 10 date range
; WITH DateAnalysis AS
(SELECT...

My SQL skills are not too sharp.  I am...

np.  here you go:

drop table if...

Can you not insert a rolling 10 days window? Something along the lines of

PERCENT_RANK() OVER (PARTITION BY year ORDER BY date DESC ROWS BETWEEN 10 PRECEDING...

ensure the file is a correctly built CSV file - if it is then you can load it using the format=CSV above - if it not then...

ensure the file is a correctly built CSV file - if it is then you can load it using the format=CSV above - if it not then get whoever...

I tried a few values and the outcome is the same.  The file...

I came across OPENROWSET.  This looks promising but I have never used it before.  Can this be used for my purpose?  If yes, how would I use it?  I am...

There is probably a non-printable character in it.

CREATE TABLE #DIVIDENDS_NEW
(
[DIVIDEND_AMOUNT] [varchar](15) NULL
);

insert into #DIVIDENDS_NEW select NULL;
insert into #DIVIDENDS_NEW select '5';
insert into #DIVIDENDS_NEW select CHAR(10); /* invisible...

This is great.  It works.  Thank you so much!

I re-wrote my code with an IF statement and that solved the issue.

I clarified my original post.  Not sure if you saw it or not when you replied.

I did think about TRY/CATCH but not really sure how I can...

I gave the proposed logic CASE but I am open to anything.  If code has an error then return NULL else run the code

I was playing around with the query.  I figured out the problem.  The query didn't like the alias.  Once I removed the alias then it worked.  That is so odd...