No announcements
Found 2934731 threads
-
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 | 2070 Views | Created by thanei - Friday, July 27, 2012 3:55 PM | Last reply by thanei - Tuesday, July 31, 2012 8:41 AM -
0 Votes
how 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 | 845 Views | Created by himalkumar - Friday, March 4, 2016 10:10 PM | Last reply by Sam Zha - Thursday, March 10, 2016 6:49 AM -
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 | 3061 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 to dataset having sum
LINQ has no special having clause, as it is implemented using a where condition after the grouping.Answered | 1 Replies | 2719 Views | Created by DerStauner - Sunday, July 7, 2013 6:30 PM | Last reply by Elmar Boye - Sunday, July 7, 2013 8:47 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 | 5601 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 | 5217 Views | Created by mtm81 - Monday, November 23, 2009 3:02 PM | Last reply by mtm81 - Tuesday, November 24, 2009 9:52 AM -
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 | 4058 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
Joining 2 Group by Select Statements
I didn't realize you could put your case statement in a SUM.Answered | 2 Replies | 3864 Views | Created by Codeitup - Monday, August 3, 2009 5:13 PM | Last reply by Codeitup - Tuesday, August 4, 2009 12:26 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 | 12702 Views | Created by Mathewsept - Friday, July 30, 2010 3:38 PM | Last reply by Ali Hamdar - Sunday, August 1, 2010 1:24 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 | 1838 Views | Created by Jeff_TBC - Wednesday, May 15, 2013 11:36 PM | Last reply by V Karthik - Friday, May 17, 2013 8:53 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 | 604 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
Linq Query to sum DataRows
How can we sum in this case?Answered | 3 Replies | 5083 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
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 | 781 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 | 5003 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 | 889 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 | 669 Views | Created by Anonymous - Thursday, August 27, 2020 3:25 PM | Last reply by Anonymous - Friday, August 28, 2020 9:10 AM -
0 Votes
Grouping Select Statement
;with cte as ( SELECT [Posting Date] , [Item No_] , SUM([Invoiced Quantity]) as TotalQty FROM [DukxxNAV].Answered | 8 Replies | 674 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 | 3815 Views | Created by Gopi kakileti - Monday, July 25, 2011 7:21 AM | Last reply by Sankarsan Parida - Monday, July 25, 2011 12:20 PM -
3 Votes
Help in Sum of Sum of Group
Best Regards, Lily MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, ...Answered | 4 Replies | 1503 Views | Created by Khan_K - Wednesday, June 17, 2020 5:06 PM | Last reply by Khan_K - Friday, June 19, 2020 4:02 PM -
0 Votes
Grouping by and also adding a sum
cr.PurchaseAmount) } ============================================================================================Answered | 2 Replies | 3253 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 2934731 Next ›
No announcements