I do have another way which is working for me (below). I just wanted to try this other way to see if works more efficient.

...

Thanks! this is what i needed.

thanks

Great article....helps developers understand dba's better. Now we just need an article for dba's to read on how THEY should act and treat others who play in the same...

I tried this but it only gives me the first column.... what am I doing wrong?

-- START HERE

DECLARE @sql NVARCHAR(MAX)

DECLARE @TBLNAME VARCHAR(100)

DECLARE TBLS CURSOR FOR

SELECT DISTINCT [TABLE_NAME]

FROM ...

Thanks! haven't done this in so long I couldn't remember.

Anyone think they can improve on this query?

Thanks all for looking at this to help me. I have been playing, trying to figure it out as well. I came up with this query. It...

Check the post I made with the desired results.jpg It is explained there and shows where the volume comes from.

To be honest I don't know why that is being calculated like that. I was given these instructions and this is how the data needs to be displayed for...

The answer to your question is that when the Running total is greater than the Volume total (60), instead of entering in the running total amount, you calculate the total...

Sorry for this double post...i didn't realize it went to another page and thought it didn't go thru the first time.

GrassHopper (11/26/2014)

---

In the attachment I will explain what that means:

The...

In the attachment I will explain what that means:

The volume in Cell K, I get by using this query:

Select SUM(Calc_line_net_amount) as volume,GroupID,[Include]

from [PRGX_AS_CC_SandBox_Rebates_2013].[dbo].ClaimTank

Group by GroupID, [Include]

Having...

I am posting the desired results in a jpg. I will explain how I get to this:

At the top cell J and K, we have the Volume. It...

I'm open to undocumented features. Glad you mentioned the issues with the "<=" because I was trying to do something with that. I'll trash that idea and wait...