please help

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

Check out the SUM() aggregate function together with the GROUP BY clause of the SELECT statement.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Vijaya Kadiyala SSCrazy Eights Points: 9119 More actions · Answer 2

Hi

You can use the sample query

In your case you dont have any critirie to group by so in the below query i removed the group by.

SELECT SUM(EXP_5) from

Thanks -- Vj

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers

Aram Koukia SSCommitted Points: 1521 More actions · Answer 3

hi,

you can use sum function but also you need to grou by other fileds too,

select f1, f2,sum(f3)

group by f1,f2

[font="Courier New"]Aram Koukia: http://www.koukia.ca[/font]

J-440512 SSCertifiable Points: 6285 More actions · Answer 4

i need to sum the values from Exp_5 (900) and replace them in onother table st.total

In your onother table, is there ONLY a SINGLE record, which is overwritten with the next sum value each and every time you run the stored procedure ?

carlos cachulo-318532 Say Hey Kid Points: 697 More actions · Answer 5

Say Hey Kid

Points: 697

February 12, 2009 at 5:18 am

thanks for the help, is working !!!

thank you