Discussion on:

Using correlated sub-queries in SQL Server

The article references listings A & B, but the links seems broken.

You are probably blocking pop-ups, though. Hold down the CTRL key when you click on the "Listing A" or "Listing B" link, and they should show up just fine.

--Andrew

Isn't this idea the same as a self join? For instance:

Select s1.Product
, s1.SaleID
, s2.RunningTotal

From saleHistory s1
INNER JOIN (

Select Sum(SalePrice) as runningTotal
From SaleHistory

) s2 ON s1.product= s2.product

WHERE s2.saleid s1.saleid

Group By
s1.Product, s1.SaleID

Links are NOT working. If you hover over listings A and B, you will see the actual page pointed to is the page we are on. I have all popup blocking disabled and no dice. Would like to see your listings.

Found the windows with the code. Small windows displayed in corner of 2nd monitor. The confusing point is that another full web page (this one) opens up ALONG WITH the new window containing the code (which may appear on another monitor or in the corner where you are not expecting it.) Hope this helps if you seem to have trouble opening the listings.

I am seeking a short t-sql code to calculate the running sum..

the subquery is executed for every row that is selected by an outer query

The links for listing A and listing B do not work.