Evil Kraig F (9/19/2011)

---

Paul, remember when I mentioned in that other thread that Partitioning seems to be a Level III item? 🙂

daveriya (9/19/2011)

---

my question is after i do proportion .again i need to do sum of all proportion and i need to display in row how to do that

Jeff Moden (9/18/2011)

---

"Unordered"... have you an example of when ROLLUP produces incorrectly ordered results?

Jeff Moden (9/18/2011)

---

Leveraging Paul's code from above, please note the replacement of ORDER BY with WITH ROLLUP in the following code...

ALZDBA (9/18/2011)

---

probably about the only thing missing to get a meaningful result is the product indication:

shatrughna (9/18/2011)

---

Hi,

If you want to write function then you need to do small changes in T-SQL.

CREATE FUNCTION [dbo].[Total]

(

@Amt INT

)

RETURNS INT

AS

BEGIN

DECLARE @TSUM INT

SELECT @TSUM = SUM(@Amt)

RETURN @TSUM

END

Tom.Thomson (9/17/2011)

---

Yes, come on Jason - admit that the only reasonm you changed the U to an E was so that we wouldn't find your picture here.

SQLRNNR (9/17/2011)

---

I was fully expecting to see this thread over 30,000 by this time.