No announcements
Found 2935364 threads
-
0 Voteshow to sum the select statement result
I just added missing ")". except of this, this code is Naomi's code, in one line ;with MyCTE as (select ceiling(count(*)*1.0/4) as MemberCount from #Result_1 ...Answered | 6 Replies | 758 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
Need help with an linq statement.
Hello, OK I used the Linqer Tool to generate the linq from my sql statement.Answered | 4 Replies | 1998 Views | Created by thanei - Friday, July 27, 2012 3:55 PM | Last reply by thanei - Tuesday, July 31, 2012 8:41 AM -
0 Votes
linq to dataset having sum
LINQ has no special having clause, as it is implemented using a where condition after the grouping.Answered | 1 Replies | 2616 Views | Created by DerStauner - Sunday, July 7, 2013 6:30 PM | Last reply by Elmar Boye - Sunday, July 7, 2013 8:47 PM -
1 Votes
Help with SUM two select statements into one
Run both selects into a temp table - adding a country column then select out of the temp table grouping by make/model and sum the count for each ...Answered | 3 Replies | 3001 Views | Created by Lino.DiNardo - Thursday, April 5, 2012 7:41 PM | Last reply by Lino.DiNardo - Thursday, April 5, 2012 8:06 PM -
0 Votes
Linq sum of multiple fields
select sum(fl1),sum(fl2),sum(fl3) where fl1 =cn1 and fl2=cn2 will change to Dim x = From p in db.YourClass ...Answered | 1 Replies | 12499 Views | Created by Mathewsept - Friday, July 30, 2010 3:38 PM | Last reply by Ali Hamdar - Sunday, August 1, 2010 1:24 AM -
3 Votes
select sum group
SELECT vch_paymod, SUM(val) as 'sum' FROM ( SELECT vch_paymod1 AS vch_paymod, vch_val1 AS val FROM vch UNION ...Answered | 4 Replies | 523 Views | Created by dev.basha - Thursday, October 27, 2016 11:26 AM | Last reply by Jingyang Li - Thursday, October 27, 2016 6:33 PM -
0 Votes
sum in linq
var k = (from Row r in tblSalary where r.customerID = xyz select r.pay).Sum(); it is "r.pay" and not "pay". provided r.pay ...Answered | 4 Replies | 5519 Views | Created by H.Aftabi - Sunday, June 27, 2010 4:17 PM | Last reply by Jegan Ravi - Monday, June 28, 2010 4:04 AM -
1 Votes
if statement within a SELECT to change SUM totals?
Something like this: create table #orders (id int, val int, dt datetime) insert into #orders select 1, 1750, '1 sep 2008' insert ...Answered | 2 Replies | 5131 Views | Created by mtm81 - Monday, November 23, 2009 3:02 PM | Last reply by mtm81 - Tuesday, November 24, 2009 9:52 AM -
0 Votes
Joining 2 Group by Select Statements
I didn't realize you could put your case statement in a SUM.Answered | 2 Replies | 3790 Views | Created by Codeitup - Monday, August 3, 2009 5:13 PM | Last reply by Codeitup - Tuesday, August 4, 2009 12:26 PM -
2 Votes
Sql to Linq Sum operations
Hi Warren, I noticed that you LINQ version does not have some of the where conditions.Answered | 1 Replies | 3972 Views | Created by Warren LaFrance - Thursday, March 18, 2010 3:09 PM | Last reply by Syed Mehroz Alam - Thursday, March 18, 2010 5:47 PM -
0 Votes
Linq Query to sum DataRows
How can we sum in this case?Answered | 3 Replies | 4375 Views | Created by wpf_xam1 - Friday, October 14, 2016 1:07 AM | Last reply by Zhanglong Wu - Monday, October 17, 2016 8:19 AM -
0 Votes
Select Statement 3 tables, and Sum of one column
You would need to group on only those values which are not-changing when you are trying to perform group operations.Answered | 4 Replies | 1764 Views | Created by Jeff_TBC - Wednesday, May 15, 2013 11:36 PM | Last reply by V Karthik - Friday, May 17, 2013 8:53 AM -
0 Votes
Linq - grouping by 2 columns
I managed to work a solution- Dim q = From p In sPreScoreTable Group p By Material = p("Material"), Accd = p("Accreditation") _ ...Answered | 3 Replies | 713 Views | Created by NachoShaw - Friday, October 30, 2015 6:05 AM | Last reply by NachoShaw - Wednesday, November 4, 2015 3:53 AM -
1 Votes
Linq query for distinct group sum
Hi, You can do first a group by the type and then sum the results, like the following.Answered | 6 Replies | 4520 Views | Created by wpf_xam1 - Monday, October 3, 2016 12:54 AM | Last reply by - Tuesday, October 4, 2016 5:52 PM -
0 Votes
Convert select statement to Linq
What you should do is use Linqpad and play until you are satisfied with your Linq query.Answered | 3 Replies | 781 Views | Created by brucey54 - Tuesday, October 20, 2015 9:05 PM | Last reply by Hardz Tarrayo - Wednesday, October 28, 2015 2:07 AM -
0 Votes
LINQ sum and group statement and select view model class
According to your linq query statement, it seems that you only want to group by MappedType, but the result of the Report Format you provide ...Unanswered | 2 Replies | 383 Views | Created by Anonymous - Thursday, August 27, 2020 3:25 PM | Last reply by Anonymous - Friday, August 28, 2020 9:10 AM -
0 Votes
SUM a LINQ Sub-query
Try this query: var results = from row in SalesDT.AsEnumerable() group row by row.Field<int>( "Site" ) into grp ...Answered | 10 Replies | 4078 Views | Created by BobbyZA - Thursday, January 7, 2016 2:57 PM | Last reply by BobbyZA - Sunday, January 17, 2016 5:17 PM -
0 Votes
Grouping Select Statement
;with cte as ( SELECT [Posting Date] , [Item No_] , SUM([Invoiced Quantity]) as TotalQty FROM [DukxxNAV].Answered | 8 Replies | 584 Views | Created by SteveWeberInKingsPark - Tuesday, January 19, 2016 7:26 PM | Last reply by SteveWeberInKingsPark - Wednesday, January 20, 2016 4:00 PM -
0 Votes
LINQ to SQL Classes and ADO.Net Entity Data Model
Works with Conceptual model of database 3.Answered | 2 Replies | 3725 Views | Created by Gopi kakileti - Monday, July 25, 2011 7:21 AM | Last reply by Sankarsan Parida - Monday, July 25, 2011 12:20 PM -
0 Votes
Grouping by and also adding a sum
cr.PurchaseAmount) } ============================================================================================Answered | 2 Replies | 3193 Views | Created by spnz - Monday, December 7, 2009 12:18 AM | Last reply by Michael Sun [MSFT] - Friday, December 11, 2009 1:13 AM - Items 1 to 20 of 2935364 Next ›
No announcements
