AARGH! Session timeout!!...

Grant Fritchey (4/27/2016)

---

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

---

tindog (4/27/2016)

---

I'd love to go to this, but have no SQL-y friends and get v anxious in unfamiliar places where I don't know...

That was surprisingly easy for one of Andy's questions. There weren't any tricks or things that we should have inferred from the position of a comma :cool:. I...

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

---

BWFC (4/26/2016)

---

I'm now unregistered as yesterday I was officially invited to spend my Saturday afternoon with an army of four-year-olds on a sugar-rush. Although...

NineIron (4/26/2016)

---

I have a report with too many columns to fit onto a landscape format. Is there a way to "divide" the record up to create two rows for the...

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...