Database

SELECT SUM(field) AS [expression]<br />
FROM table<br />
[WHERE ...]<br />
[GROUPBY ...]<br />
[HAVING ...]

select a.ClientID, a.ClientName, b.YTDGross, b.YTDNetCom,
  b.YTDNetInt, b.CSCost, b.OtherCost,
  (b.YTDNetCom + b.YTDNetInt) as YTDNetRev,
  (b.CSCost + b.OtherCost) as TotalAlloCost,
  (b.YTDNetRev - (b.CSCost + b.OtherCost)) as TotalNetRev,
  sum(c.YTDNetRev - (c.CSCost + c.OtherCost)) as RunningTotal
from tblClients as a, tblData as b, tblData as c
where a.ClientName = b.ClientName
and a.ClientName >= c.ClientName
group by a.ClientName, a.ClientID, b.YTDGross, b.YTDNetCom, 
  b.YTDNetInt, b.CSCost, b.OtherCost
order by a.ClientName, a.ClientID

DataView t=new DataView(someTable);<br />
t.RowStateFilter=DataViewRowState.CurrentRows;<br />
		<br />
debug.WriteLine("Rows Count before deletion= "+ t.Count);<br />
t[0].Delete();<br />
debug.WriteLine("Rows Count after deletion = "+ t.Count);

DECLARE @counter smallint
SET @counter = 1
WHILE @counter < 5
   BEGIN
      SELECT RAND(@counter) Random_Number
      SET NOCOUNT ON
      SET @counter = @counter + 1
      SET NOCOUNT OFF
   END
GO

function array_randomise() {
  var li_rnd ;
  var lo_temp ;
  //Move each record to a random position in array ...
  for (var li_loop = 0 ; li_loop < this.length ; li_loop++) {
    li_rnd = Math.round(Math.random() * li_array_len) ;
    lo_temp = this[li_rnd] ;
    this[li_rnd] = this[li_loop] ;
    this[li_loop] = lo_temp ;
  }
}