all groups > sql server (alternate) > may 2004 >
You're in the

sql server (alternate)

group:

can u help with my select ?



can u help with my select ? Krzysiek
5/31/2004 7:29:42 PM
sql server (alternate): Hello All,

I have a simple table with 2 columns.

datetime int
27.05.04 1
29.05.04 2
31.05.04 5

and i need to get a view that looks like this below :

27.05.04 1 1
29.05.04 2 3
31.05.04 5 8

The third column shows a sum of numbers that were display before present one
...
I was trying build stored proc however I'm not so familiar with SQL so I
failed.. :-(

can anybody help ?

thx in advance
Krzysiek

Re: can u help with my select ? Simon Hayes
5/31/2004 9:15:27 PM

[quoted text, click to view]

It looks like you got an answer in another group - please do not post to
multiple groups independently.

Simon

AddThis Social Bookmark Button