Hi Draw.

I tried your 2nd solution, and it is much slower than the earlier solutions... (for 160 currencies)

This gives exactly what I want. The "cross apply" function is new to me.... wil look into that.

Thanks alot... if ever we meet, I bye you a beer!

That's right. I want a list with ALL currencies and their most recent rate at a certain date (example on Oct 3)

This gives me a list of all days, not the rates on 2016-10-3

Sean Lange (10/14/2016)

---

marc.corbeel (10/14/2016)

---

Forum admin... this is creepy!

I paste a peace of code text with a double space in it, in the topic reply text box, and once saved, the...

Forum admin... this is creepy!

I paste a peace of code text with a double space in it, in the topic reply text box, and once saved, the double space is...

one more try

ltrim(rtrim(replace(coalesce(FirstName,'')+' '+coalesce(MiddleName,'')+' '+coalesce(LastName,''), ' ', ' ')))

This is strange...

when I copy from my SQL studio Manager to this forum, each time the double space is replaced by single one

Anyone knows this issue???

I clearly typed a space in stead of two... sorry

ltrim(rtrim(replace(coalesce(FirstName,'')+' '+coalesce(MiddleName,'')+' '+coalesce(LastName,''), ' ', ' ')))

Sean Lange (10/14/2016)

---

What is the point of the replace here? You are replacing all single spaces with...

Sean Lange (10/14/2016)

---

What is the point of the replace here? You are replacing all single spaces with...

Sean Lange (10/14/2016)

---

marc.corbeel (10/14/2016)

---

I have a table with currencies, and a table where each day the exchange rates for those currencies are downloaded. I want to write 1 query to...

here is how I do this

replace(coalesce(FirstName,'')+' '+coalesce(MiddleName,'')+' '+coalesce(LastName,''), ' ', ' ')

This is not correct. If I insert the line

('2016-1-2 14:10:00','2016-1-2 14:20:00'),

into your sample rows the result changes, and this should not be the case as this timespan is already...