thanx all for the scripts.......i think it was just an excercise......cause i just have to learn ms sql but probaly wont be using it, cause i'm working in the field...

ok well this is a solution that i did with my boss.......:

declare @startdate datetime

declare @enddate datetime

declare...

no problem. definitely when i get the solution from my boss than i will post it here.

thank u all once again!

THANK U VERY MUCH!! i mean ofcourse i wont tell that this is my solution........just wanted to learn how to do it, but definitely this is way above my current...

the thing is i dont know if its an excercise, or not. just that the values in the table r fictional. i mean i made them up. maybe the problem...

well thanx for that.....the problem lies here......

ie.: on 4.2.2005  on the bank account after a transaction there was 120$........value on the acccount doesent change until 17.02.2005. the days in...

its sort of an excercise given to me. not sure if its a real example. but all the dates and values r fictional.

as this is a bank account it would...