No announcements
Found 2593396 threads
-
1 Votesaggregate functions
AND 20080630 GROUP BY wsshop; BTW, it almost seems you just need to change the predicate for the date and then all expressions will be ...Answered | 11 Replies | 3820 Views | Created by reneelacks - Wednesday, June 17, 2009 2:35 AM | Last reply by Plamen Ratchev - Wednesday, June 17, 2009 8:28 PM
-
0 Votes
SSRS countrow Aggregate error(Aggregate and lookup functions cannot be used in query parameter expressions.)
" Aggregate and lookup functions cannot be used in query parameter expressions." is because I am using CountRow to ensure that if all values of ...Answered | 5 Replies | 1894 Views | Created by Dedip Sanghvi - Wednesday, March 4, 2015 8:40 PM | Last reply by CSharp Enthusiast - Wednesday, March 4, 2015 10:14 PM -
3 Votes
Aggregate functions
Yes its certainly help but i need to know which employee is earning the most. This is the problem, when i removed the emp_id from outer query, the resulting tuple will be ...Answered | 5 Replies | 5207 Views | Created by mistic84 - Monday, January 12, 2009 5:58 AM | Last reply by mistic84 - Monday, January 12, 2009 3:57 PM -
0 Votes
Group filters and aggregate functions
scope for the aggregate functions, and I'm filtering on expressions that include aggregate values and cannot be specified at the data region or ...Answered | 6 Replies | 21087 Views | Created by R Eads - Wednesday, October 27, 2010 9:33 PM | Last reply by GeoffBarraclough - Sunday, October 31, 2010 10:37 PM -
0 Votes
Canonical aggregate functions in ProviderManifest.xml
functions should be also defined in ProviderManifest.xml (not only store specific). Is this still true in SP1 Beta (or in Final)? When I have no canonical aggregate ...Answered | 2 Replies | 4386 Views | Created by Jiri {x2} Cincura - Sunday, August 3, 2008 3:48 PM | Last reply by Jiri {x2} Cincura - Monday, August 4, 2008 6:08 PM -
1 Votes
Nested SQL Queries with Aggregates
I'm struggling to find a solution to a problem that I hope someone will help with. The questions is... List the Product ID, Product Name and Units In Stock of all products ...Answered | 2 Replies | 2062 Views | Created by BBoydAnchor - Wednesday, February 15, 2012 10:22 AM | Last reply by BBoydAnchor - Wednesday, February 15, 2012 11:07 AM -
0 Votes
Custom aggregate functions?
able to create my own custom aggrigate functions and use the same in the RunningValues funtion. It would be even interesting if the user can share ...Answered | 3 Replies | 9744 Views | Created by Adrian_Moore - Thursday, September 15, 2005 5:02 AM | Last reply by Giri - Monday, January 8, 2007 11:30 PM -
0 Votes
SSRS Aggregate Functions
suggest you could use the aggregate functions in the cube not in report designer. In general, aggregation is more efficient on the data source than during report ...Answered | 2 Replies | 5238 Views | Created by pmak - Thursday, June 2, 2011 12:02 AM | Last reply by Eileen Zhao - Friday, June 3, 2011 10:09 AM -
0 Votes
VS6TOVS2012 - non-aggregates cannot be initialized with initializer list
Hi Team, I am porting VS6 projects to VS2012. I wasn't able to fix the below Build Error error C2552: 'types' : non-aggregates ...Answered | 2 Replies | 1046 Views | Created by VS6toVS12 - Thursday, November 7, 2013 11:47 PM | Last reply by VS6toVS12 - Friday, November 8, 2013 10:36 PM -
0 Votes
Aggregates
or Publishers and degenrate dim Request from Fact table.This is working fine but now i want to do aggregate on this. Can anybody tell me how ...Answered | 3 Replies | 4862 Views | Created by JyotiKumar - Friday, July 4, 2008 7:33 AM | Last reply by Mangal Pardeshi - Friday, July 4, 2008 11:55 AM -
0 Votes
Survey - SPQuery - Aggregate Functions?
the survey for this data, but the survey stores every entry into the survey as a separate line... and CAML doesn't have aggregate functions. It seems as ...Answered | 1 Replies | 879 Views | Created by Enigmatic Intent - Friday, July 25, 2014 8:03 PM | Last reply by JasonGuo - Tuesday, July 29, 2014 4:42 AM -
1 Votes
simple aggregate functions
the data from the server as the user scroll down the datagrid , is that right ? how to calculate aggregate values in such cases , where the database tables has large ...Answered | 3 Replies | 1271 Views | Created by issam1975 - Sunday, December 9, 2012 12:41 AM | Last reply by Colin Blair - Monday, December 10, 2012 5:01 PM -
0 Votes
Aggregate Functions - multiply
You can create a custom CLR Aggregate to do this if you are on SQL Server 2005 or SQL Server Express, otherwise, yeah, a loop or cursor is unfortunately going toAnswered | 4 Replies | 6273 Views | Created by Eric Saboia - Wednesday, July 2, 2008 3:05 PM | Last reply by Eric Saboia - Wednesday, July 2, 2008 4:02 PM -
0 Votes
How to use Aggregate Functions
Hi, I'm building a silverlight web application using WCF RIA. I want to Know, How to use aggregate functions such as ...Answered | 1 Replies | 963 Views | Created by srinivasan ayyasamy - Sunday, October 30, 2011 6:59 AM | Last reply by Olivier Dahan - Sunday, October 30, 2011 7:45 AM -
2 Votes
nested functions
The problem is that if you enter the values like this x=2,n=5,p=0.167 if I don't nest the functions I receive the answers for x=2, 0.161 , for xAnswered | 13 Replies | 1945 Views | Created by Eduard77 - Friday, August 26, 2011 3:04 PM | Last reply by Eduard77 - Saturday, August 27, 2011 9:11 PM -
0 Votes
Aggregate Functions in Calculated Fields
values used in the quarterly and yearly calculations). I am not sure why aggregate functions are available when creating calculated fields if they cannot ...Answered | 3 Replies | 9514 Views | Created by Bonediggler - Tuesday, July 12, 2011 6:48 PM | Last reply by Lola Wang - Monday, July 18, 2011 2:38 AM -
0 Votes
Plans for SQL aggregate functions?
Are there plans to implement aggregate functions into the SQL query syntax? For example I'd like to be able to count the number of records which satisfy a where ...Answered | 3 Replies | 1714 Views | Created by Jason Vallery - Tuesday, August 26, 2014 3:12 PM | Last reply by Ryan CrawCour [MSFT] - Friday, October 30, 2015 6:12 PM -
0 Votes
Questions about SQL aggregate functions
what I would like to do is to run above SQL aggregate functions query for two different dates at the same time and I would like to get ...Answered | 2 Replies | 4283 Views | Created by max80 - Thursday, May 22, 2008 8:46 PM | Last reply by max80 - Thursday, May 22, 2008 11:38 PM -
0 Votes
Perform aggregate functions on Dataset
ODBC Connectivity and have the required data in a DataSet. The problem with Lotus notes is, it doesn't allow any aggregate functions to be performed on the data, ...Answered | 3 Replies | 4065 Views | Created by Srikanth.P - Thursday, July 13, 2006 4:17 PM | Last reply by David Hayden - Thursday, July 13, 2006 4:30 PM -
0 Votes
An INSERT EXEC statement cannot be nested
when I run the stored proc it throws an error. An INSERT EXEC statement cannot be nestedAnswered | 1 Replies | 1397 Views | Created by DougRay5 - Wednesday, February 25, 2015 10:08 PM | Last reply by Erland Sommarskog - Wednesday, February 25, 2015 10:43 PM
No announcements
