Chris, 
Looks great! Now I am getting 24 records. However, the problem is I am getting all 24 IDs with lower "Rate". I should get all higher rate ids first...

Hi Chris, 
Here is the answer to your questions. 

1) Have you checked that there are matching rows available in the source table? = Yes there is matching rows...

Hi Chris,
Sorry for the late reply. Just want to give you an update. It is working 95% fine but I am still missing 2 records to be linked. I...

Chris, 
It's a HUGE effort that you doing. Highly appreciate. However, from the test/live data example I am still missing some records to Link For some reason, I am still...

Joe, 
Just for FYI,  I already mentioned, I am sending Live/Sample data. If you are working on Healthcare or any other environment, the company policy is to not share 100%...

Chris, 

Once THANK YOU for your help on this. You are saving my life here 🙁
I tried my best to provide you everything and this is 100% same...

Chris, I really APPRECIATE your help. Unfortunately, It is updating the same S_ID again and again and once I used that S_ID I don't want to update again. 

Any...

Here is the Live/Sample Code. I know it's too lengthy but that's the perfect example. I am/was trying to avoid (While Loop or Cursor to do this accomplished) so come up...

The end result is, I want to update Destination.s_id field from Parenttable.s_id. Because it is one to many relations, so  I am getting a
lot of duplicates. I want to...

Sorry for not providing an enough info. Here is my code and above is my sample data that I used to test this query. I am getting a lot of...

Thanks for your reply, for some reason CROSS APPLY with TOP not working for me.

The Goal here is After I link two tables I am having a lot of dups. It is One to many relation. What I am looking. If they find a link...

Thanks for your help. It works great with the source data. I will apply this on my real data and get back to you.

Really appreciate your help and happy...

Thank You for your prompt reply.

However, I missed one part to mention.

The table structure of [Link-Table2] would be.

CREATE TABLE [dbo].[Link-Table2](

[link1] [VARCHAR](50) NULL,

[link2] [VARCHAR](50) NULL,

[phone] [NVARCHAR](50) NULL,

[address] [NVARCHAR](50) NULL,

[status] [NVARCHAR](20)...

After I receive email.I am seeing only "Please Click :" in the email body.

Which link?