Is there a way to rewrite this query using the Django QuerySet object: SELECT b.created_on, SUM(a.vote) FROM votes a JOIN votes b ON a.created_on <= b.created_on WHERE a.object_id = 1 GROUP BY 1 Where votes is a table, object_id is an int that occurs multiple times (foreign key - although that doesn't matter here), and created_on whic...
This seems like it should be simple but I can't find anything yet. In Reporting Services I have a table with up to 6 rows that all have calculated values and dynamic visibility. I would like to sum these rows. Basically I have a number of invoice items and want to make a total. I can't change anything on the DB side since my stored proce...
I have an XML file where the number are comma-separated <foo> <bar val="1,23"/> <bar val="4,56"/> <bar val="7,89"/> </foo> I would like to make a sum over /foo/bar/@val values in XSLT, but I am a bit stuck the formatting. Does anyone knows what would be the proper syntax? ...
I'm working on a problem which uses a python class and has a constructor function to give the number of sides to one die and a function to roll the die with a random number returned based on the number of sides. I realize the code is very basic, but I'm having troubles understanding how to sum up the total of three rolled dice with diffe...
from i in Db.Items select new VotedItem { ItemId = i.ItemId, Points = (from v in Db.Votes where b.ItemId == v.ItemId select v.Points).Sum() } I got this query, however it fails if no vots are found with "The null value cannot be assigned to a member with type System.Int32 which is a non-nullable valu...
The program is supposed to calculate the number of arguments, iterate over the list of arguments, for each argument convert the argument to an integer and copy it to an array, iterate over the elements of the array, adding the value of each one to a variable (this computes the sum of elements), and print the sum. There will not be more t...
I've got a NSDate that represents a specific time. The format of that date is hhmmss. I want to add an NSInterval value (specified in seconds) to that time value. Example: NSDate = 123000 NSTimeInterval = 3600 Added together = 133000 What is the best way to do this? Thanks. ...
Group, I have a report that has row groups for customer MembershipLength (1 year account, 2 year account, etc.) then a sub group of rows for customer Status (active, inactive, etc.) Then I have columns for customer types. Ultimately I want to add a column that will calcualate the percentage of the subtoatl for the corresponding custome...
Hi, My problem is the following... I have a little aeroplane and I need to track the hours. I have to track the hours by sectors and not the total of the day (that's why sometimes I have 2 or 3 on the same day). Now this is the problem... On column C I need to SUM the hours of the last 7 days. And any given 7 days, not just last week....
I have a (C#) class called Hit with an ItemID (int) and a Score (int) property. I skip the rest of the details to keep it short. Now in my code, I have a huge List on which I need to do the following select (into a new List): I need to get the sum of all Hit.Score's for each individual Hit.ItemID, ordered by Score. So if I have the follo...
I have two tables: Toys and Games. +--------------------+------------------+ | Field | Type | +--------------------+------------------+ | toy_id | int(10) unsigned | | little_kid_id | int(10) unsigned | +--------------------+------------------+ +--------------------+------------------+ | Field ...
Hi, I'm new to Subsonic, I want to ask how to query with SUM? I know how to query for where condition such as below: Query qryCurOpcode = Station.CreateQuery() .WHERE("PRODLINE=PIECERATE_prodline") .AND("STATIONID=STNID") .AND("SHIFT=PIECERATE_shift"); IDataReader rdrCurOpcode = qryCurOpcode.ExecuteReader(); while (rdrCu...
How to do query and display the records until it reaches a certain number? Suppose you want to select student until the total sum of the student's money reaches 1000? Addition Student ID Student Name Student Money --------- ----------- -------------- 1 John 190 2 Jenny 290 ...
I want to calculate the sum of 1/1 + 1/2 + 1/3 + ... + 1/30 I run the code unsuccessfully import decimal import math var=decimal.Decimal(1/i) for i in range(1,31): print(sum(var)) I get the error 'Decimal' object is not iterable How can you make the iterable function in Python? ...
I've written a loop in C++ to give me 6 random numbers and store them in an array. What I would like to do is to sum the elements of the array until I get a value larger than a number, "x", but I would like to do this without necessarily adding all the elements. The objective is to find the first elements which sum to the value of x. ...
I am pulling data from one table, called analyzedCopy, and using it to over-rite all information in another table called analyzed. The columns I'm sorting/filtering/manipulating, are readings_miu_id, ReadDate, ReadTime, RSSI. I am currently moving data from analyzedCopy to analyzed using the following sql that to get only the last time(h...
The command tries to sum up the sizes: find . -iname "*.dmg" -exec du -sh '{}' \; 3&> /dev/null | awk '{print $1}' | summming_up_program??? Can you find a simpler solution? Ubuntu Solution. Thanks for the Awk-end to Ayman. find . -iname "*.dmg" -printf '%b\n' | awk 'BEGIN { s = 0 } {s += $1 } END { print "%dMB", s / 2^20 }' ...
How to find an algorithm for calculating the sum value in the array?? Is is Something like this? Algorithm Array Sum Input: nonnegative integer N, and array A[1],A[2],...,A[N] Output: sum of the N integers in array A Algorith Body: j:=1 sum:=0 while j<N sum := sum + a[J] j:=j+1 end while end Algorithm Array Sum And how ...
SELECT *, GROUP_CONCAT(rating) AS rating_total, SUM(rating_total) AS rating_sum, AVG(rating_sum) AS rating_avg FROM ratings GROUP BY pid For some reason the sum and average don't execute....how do you make this statement work? ...
Hello, I've a table (Consumption) as follows: DocDate ItemCode Quantity 01.01.09 A 5 02.01.09 A 6 and so on.. for the whole year I need results as follow: ItemCode Jan09Total Feb09Total Mar09Total The problem is that the quantities should be summed up for the months, which should be in columns and acco...