No announcements

### Cumulative sum partition , more efficient way?

, is there a more efficient way?            With ...
| 5 Replies | 417 Views | Created by Carlo L - Tuesday, August 13, 2019 2:30 PM | Last reply by Carlo L - Wednesday, August 14, 2019 9:40 AM

### Efficient Cumulative Sum Calculation

Hello, Please can anyone advice my how to create cumulative sum efficiently? My data
| 7 Replies | 2942 Views | Created by drym - Tuesday, August 6, 2013 8:39 PM | Last reply by Vedran Kesegic - Wednesday, August 7, 2013 10:20 PM

### Is there a more efficient way to handle this?

SELECT statements. Is there a more efficient way to handle it? CREATE PROCEDURE mySampleStoredProc @FacebookId INT, @PersonId ...
| 6 Replies | 791 Views | Created by imsam67 - Tuesday, February 18, 2014 3:14 AM | Last reply by Jingyang Li - Tuesday, February 18, 2014 1:36 PM

### More efficient way for checkbox subroutines.

CheckBoxQ3_Click() Call QtrChkBx_Click(28, 40) End Sub Sub CheckBoxQ4_Click() Call QtrChkBx_Click(41, 53) End Sub I ...
| 1 Replies | 195 Views | Created by Alex_Intern - Friday, June 2, 2017 2:03 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Friday, June 2, 2017 2:42 PM

### Cumulative Sum

cumulative.  To obtain the Qt Cumulative i've tried to use an sql like SUM([Qt]) OVER (PARTITION
| 1 Replies | 499 Views | Created by JoshPT - Thursday, June 8, 2017 2:33 PM | Last reply by Min He - MSFT - Tuesday, June 20, 2017 7:41 PM

### Is There A More Efficient Way Of Doing This?

Try it this way: UPDATE MyTable SET Field1=ISNULL(@Field1,Field1)      ...
| 3 Replies | 3403 Views | Created by Triyence - Wednesday, July 6, 2011 4:05 PM | Last reply by --CELKO-- - Wednesday, July 6, 2011 6:22 PM

### Cumulative Sum

Hi C-Sharp Mamba, Supposing you're doing a cumulative sum on the value column among the weekdays in the same week, you can reference the below ...
| 5 Replies | 590 Views | Created by C-Sharp Mamba - Tuesday, April 28, 2015 2:33 PM | Last reply by Eric__Zhang - Wednesday, April 29, 2015 6:54 AM

### Rolling up Cumulative Sum

of the cumulative sum for each team on a given date. Does anyone know of a way to better find the cumulative sum that will allow for this, or is it a ...
| 1 Replies | 1309 Views | Created by JordanYates - Monday, August 5, 2013 8:29 PM | Last reply by ckekiass2012 - Monday, August 12, 2013 10:01 AM

### Is there a more efficient way to select records

there is another way to get the same results. Possible using ROW NUMBER and/or PARTITION ?? Any suggestions are ...
| 6 Replies | 288 Views | Created by SimonKEvans - Wednesday, October 26, 2016 9:35 AM | Last reply by SimonKEvans - Wednesday, October 26, 2016 10:09 AM

### Cumulative Sum

Sorry on what basis you want to calculate cumulative sum is not clear from the above. Do you have date related field or sequence Id? The product number values doesnt seems to be in ...
| 8 Replies | 932 Views | Created by VinayReddy - Sunday, October 16, 2016 4:53 AM | Last reply by RyanAB - Tuesday, October 18, 2016 9:23 PM

### Cumulative Sum

BB 121.4  I want the cumulative sum
| 5 Replies | 407 Views | Created by VinayReddy - Monday, October 17, 2016 12:24 PM | Last reply by Erland Sommarskog - Tuesday, October 18, 2016 10:27 AM

### A more efficient way to sample data?

I'd like to sample the data from the Arduino @ roughly 200Hz. Is there a more efficient way to do this than using a timer (which is what I am currently ...
| 3 Replies | 2608 Views | Created by MBorowski - Thursday, July 1, 2010 12:45 PM | Last reply by Alex Liang - Tuesday, July 6, 2010 3:47 AM

### Is there a more efficient way to search for phrases?

of the data) can enter, for example, "GLUCOSE", "FS GLUC", "*glucose", etc. So the list can change and I would then have to change my list...very ...
| 13 Replies | 3675 Views | Created by brewerdi - Friday, March 26, 2010 9:16 AM | Last reply by brewerdi - Monday, March 29, 2010 5:53 PM

### Is there a more efficient way to change all rows of a datagrid?

The way I do it now is iterate through each row and change the style and data. This is painfully slow for datagrids with large numbers of rows. Is there  a more ...
| 2 Replies | 3022 Views | Created by sekhmeti - Friday, November 7, 2008 9:59 PM | Last reply by sekhmeti - Monday, November 10, 2008 3:39 PM

### Cumulative Sum in sqlServer2005

I want Cumulative Sum on SalesAmount Column from below given table structure. ID SalesCode SalesAmount 1
| 2 Replies | 6636 Views | Created by KUNAL VAISHYA - Tuesday, November 29, 2011 1:26 PM | Last reply by Uri Dimant - Wednesday, November 30, 2011 4:32 AM

### More efficient way to draw a circle then this...?

I got this code form the VIAEarth website... it works great but it pretty slow to use. Does anyone know or have code that can produce the same effect but more ...
| 14 Replies | 5846 Views | Created by JonnyAJAX - Wednesday, January 10, 2007 3:07 PM | Last reply by SoulSolutions - Wednesday, July 18, 2007 12:41 AM

### [vb.net] More efficient way to do this?

Is there any way that I can keep the notes on a local storage device and grab the pictures directly from Wikimedia? Yes
| 35 Replies | 854 Views | Created by treeman1111 - Tuesday, June 10, 2014 11:12 PM | Last reply by tommytwotrain - Sunday, June 15, 2014 11:03 PM

### More efficient way to code this statement?

not be a developer at all. You've asked for an answer for a simpler way to code something, but the fact is, the more you try to shorten your code, the harder it ...
| 40 Replies | 3915 Views | Created by NoEgo - Monday, December 8, 2008 5:17 PM | Last reply by deadManN - Monday, January 12, 2009 11:08 AM