Gary Varga (4/26/2016)

---

??? Surely you mean "apples 'n' pears"!!!

I have never heard of Dancing...

Hugo Kornelis (4/13/2016)

---

If you can indeed not make it,...

Luis Cazares (4/25/2016)

---

Ed Wagner (4/25/2016)

---

Jeff Moden (4/24/2016)

---

TomThomson (4/22/2016)

---

Phil Parkin (4/22/2016)

---

Eirikur Eiriksson (4/22/2016)

---

Brandie Tarvin (4/22/2016)

---

In this case I did add my two cents because I've seen that damn failure before and...

NJ Smith (4/21/2016)

---

You could use the LAG() Windows Function which retrieves the value of the previous row. LEAD() retrieves the value on the next row. Something like;

DECLARE @StartDate AS DATETIME

SET...

DECLARE @MeterReading TABLE

(

MeterId int,MeterDescription varchar(100), ReadingOn datetime, NewReading float

)

INSERT INTO @MeterReading ( MeterId ,MeterDescription ,ReadingOn ,NewReading) VALUES ( 1350,'Left Hand Power Pack RHM','2016-04-14 11:30:00.000',2562.9)

INSERT INTO @MeterReading ( MeterId ,MeterDescription ,ReadingOn...

Nomvula (4/21/2016)

---

Hi Guys

I have the following script when give me the max record on each date:

DECLARE @StartDate AS DATETIME

SET @StartDate = CONVERT(DATETIME,'15/04/2016',103)

SELECT amr.MeterId

...

Gary Varga (4/20/2016)

---

Picasso did surrealist paintings where items looked as though they had melted. The artist is matching this with the IT issue of cooling.

Maybe it is a bad indicator...

Eirikur Eiriksson (4/18/2016)

---

jasona.work (4/18/2016)

---

Steve Jones - SSC Editor (4/18/2016)

---

No more snow here, at least not forecast. It's cloudy, and foggy. Never know. I think weather forecasters are flipping coins half...

Dill

Steve Jones - SSC Editor (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Wouldn't mind to go even if it was...

Have you Googled the error message?

Hugo Kornelis (4/13/2016)

---

BWFC (4/13/2016)

---

Hugo Kornelis (4/13/2016)

---

If you can indeed...

Hugo Kornelis (4/13/2016)

---

If you can indeed not make it,...

I've got my name down for the Saturday but it clashes with a family do so it's unlikely I'll make it. That said, the date for the family thing...

datsun (4/12/2016)

---

Hello,

I have a strange issue on querying a table to return Max datetime with a group by clause.

I am getting all dates as max instead of the actual...