Re: Sequential Time and Cumulative Counts

On Mar 28, 1:50 pm, "Plamen Ratchev" <Pla...@xxxxxxxxxxxxx> wrote:
Those type of running total problems cannot be really solved efficiently
with the current SQL Server editions. On a large data set all set based
solution will be slow.

Very nice. I ended up doing a while loop in place of your query from
master..spt_values. I think your solution will run faster though.
Thanks!
.

Relevant Pages

  • Looping problem...requery issue?
    ... I have a function that is supposed to loop through a table and update ... the information in fields based on query results in a data set. ... rstPayorInfo.Requery sqlstr2 (I've tried with and without the ... I'm using values from the query of another database to get the values ...
    (microsoft.public.access.formscoding)
  • Re: Walking Dataset, faster/better way?! Help!!!
    ... I though this was a bug but thinking about your data set, ... >> started with a for loop and a basic comparison. ... >> Part of the optimization was because on each successful comparison the ... >> The Microsoft Office Web Components Black Book with .NET ...
    (microsoft.public.dotnet.framework.performance)
  • Re: [PATCH][RFC] fast file mapping for loop
    ... This works reasonably well for simple things, like mapping an ... and the copy ran at 25MB/s for the whole data set. ... Because many of these have been shipped over the last two years and new loop code would only be useful in this case if it were compatible so old data sets could be read. ... are done once they hit page cache. ...
    (Linux-Kernel)
  • Re: looping eating 100 per cpu
    ... If an insert occurs on every iteration through the loop, ... > data set to be used in next loop ... > Shawn Wilson ...
    (comp.lang.php)
  • Re: How to read a CSV file into array in Fortran 77
    ... This means that for a 4x12 data set you're trying to read in a 12x4 data set, which will only cause an error as it hits the end of file during a read. ... Or am I interpreting that loop wrong? ... The array then needs to be dimensioned instead of, ...
    (comp.lang.fortran)