i just need math formula to calculate cumulative field. in sql.

is there any build in function

OK SORRY MAX date its working.

help me with cumulative calculation

i just want to know ,how you select max (date)

max is not working as date is datetime

agai my req has change

now i need to calculate maximum date and put it into local variable

it snot running total,if you see it carefully,

its not just adding values. sometimes its adding 1 ,sometimes it minus 1

MAY BE U CAN understand by this

NUMBER CUMULATIVE

...

fine,i will ask them,they r not understanding as they dont know sql.

one thing can solve my prob.

how to calculate cumulative of any field.

if you know let me know

ok. 1 more prob.

my function from which i need to fetch data @Reportdata3 , has fromdate and todate

so when i execute my sp exec dashboard

i am supplying fromdate and todate

so...

finally got it ,with this code

DECLARE @row1 datetime, @Todate DATETIME

set @row1 = '2010/09/30' -- however it gets assigned,

set @Todate = '2011/12/31' -- however it gets assigned,

while(@row1 <= @Todate)

...

i cant set @row1 first day of the month,it can be any date. its not hard coded,user will enter it and it could be any day

i havent missed anything.

can you please rutn this code,you will know

DECLARE @row1 datetime, @Todate DATETIME

set @row1 = '2010/09/30' -- however it gets assigned,

set @Todate = '2011/12/31' -- however it gets...

Lynn,

i am already have training in sql, this is somehow tricky ,that dates is not working after feb

usually i need t put month last day ,not first day

for example.

9/30/2010

can be my row1,so after coming to feb it just adding month ,not days

i knwo tits working for first day of month.

but my req is if i enter any date in a month, i should get next month first day

nope ,i have chnage anything

the prob is month of feb,is you try this

DECLARE @row1 datetime, @Todate DATETIME

set @row1 = '2010/02/28' -- however it gets assigned,

set @Todate = '2011/02/01' -- however...