Using the representative data you have supplied do you actually need to use cross apply, a simple left  join will return your expected results

 select a.patient,ProcDate,ResultDate,Value
 from...

could you supply some example representative data and what your expected outcome is?

must you really shrink the TEMP DB, would it not be better to increase the diskspace.

Assuming tables are joined on product type you could run through a CTE, use Row_number() to identify the most recent check and return your full list .....

;with...

Looks like a duplicate post, Tarr94, take a look at what i posted on your origonal post https://www.sqlservercentral.com/forums/topic/sql-server-data-migration#post-3729874

Sorry it took so long for me to get back to you, been a tad busy, here is the most basic example of a migration from a source system into...

• This reply was modified 4 years, 9 months ago by  SGT_squeequal.

I would check with the Vendor that you can do can update the database your self otherwise as frederico_fonseca explained you may be in breach of contract therefore you will...

• This reply was modified 4 years, 9 months ago by  SGT_squeequal.

there are many ways to complete a migration of data and there are plenty of tools to help you out, that is if you have a budget for such tools.

i...

your query is most likely doing a costly sort operation etc, do you have an actual execution plan? also can you provide data structure and indexes for the table

Sorry my bad i pasted the wrong field

update a set a.Person =b.Person_to,

a.Pctg=b.Pctg_New

from #holders a

join #transfers b on a.person=b.person_from and a.kind=b.kind

this will give you the same results as your cursor, by...

im not 100% sure what you exactly want however, i would recommend you reading Jeff Moden article on tally tables and remove your loop.

https://www.sqlservercentral.com/articles/the-numbers-or-tally-table-what-it-is-and-how-it-replaces-a-loop-1

no need to use a CTE, a simple join will do the job, only 2 records in your holders table match your transfers.

select * 
from #holders a
join...

• This reply was modified 4 years, 11 months ago by  SGT_squeequal.

your table is not fragmented as it cant be, your table is a heap.

1. add a clustered index
2. then add a none clusted index on CREATE_DATE

Fantastic article, do you have any links to using the %  to return value. never seen the use of % like this (T.N-1)%3 +1

thanks

are you just wanting to count the number of occurrences of a date regardless of time,  example,my orders table stores datetime so if i count orders created yesterday i get...