I tried the batch approach yesterday.  There are over 5000 units and one unit took about 6 seconds to run.  If I did this in batches of one unit at...

this works!  thank you so much!!!

I tried the query on a much larger dataset and after 4.5 hours it is still running.  The dataset has about 10million records.  Is there...

• This reply was modified 2 months, 2 weeks ago by water490. Reason: asked a follow up question
• This reply was modified 2 months, 2 weeks ago by water490.

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...