I strongly recommend you steer away from that inefficient method (and it is going to be really inefficient on larger date ranges), and use a numbers table to generate the...

It's just, afaik, a filtered view of sys.dm_exec_query_stats.

To be honest, I wouldn't configure more than 8 without some evidence of allocation contention. The only time I'd have 24, is if, with 20 files, there was still evidence...

You got a calendar or numbers table in your database? If not, can you create one?

What error is being thrown, or what is it doing that it's not supposed to?

https://docs.microsoft.com/en-us/sql/master-data-services/master-data-services-and-data-quality-services-features-support

Please don't post the same question in multiple places.
No further replies here please. Replies to:  https://www.sqlservercentral.com/Forums/1928776/SELECT-INTO-doesnt-update-the-tables-recursively

Using Pietlinden's sample tables above (thanks), this looks like it should give what's wanted.

SELECT account
  , amt
  , rnk
  , FixDate
  ,...

If they're datetimes (not strings) it won't matter to SQL what they are. I'm not American, your format confuses me.

One more thing. What should be returned if there...

So for both of these, it should return the 3rd Feb?

(22, 200, 2, '01/01/2018')
(53, 90, 2, '01/04/2018')

In other words, is the date selected only based...

select <current columns>, paydate from <whatever tables are in your query>
CROSS APPLY (SELECT TOP(1) paydate FROM tbldates WHERE tbldates.paydate > payabledate ORDER BY paydate) AS NextPayDate

You're not going to be able to do that in a view. Views can't execute procedures or dynamic SQL. Functions can't execute procedures or dynamic SQL.

Consider using a...