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...

Please respond to Gail's post before we continue with correcting the syntax...

The problem is with the single-quoted parameters. Use PRINT @sqlcommand instead of EXEC(@sqlcommand) and examine the statement.

Why do you need a cursor? Surely you just need the value in a variable?

SELECT @Variable = column FROM...

DDL and DML?

CREATE TABLE #Sample (TestID ...

INSERT INTO #Sample ...

Surely this is sufficient:

SELECT SUM(Avamel)

FROM V_Factor_Total4

WHERE cslPricingFactorRef = '90000119'

Jay

I don't see anything cumulative yet - the result sets you've posted are simple aggregates:

SELECT

Docket_Category,

[Count],

[Percentage] = CAST(100*[Count]/(Total*1.00) AS NUMERIC(4,2))

FROM (

SELECT

Docket_Category,

[Count] = COUNT(*),

Total = SUM(COUNT(*)) OVER(PARTITION...

As long as you will never go beyond four or five columns, the following query works well. Otherwise Google delimitedsplit8k.

-- sample data

;WITH SampleTable AS (

SELECT Stringybit = 'part1 area 2...

Make up the results. Use the sample data set you've posted as your source, run...

Ok, interesting...how...

Hi Jay, that's great, thanks. How about a table of expected output?

Hi Jay, try reading the link in my sig "please read this". It will describe to you how to set up some sample data for folks to test solutions against....

-- sample data. I reckon a [quantity] column is missing.

-- so calculating over [Docket_Id] instead.

DROP TABLE #DocketTB

SELECT *

INTO #DocketTB

FROM (

SELECT Docket_Category = 'Mechanical', Docket_Id = 49 UNION...

It's not possible without...

jerome.morris (7/9/2012)

---

Hi all I have a table with columns in that I want to do a running total on. I want to be able to see how many occurances of...