>The difference here is that I'm trying to do the running total from more than one column,and that's the part I dont get. What I need is something like VFP's IIF() function.
>

Please check http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/94b66431-8493-4515-b549-79386aae5768