Thanks Jayanth for this superb example.

Hi Folks i am in similar situation...can you please see my post and reply me.

My Post title is: "Trying to get running Total in SQL Server"

Thanks

Devsql

Hi Eirikur

1-

Thank you very much for showing me this solution.

2-

May i know, why you used/added "AND CURRENT ROW" clause ?

3-

when i try to run your query, i got below error:

An...

Thank you very much guys for this solution...But i made little Typo..so this solution needs little bit update...

Currently my 1st Update statement has Isnull(td.IsPosted, 0) = 0 in WHERE condition.

But...

Hi Grant,

So Nice to hear from you....can't believe this..that you are replying to my post....wooooow...!!!

In last few days i read several of your articles, saw your photo...you have very...

Yup, you almost gave the answer.

But when i tried to test via below query, it doesn't follow what you said:

CREATE Table dbo.Test_1

(

Emp_Id int

,Emp_Name varchar(100)

)

Create Nonclustered Index NCIX_1

On dbo.Test_1(Emp_Name)

Insert...

Hi Folks,

I got partial success for Q-3.

I was using expression inside Variable.

So i changed datatype of variable from String to DateTime & it started working.

I further enhanced it using below:

DATEADD("dd",...