Jack Corbett (7/3/2014)

---

Looking at the SP it looks like you were on the right track to fixing the issue with the dbo.Split() function. When passing multi-value parameters...

J Livingston SQL (7/2/2014)

---

try this....based on your sample data (I think)

WITH rt_cte as (

SELECT a.[WK NO],

AC= MAX(AC),

comp= MAX(COMP),

AUSD= SUM(CASE WHEN SOA_TYPE = 'Agent' THEN USD_AMOUNT ELSE 0 END),

FUSD=...

ChrisM@Work (7/2/2014)

---

pwalter83 (7/2/2014)

---

ChrisM@Work (7/2/2014)

---

If your calculation depends upon a value from a previous row, what should the result of...

Yes, the column is mapped in the destination component (screenshot s1). Also, the source column has data in it (screenshot...

ChrisM@Work (7/2/2014)

---

If your calculation depends upon a value from a previous row, what should the result of the calculation...

Lynn Pettis (7/1/2014)

---

First, you haven't detailed what exactly is wrong.

Second, what have you done to try and resolve the problem?

Third, how does the running total part of all this fit...

Can somebody please help on this ?

Lynn Pettis (6/25/2014)

---

EDIT: Looks like Chris found the issue with the part I did. Now to try and figure out the rest.

I found the problem, try the following:

IF OBJECT_ID...

Lynn Pettis (6/25/2014)

---

pwalter83 (6/25/2014)

---

Jeff Moden (6/25/2014)

---

pwalter83 (6/25/2014)

---

Lynn Pettis (6/25/2014)

---

EDIT: Looks like Chris found the issue with the part I did. Now to try and figure out the rest.

I found...

Jeff Moden (6/25/2014)

---

pwalter83 (6/25/2014)

---

Lynn Pettis (6/25/2014)

---

EDIT: Looks like Chris found the issue with the part I did. Now to try and figure out the rest.

I found the problem, try...

ChrisM@Work (6/25/2014)

---

The issue is a lack of clarity.

Don't give up. Have a look at the result of this:

IF OBJECT_ID ('tempdb..#GLT') IS NOT NULL DROP TABLE #GLT

CREATE TABLE #GLT (

[Sequence] [int]...

Lynn Pettis (6/25/2014)

---

EDIT: Looks like Chris found the issue with the part I did. Now to try and figure out the rest.

I found the problem, try the following:

IF OBJECT_ID...

Lynn Pettis (6/25/2014)

---

Please explain what it is you are trying to accomplish? Is case 2 trying to show current running totals for the weeks 18 to 23 but include...

Lynn Pettis (6/25/2014)

---

pwalter83 (6/25/2014)

---

ChrisM@Work (6/25/2014)

---

The issue is a lack of clarity.

Don't give up. Have a look at the result of this:

IF OBJECT_ID ('tempdb..#GLT') IS NOT NULL DROP TABLE #GLT

CREATE TABLE...

ChrisM@Work (6/25/2014)

---

The issue is a lack of clarity.

Don't give up. Have a look at the result of this:

IF OBJECT_ID ('tempdb..#GLT') IS NOT NULL DROP TABLE #GLT

CREATE TABLE #GLT (

[Sequence] [int]...