Eirikur Eiriksson (6/20/2014)

---

Take a look at this article, How to Return Running Product Totals.

I think the method I used earlier has already been posted on this thread, it is the...

Yes, this is exactly the result I am looking for. Could you please what query you...

Sachin Nandanwar (6/20/2014)

---

I dont understand the problem here.Your query seems to be achieving it.

CREATE TABLE [dbo].[GL](

[Sequence] [int] NOT NULL,

[WK NO] [int] NULL,

[AC] [nvarchar](10) NULL,

[COMP] [nvarchar](10) NULL,

[USD_AMOUNT] [numeric](16, 2) NULL,

[SOA_TYPE]...

ChrisM@Work (6/20/2014)

---

pwalter83 (6/20/2014)

---

Sachin Nandanwar (6/20/2014)

---

But you seem to having one already in your query

(SELECT SUM(CASE WHEN SOA_TYPE IN ('Agent','Freight','Cost') or AC = '16208'THEN USD_AMOUNT ELSE 0 END) YourSum ...

Sachin Nandanwar (6/20/2014)

---

But you seem to having one already in your query

(SELECT SUM(CASE WHEN SOA_TYPE IN ('Agent','Freight','Cost') or AC = '16208'THEN USD_AMOUNT ELSE 0 END) YourSum

FROM GL...

Could you please suggest another way to do a running total in SQL 2008 R2 then ?

Thanks.

Please find the query attached.

Thanks.

Thanks.

Yes, its SQL 2008 R2. The compatibility level is SQL Server 2008 (100).

Sachin Nandanwar (6/19/2014)

---

Something like this

SELECT SUM(YourSum) FROM

(

SELECT SUM(CASE WHEN SOA_TYPE = 'Agent' THEN USD_AMOUNT ELSE 0 END) +

SUM(CASE WHEN SOA_TYPE = 'Freight' THEN USD_AMOUNT ELSE 0 END) +

SUM(CASE...

GilaMonster (2/27/2014)

---

Ok, so the query fragment i gave earlier is correct, it was just short a clause.

SELECT Booking_ID FROM dbo.BOOKING AS b

WHERE DG_FLG != 'Y' AND

NOT EXISTS (SELECT 1...

GilaMonster (2/27/2014)

---

Which wasn't what you said in your initial post.

What...

GilaMonster (2/27/2014)

---

Without table definition and usable sample data I'm guessing, but...

WHERE NOT EXISTS (SELECT 1 FROM <Table Name> ib WHERE ib.Booking_ID = <outer table reference>.Booking_ID AND Flag = 'Y')

If you...

That was my question if you read it properly. Resolved it...

Resolved it by myself.

no issues.