//Returns the difference between physical and system stock. This is a read-only property

public int Difference { get { return _physicalStock - _physicalStock;}}

should be:

public int Difference...

I've found exactly what I need, but in a Oracle

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Cumulative Aggregate Function Example

The following is an example of cumulative amount_sold by customer ID...

Hi,

the ordr field actually is the smalldatetime field and it can hold the multiple records with same value. Yes I know that I can solve this problem with #tmp table (or...

I have already used #tmp table to get the result, but I was trying to get the result with simple T-SQL.

thanks,

stojce