rupas2000 (7/2/2015)

---

What I mean is, it's working partially. It's giving all columns correct values, except End_Time.

For a single S_ID it is giving correct value but when I query on all...

rupas2000 (7/2/2015)

---

Hi Sean,

I have written a code like below:

SELECT

S_ID,

LAG(S_ACTV_CODE, 1) OVER (ORDER BY S_DATETIME ASC) AS S_ACTV_CODE_PREV,

S_ACTV_CODE,

S_USER,

S_DATETIME AS START_TIME,

LEAD(S_DATETIME, 1) OVER (ORDER BY S_DATETIME ASC) AS END_TIME,

DATEDIFF (SECOND, S_DATETIME,

LEAD(S_DATETIME, 1)...

Lynn Pettis (7/2/2015)

---

I'm taking the youngest down to ERAU for a Spy Camp next week followed by a Soccer Camp the following week. I will be travelling home on...

John Mitchell-245523 (7/2/2015)

---

... but if I had to guess, I'd say you have numeric data stored in a varchar column. In test, all values in that column can be...

rupas2000 (7/2/2015)

---

Hi Sean

Thanks for your reply. I have written a code using LEAD/LAG but it is working partially.

As I am new to this forum, not sure where I can...

mcfarlandparkway (7/2/2015)

---

Hi,

I have a report where i am calling storedprocedure to get the data.In test Environment the same report and same data is working perfectly.

When...

Luis Cazares (7/2/2015)

---

jasona.work (7/2/2015)

---

Today is the kind of day (and it's only been an hour and a half since I got to work) that you clock watch...

OTOH, got plenty to...

ChrisM@Work (7/2/2015)

---

Sean Lange (7/2/2015)

---

jasona.work (7/2/2015)

---

Today is the kind of day (and it's only been an hour and a half since I got to work) that you clock watch...

OTOH, got plenty...

Hi and welcome to the forums. Since you are posting in the 2012 forum I assume you must be using sql 2012. You can use the LEAD/LAG functions to do...

This article explains how to this type of thing quite easily.

http://www.sqlservercentral.com/articles/comma+separated+list/71700/%5B/url%5D

jasona.work (7/2/2015)

---

Today is the kind of day (and it's only been an hour and a half since I got to work) that you clock watch...

OTOH, got plenty to look forward...

The query that was posted will not work on...

OLSONEJ (7/1/2015)

---

I am not getting any results where I expect them with your query sg. I am not sure why as I would say it is sound by looking...

Lynn Pettis (7/1/2015)

---

Sean Lange (7/1/2015)

---

Grant Fritchey (7/1/2015)

---

Sean Lange (7/1/2015)

---

jasona.work (7/1/2015)

---

Man, I hate the week leading up to a 3-day weekend like this...

Half the people (the smart ones?) take the other...

Lynn Pettis (7/1/2015)

---

How do people keep their jobs when it is obvious they are dependent on the good will of strangers on the internet to diagnose and resolve database issues,...