No announcements
Found 3836376 threads
-
0 VotesSum Function for non contiguous selection
You can look at this link for some great ideas of how to use VB.NET to interact with Excel.Answered | 2 Replies | 547 Views | Created by Gradient127 - Monday, April 13, 2015 4:00 PM | Last reply by ryguy72 - Wednesday, April 15, 2015 9:16 PM
-
1 Votes
How to use case when function with SUM function ?
CONVERT(VARCHAR(8),DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0),112) then LEAVE.SUM_DAYS else 0 END) AS TOTALDAYS Vinay Valeti| If you think my ...Answered | 1 Replies | 909 Views | Created by Caulson - Tuesday, October 22, 2013 2:33 AM | Last reply by Vinay Valeti - Tuesday, October 22, 2013 2:39 AM -
0 Votes
how to sum the select statement result
Performing an aggregate function on an expression containing an aggregate is not allowed.Answered | 6 Replies | 736 Views | Created by himalkumar - Friday, March 4, 2016 10:10 PM | Last reply by Sam Zha - Thursday, March 10, 2016 6:49 AM -
0 Votes
Sum function
select sum(case when ProdGroup = 'A' then TotalCost else 0 end) as TotalCost_A, sum(case when ProdGroup = 'B' then TotalCost else 0 end) as ...Answered | 5 Replies | 4141 Views | Created by zbiebu - Wednesday, July 21, 2010 12:10 PM | Last reply by Muhammad Abbas - Wednesday, July 21, 2010 12:26 PM -
3 Votes
SELECT query, 2 SUM functions with different conditions
Logically, the concept is that you select the superset of rows and use case expressions within your sum aggregates to limit the rows included in the aggregate.Answered | 5 Replies | 43959 Views | Created by juve1119 - Wednesday, August 28, 2013 10:03 AM | Last reply by juve1119 - Wednesday, August 28, 2013 12:45 PM -
0 Votes
sum inside case
Hi, Case statement is executed per row and here you are doing a group by on Buliding_Name, buliding_number to which you want to aggregate the balance based on a condition then you ...Answered | 1 Replies | 1770 Views | Created by CSharp Neophyte - Thursday, May 28, 2015 3:52 PM | Last reply by Vinay Manikanda - Thursday, May 28, 2015 4:12 PM -
0 Votes
How to select the sum of min Values?
Try with set1 as (select group_no,group_name, Balancedue,loanamount,row_number() over (partition by id,group_no order by Balancedue) ...Answered | 6 Replies | 1798 Views | Created by Madasamyponraj - Tuesday, December 4, 2012 4:57 AM | Last reply by Jackson_1990 - Tuesday, December 4, 2012 6:51 AM -
3 Votes
adding rows by using sum function
DECLARE @T TABLE ( Col varchar(50) ); INSERT INTO @T VALUES ('25 emails sent'), ('3 sms sent'), ('12 sms sent'), ('22 emails sent'), ('71 emails sent'), ('70 ...Answered | 2 Replies | 1087 Views | Created by manikanta6047 - Thursday, August 29, 2019 5:52 PM | Last reply by Guoxiong Yuan - Thursday, August 29, 2019 6:27 PM -
6 Votes
DataGridView Selected cells sum total
I am using the following code to determine integer datatype but it is giving me error if i select a string datatype cell.Answered | 7 Replies | 10242 Views | Created by LuxCoder - Tuesday, March 9, 2010 9:56 AM | Last reply by Alex Gallegos - Thursday, June 11, 2015 6:53 PM -
0 Votes
Calling Inline Table Valued Function inside AGGREGATE function (SUM,MAX etc..)
And then apply SUM() aggregate to it, like: ;with cte as (select AMOUNT * (select QTY from ...Answered | 5 Replies | 2973 Views | Created by Soori - Tuesday, July 19, 2011 1:02 PM | Last reply by Soori - Tuesday, July 19, 2011 3:09 PM -
0 Votes
SUM() function issue ?
Try the below: Select sum(A.Sal) From (Select SUM(S.sal) sal from #temp1 S where s.id=1 Union ...Answered | 16 Replies | 1730 Views | Created by Maggy111 - Thursday, September 13, 2012 8:58 AM | Last reply by Naomi N - Friday, September 14, 2012 12:34 PM -
0 Votes
Sum up or using functions of the values in ListBox
sum += (1 / ListBox1.Items(index)) is this the function code?Answered | 11 Replies | 6201 Views | Created by SouLReaPeR1992 - Tuesday, December 21, 2010 6:40 AM | Last reply by SouLReaPeR1992 - Tuesday, December 21, 2010 12:40 PM -
3 Votes
SELECT CASE & Custom Function
>Can this be done using a function with a CASE statement?Answered | 5 Replies | 2627 Views | Created by flexpadawan - Tuesday, April 17, 2012 7:31 PM | Last reply by --CELKO-- - Wednesday, April 18, 2012 12:53 AM -
0 Votes
problem with sum function in query
Another method to solve this would be to base the join on the two columns and to use CASE expressions to sum only when there is a match: SELECT ...Answered | 2 Replies | 5728 Views | Created by SqlNewbie12 - Monday, November 2, 2009 4:21 PM | Last reply by Plamen Ratchev - Wednesday, November 4, 2009 7:26 PM -
2 Votes
How to Recursively Sum a Sum?
Learn how to follow ISO-11179 data element naming conventions and formatting rules.Answered | 14 Replies | 1624 Views | Created by ryguy72 - Thursday, July 10, 2014 6:48 PM | Last reply by ryguy72 - Wednesday, October 8, 2014 1:18 AM -
1 Votes
Unable to use Previous in a Sum aggregate function
[Offer], 0 AS [User], 0 AS [Amount], SUM(t.Answered | 5 Replies | 480 Views | Created by GaryMha - Friday, October 21, 2016 4:50 PM | Last reply by Guoxiong Yuan - Friday, October 21, 2016 5:46 PM -
2 Votes
Another method of using the Sum function
Unless you have just started writing SQL, you should know use ISO-8601 Standards for temporal data, avoid needless dialect, basic data modeling and ...Answered | 6 Replies | 3756 Views | Created by sh 2020 - Saturday, July 23, 2011 6:40 PM | Last reply by Velmurugan.S - Monday, July 25, 2011 7:33 AM -
0 Votes
sum function ignore decimals
Round( Sum ( Fields!Answered | 7 Replies | 6024 Views | Created by krigare - Thursday, May 21, 2009 5:35 PM | Last reply by krigare - Friday, May 22, 2009 8:03 AM -
0 Votes
Nested functions, Sum of Last(mailboxcount)
Hmm there is no LAST function in SQL Server (are you using ACCESS?)Answered | 12 Replies | 1927 Views | Created by Ijaz Kazi - Saturday, June 7, 2014 2:25 PM | Last reply by Ijaz Kazi - Thursday, June 12, 2014 5:06 PM -
1 Votes
Needs a Sum distinct function
Hello, In order to meet you requirement, you can try to use the custom function to aggregate the distinct values.Answered | 5 Replies | 2010 Views | Created by Roopkumar Kamat - Thursday, February 14, 2013 6:31 AM | Last reply by Roopkumar Kamat - Wednesday, February 27, 2013 2:49 PM - Items 1 to 20 of 3836376 Next ›
No announcements
