could also use a CTE

DECLARE @d SMALLDATETIME= '2016-10-04';

WITH x AS

(

SELECT MAX(id) AS id

FROM exchangerates

WHERE(ddate < @d)

...

maybe ??

DECLARE @d SMALLDATETIME= '2016-10-04';

SELECT c.ISO,

e.rate

FROM exchangerates AS e

INNER JOIN currencies AS c ON e.currency = c.id

...

bit difficult to say much without more specific details...can you...

J Livingston SQL...

is this the third time of asking the same q?........apologies if I am wrong

http://www.sqlservercentral.com/Forums/FindPost1824675.aspx

kalyav21 (10/11/2016)

---

ProductIDGlobalIDTypeCode

001 100 Out D

001 ...

I did some performance testing on the two pieces of code. They don't produce the same results, and I haven't worked through where the issues are, so these results may...

it would help if you could provide details of all the permutations for your column 'value' and your expected results

valeryk2000 (9/30/2016)

---

I run both codes on my original dataset. Sergiy's returned 130 records, J's - 79. The reason - Sergiy's counted all cases with counts 2 and more,...

Sergiy (9/29/2016)

---

Actually, our codes return quite different results.

Probably not on the set you're looking at, but...

on what size table did you run this?

have you got any time/io results.....?

drew.allen (9/27/2016)

---

Okay, is it just me? I've seen two different people post sample data where the datetime data is given in hex and converted to datetime. It's not...

valeryk2000 (9/27/2016)

---

I do not know what would be the better way to present a simple table with 7K+ records (Excel file). The table has 2 columns, ID and Arrival DateTime....

will you ever have the case where there are "gaps" in your date ranges?

ie...there are dates where you have no price

'North Middlesex University Hospital' is not an exact match for 'North Middlesex University Hospital NHS Trust'

does this make sense?