Yes, as I was driving to meet a friend for lunch, it dawned on me that I will need to partition by PudID when I include them all. Thanks...

Perfect! That's exactly the answer I was looking for. I tried all sorts of SUM OVER PARTITION BY combinations with no luck, but I see the PARTITION wasn't...

Hi Chris,

That other post was an attempt to see if I could use some sort of "fast" running balance to calculate blend percentages (variety of grape, vintage of grape, appellation...

The results I've included in this post are from a query. I've just tried to simplify the issue since I'm really only interested in getting the correct running balance...

Thanks Jeff. Yes, I want to use the 2012 functionality, but I guess I don't quite understand what you're suggesting. I can create a running total on the...

The Plan B query is excrutiatingly slow 🙁

Any suggestions on how I can get the same results but with better performance?

OK, I'm trying plan b but the running balance is not correct. It seems to ignore my request for only the highest seq for each lot. I must...

Sorry about that. I must've grabbed the wrong file. I've re-uploaded the correct attachment.

Thanks for the reply, Lynn. I'm not sure how to replicate the table valued parameter, but I executed the following from SSMS:

BEGIN TRY

SET NOCOUNT ON

BEGIN TRANSACTION

UPDATEAVA...

Thanks, Dwain. Let me see what I can do with this.

Gina

I came up with this code:

selectPntKey,

RowNumber,

CASE

WHEN RowNumber = 1 THEN Qty

ELSE 0

ENDQty,

min(FromDate1),

max(ToDate1),

min(FromDate2),

max(ToDate2)

from

(

selectPntKey,

ROW_NUMBER() OVER(PARTITION BY PntKey ORDER BY PntKey) AS 'RowNumber',

Parent.PntQty Qty,

Child1.Cd1FromDate FromDate1,

Child1.Cd1ToDate ToDate1,

null FromDate2,

null ToDate2

FROM Parent

LEFT JOIN Child1 ON Child1.Cd1PntKey...

Thanks for responding. I actually did try using joins as my first choice, but the results were incorrect:

PntKey Qty ...

The temp table would not be wide enough. I need the ability to calculate running percents on each component in the final product, and often times there are thousands...

I just read this article about SQL Server 2012's new features (http://blog.tallan.com/2011/12/08/sql-server-2012-windowing-functions-part-1-of-2-running-and-sliding-aggregates/) and I'm thinking it *might* solve my problem, as long as I can join to other...

Okay, so because the sparse column actually takes up more space when there is data in it than an equivalent non-sparse column, that would explain why I don't get the...