Nicely formatted expected results from the OPs initial post:

S_ID S_ACTV_CODE_PREV S_ACTV_CODE_CURR S_USER S_START_TIME ...

yb751 (7/2/2015)

---

Since you (the OP) stated that your query worked with a single user I just used your own code with a specific user for testing.

SELECT

S_ID,

LAG(S_ACTV_CODE, 1) OVER (ORDER BY...

Work to live, not live to work.

BL0B_EATER (7/2/2015)

---

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

Luis Cazares (7/2/2015)

---

I'm not sure about your desired results, but I believe that you need to add a partition to your window functions.

SELECT

S_ID,

...

Sean Lange (7/2/2015)

---

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

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

Jason A. Long (7/1/2015)

---

The word...

knakka99 (7/1/2015)

---

Part 1: When there is ~ (tilde) and has any value after it then it goes into a new row and duplicating the other columns like the facility in...

Sean Lange (7/1/2015)

---

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

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

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, especially some...

True, saw...

Forum etiquette would have you post the answer to your question as it may help others with a similar problem.

Also depends on the software being supported. If you are running third party software you are at the mercy of the vendor. If they don't support the newest...