Viewing 15 posts - 331 through 345 (of 2,452 total)
could also use a CTE
DECLARE @d SMALLDATETIME= '2016-10-04';
WITH x AS
(
SELECT MAX(id) AS id
FROM exchangerates
WHERE(ddate < @d)
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 15, 2016 at 6:50 am
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
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 15, 2016 at 6:16 am
karthiknfr_1991 (10/14/2016)
We have server running access etl. It generally gets the data using LANSA queries and access and SQL queries.
bit difficult to say much without more specific details...can you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 14, 2016 at 10:07 am
wendy elizabeth (10/11/2016)
This not the third time I asked a question. In this question, I found out what the issue is and I want to find a resolution.
J Livingston SQL...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 11, 2016 at 2:02 pm
is this the third time of asking the same q?........apologies if I am wrong
http://www.sqlservercentral.com/Forums/FindPost1824675.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 11, 2016 at 1:49 pm
kalyav21 (10/11/2016)
ProductIDGlobalIDTypeCode
001 100 Out D
001 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 11, 2016 at 1:14 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 10, 2016 at 11:10 am
it would help if you could provide details of all the permutations for your column 'value' and your expected results
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 9, 2016 at 10:28 am
valeryk2000 (9/30/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 30, 2016 at 8:26 am
Sergiy (9/29/2016)
valeryk2000 (9/29/2016)
Testing update:J Livingston's code runs OK - same results as in Sergiy's.
Thanks a lot!
Actually, our codes return quite different results.
Probably not on the set you're looking at, but...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 29, 2016 at 3:05 pm
valeryk2000 (9/29/2016)
Testing update:J Livingston's code runs OK - same results as in Sergiy's.
Thanks a lot!
on what size table did you run this?
have you got any time/io results.....?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 29, 2016 at 1:14 pm
drew.allen (9/27/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 27, 2016 at 3:50 pm
valeryk2000 (9/27/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 27, 2016 at 3:08 pm
will you ever have the case where there are "gaps" in your date ranges?
ie...there are dates where you have no price
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 27, 2016 at 9:10 am
'North Middlesex University Hospital' is not an exact match for 'North Middlesex University Hospital NHS Trust'
does this make sense?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 23, 2016 at 11:26 am
Viewing 15 posts - 331 through 345 (of 2,452 total)