-- with CostsNet in the GROUP BY, there's no aggregate of CostsNet

-- Try the original query with and without SUM

-- Then take CostsNet out of the GROUP BY and check

--...

Hello and welcome to ssc. Please read the link in my sig (click on the word "this"), which will show you how to create sample data for folks to code...

After you have populated the variables, how do you use their values?

Jeff Moden (7/10/2012)

---

@Gus,

Ok... I've been looking at this thread for a bit for "Sam's view definition" and I'm not finding any "SAM" that posted. Did you mean "Chris' view...

Jeff Moden (7/10/2012)

---

ChrisM@Work (7/10/2012)

---

Jeff Moden (7/9/2012)

---

In 2008 or less, I'd REALLY like to know how to create a view that does a running total without forming a Triangular Join. ...

Lovely stuff - FGW sell it on board their trains.

Stuart Davies (7/10/2012)

---

Two favourite ales of mine one found here

http://www.marstonsbeercompany.co.uk/our_brands/marstons/oldempire.asp

and the other here

http://www.innisandgunn.com/en/the-range/original.aspx

Not beers for drinking by the bucket full though - they pack a bit of a punch as...

GSquared (7/10/2012)

---

Just looked in Jeff's old article on running totals, and on his PC, the quirky-update running total on a million rows of data was about 6 seconds. Assuming...

GSquared (7/10/2012)

---

ChrisM@Work (7/10/2012)

---

Jeff Moden (7/9/2012)

---

In 2008 or less, I'd REALLY like to know how to create a view that does a running total without forming a Triangular Join. I...

Jeff Moden (7/9/2012)

---

In 2008 or less, I'd REALLY like to know how to create a view that does a running total without forming a Triangular Join. I don't believe...

There's no aggregate in my previous post:

SELECT @90000119Sum = Avamel

FROM V_Factor_Total4

WHERE cslPricingFactorRef = '95'

AND ProductCode = '90000119'

Why do you need a cursor for this?

Performance is likely to be very...

SELECT @90000119Sum = Avamel

FROM V_Factor_Total4

WHERE cslPricingFactorRef = '95'

AND ProductCode = '90000119'

eh.shams (7/10/2012)

---

i try :

While @@Fetch_Status = 0

Begin

select

CASE

WHEN (@ProductCode = 90000119) and (@cslPricingFactorRef =...

Like this:

CASE

WHEN (@cslPricingFactorRef= 90000119) THEN (SELECT @sum=@Avamel)

What are the other decisions?

eh.shams (7/10/2012)

---

i write :

SELECT @90000119Sum = @Avamel

"@90000119Sum" this is variable i declare it,@Avamel is belong to cursor as shown in top

in cursor but give me this error...