aggregation question

Transact-SQL

Index ‹ SQL Server

- Previous
  - 1
    - Merge replication reinitialization deleted all data sorry, your data is gone. I also find it hard to believe your data didn't get uploaded - how did you indicate you wanted the data uploaded Was this reinitialized from the UI Tag: aggregation question
  - 2
    - How to create a SAPConnection in .Net Code with .NET Data Provider Assembly Microsoft.Adapter.SAP.SAPProvider Tag: aggregation question
  - 3
    - What advanced features can be built with code in SQL Server 2005 Reporting Services? You can apply advanced features by building a custom front-end for Reporting Services, or building custom extensions for behind-the-scenes work. Here is a link to the custom extensions available. http://msdn2.microsoft.com/en-us/library/ms152934.aspx In addition, you can add assemblies and write code for custom calculations & functionality within a report. You can also implement custom controls such as graphs within the report. What specific functionality are you looking for Please have a look at the Reporting Services partner site for some further examples of custom coding. http://www.microsoft.com/sql/technologies/reporting/partners.mspx cheers, Andrew Tag: aggregation question
  - 4
    - Accessing a real table from inside a TV UDF What's the exception you are getting when trying to open the connection Niels Tag: aggregation question
  - 5
    - Adding a article causes ALL articles to be refreshed This is the default behavior for anonymous subscribers. IIRC through the GUI for named subscribers a complete snapshot will be generated. However if you use sp_addarticle only the mini snapshot for the one table will be generated. Tag: aggregation question
  - 6
    - Making a report smaller...? How about this: Select the first third of the data as a field for your dataset (you'll need some index field in your data to indicate how much data you've selected). Call it say, Column1. Select the second and third part of the data similarly as respective fields accordingly. Call these Column 2 and Column 3. Then set up a table or matrix with fields for Column 1 2 and 3. Tag: aggregation question
  - 7
    - Connect to SQL Server from a PDA When connecting to SQL Server from Compact Framework code using the SqlClient, you should not use the DNS name of the server but rather Data Source = {IPADDRESS}/{SQL INSTANCE NAME} and make sure you have used the SQL SERVER CONFIGURATION TOOLS to enable remote connections and the TCPIP protocol to the running instance of SQL SERVER. So if my machine is 204.21.46.34 and my SQL Express instance is the default (SQLEXPRESS), I'd need to use Data Source = 204.21.46.34/SQLEXPRESS in my connection string. If that does not resolve your issue, please post the exception details because something else may be going on. -Darren Tag: aggregation question
  - 8
    - Installing Express toolkit hi, if you are running on Vista, the problem could be related to privileges required running devenv.exe.. you can try what's reported here , even if not strictly related to BIDS .. regards Tag: aggregation question
  - 9
    - SQL using 2003 AD Groups I know this scenario (access via domain local groups) works in SQL Server 2005, but to be honest I don’t remember the behavior in SQL Server 2000 and I don’t have the proper SQL Server 2000 environment at hand to verify it. As SQL Server uses the regular Windows APIs to call the AD, I would guess it should work as long as the API available at the time SQL Server 2000 was created also supported DLGs. I am not familiar with the SQL Server 2000 tools, but it may be possible that the browser is only looking only for users and builtin principals but not for groups in the AD; make sure to check the tool’s documentation to find out if there is an option to enable group browsing/lookup. An alternative in case the tool doesn’t work as you expect or you cannot change the settings is to grant permission to connect directly using T-SQL; in SQL Server 2000 you can use sp_grant login for this purpose: http://msdn2.microsoft.com/en-us/library/aa933411(sql.80).aspx Please, let us know if you encounter any problem using sp_grantlogin and we will be glad to assist. Also, in case you have any problems let us know your environment (OS version, SQL Server 2000 SKU and SP version) so we can reproduce the problem. Thanks, -Raul Garcia SDE/T SQL Server Engine Tag: aggregation question
  - 10
    - How to find out PublicKeyBlob Use 'sn -Tp assemblyfilename' from a VisualStudio command prompt. Tag: aggregation question
  - 11
    - SQL Server Windows Auth for ETL called by CreateProcessAsUser This is the NTLM "double-hop" authentication problem. The impersonated credentials cannot be sent to a third machine unless the Kerberos protocol is used. http://blogs.msdn.com/nunos/archive/2004/03/12/88468.aspx http://blogs.msdn.com/knowledgecast/archive/2007/01/31/the-double-hop-problem.aspx Tag: aggregation question
  - 12
    - deAttach database You can detach a database with code but SQL Server service must be running because if it is not running, you cannot access anything in SQL Server. Try the link below for details about attach and detach database in SQL Server. Hope this helps. http://msdn2.microsoft.com/en-us/library/ms187858.aspx Tag: aggregation question
  - 13
    - Cannot add a new folder under a Reporting Server Project You will have to create another project for that and set the different settings in the deployment properties to make it work. I asked sometime ago for this feature, but it wasn’t implemented yet. if you are also interested in that, place a feature request in connect.microsoft.com and I will vote on it. Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: aggregation question
  - 14
    - Generic calculated measure The standard SSAS Time Intelligence enhancements provide this type of capability: http://msdn2.microsoft.com/en-us/library/ms175440.aspx >> SQL Server 2005 Books Online Defining Time Intelligence Calculations using the Business Intelligence Wizard The time intelligence enhancement is a cube enhancement that adds time calculations (or time views) to a selected hierarchy. This enhancement supports the following categories of calculations: Period to date. Period over period growth. Moving averages. Parallel period comparisons. ... Apply Time Views to Members On the Define Scope of Calculations page, you specify the members to which the new time views apply. You can apply the new time views to one of the following objects: Measures Instead of specifying an account dimension, you can specify the measures to which the time views apply. In this case, select the views to which selected time calculations apply. For example, assets and liabilities are year-to-date data; therefore, you do not apply a Year-to-Date calculation to assets or liabilities measures. >> Tag: aggregation question
  - 15
    - SSIS Randomly Empties Out Column Data While Using Flat File Source Sounds strange. Does it definately only happen when executing from the API If you can build a repro then you would do well to submit it to http://connect.microsoft.com and talk to Product Support Services (PSS). -Jamie Tag: aggregation question
  - 16
    - Validating the parameter text box There is no way to validate parameter fields though the reporting services itself will throw an error if you entered an invalid date in date parameter provided you have defined the datatype of that parameter as datetime. Also you can use IsDate() function in any of your expression to check if a given expression is a valid date or not. Also, you cannot change the length of the parameter boxes. Shyam Tag: aggregation question
- Next
  - 1
    - date output format Hi Vincent, Try to use = "Total work time from " & CDATE(Parameters!DateFrom.Value).ToString("dd/MM/yyyy") & " to " & CDATE(Parameters!DateTo.Value).ToString("dd/MM/yyyy") Tag: aggregation question
  - 2
    - how to change the actual data filename hi, please have a look at this article on how to move user's databases .. ALTER DATABASE syntax support both logical and physical rename of database and database's files.. regards Tag: aggregation question
  - 3
    - MSResultSetGenerator does not work any more I have the same problem and it seems that when I try to generate the data source with an empty sql mobile database it works. When I add tables to the database it does not. This suggest to me that it must have something to do with the naming conventions of the database tables and/or fields. I'm trying that next. Did you make any progress Please report Tag: aggregation question
  - 4
    - Best Practice for Counts/Distinct Count Measures for Filtered Data These 2 alternatives do not produce the same results. If a given SKU has fact records in Jan, Feb, and Mar, the first approach using SUM would return a value of 3 for Calendar Quarter 1. Then second approach based on a distinct count measure would return 1 (which is probably what you want) Distinct count measures should be implemented in their own measure group anyway, so if you only ever need the active count then filtering out the non-active records is a good option. If you need to get distinct counts of both active and inactive SKUs then you would be better off adding the Active flag as an attribute to the product dimension and implementing it as a slowly changing dimension. Tag: aggregation question
  - 5
    - another dynamic assembly loading problem (XmlSerializer) Your code works fine for me. Are you sure you are creating the XmlSerializers assembly correctly under SQL Server When you turn "Generate Serializaton Assembly" to on under VS, it will create the assembly but not deploy it to the database for you, so you need to create it yourself like so: create assembly [TestClass.XmlSerializers] from 'c:\assemblies\TestClass.XmlSerializers.dll' Also, what is the exact error message and call stack you are getting Steven Tag: aggregation question
  - 6
    - How do you add multiple data sources to a report? You would need to create a separate dataset for each data source Tag: aggregation question
  - 7
    - How to capture error upon connect error? Add a Try-Catch construct to your code: Try oServer = CreateObject("SQLDmo.SqlServer") oServer.LoginSecure = True oServer.Connect(oName) Catch ex As Exception MsgBox(ex.Message) End Try Tag: aggregation question
  - 8
    - Server Upgrade You will have to build the Cluster nodes from the ground up. You don't really 'upgrade' to a cluster. You migrate. When you successfully have your cluster node(s) established, then backup up the existing database and RESTORE...WITH MOVE... to the clustered instance. (You can also use DETTACH, xcopy, and ATTACH/) Here are some support documents on Clustering SQL Server: Cluster - Guide to Creating and Configuring a Server Cluster Under Windows Server 2003 http://www.microsoft.com/downloads/details.aspx familyid=96F76ED7-9634-4300-9159-89638F4B4EF7&displaylang=en Cluster - How to Configure Virtual Server 2005 in Order to Setup a Test SQL Server Cluster http://www.sql-server-performance.com/installing_sql_clustering_virtual_server1.asp Cluster - Installing a Failover Cluster http://msdn2.microsoft.com/en-us/library/ms179410.aspx Cluster -Mountpoints http://support.microsoft.com/kb/280297 http://support.microsoft.com/kb/898790 http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx http://support.microsoft.com/kb/819546 Cluster -Move to a new SAN http://msmvps.com/blogs/clusterhelp/archive/2005/08/05/61741.aspx Cluster -Patterns and Practices, High Availability http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx Cluster -SQL Server 2000 Failover Clustering http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx http://www.sql-server-performance.com/sqlserver2000_clustering_install_main.asp Cluster - SQL Server 2005 Failover Clustering White Paper http://www.microsoft.com/downloads/details.aspx FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en Cluster - TechNet Support WebCast: How to cluster Microsoft SQL Server 2005 by using Microsoft Virtual Server http://support.microsoft.com/default.aspx kbid=891798 Cluster - Using Microsoft Virtual Server 2005 to Create and Configure a Two-Node Microsoft Windows Server 2003 Cluster http://www.microsoft.com/technet/prodtechnol/virtualserver/deploy/cvs2005.mspx Cluster http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx#EUEBG http://www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp http://www.support.microsoft.com/ id=254321 http://technet2.microsoft.com/WindowsServer/en/Library/70eba3d3-dca0-453b-a8c2-aa02220064891033.mspx mfr=true Tag: aggregation question
  - 9
    - How to reflect base table changes in cursor Ashish, Most likely, you don't need to be using a CURSOR. Please post the code that executes for the CURSOR position, and perhaps we can help you do the same task in a SET based operation -which will be faster and less disruptive than using a CURSOR. Tag: aggregation question
  - 10
    - Memory allocation error while processing cubes Preston, which version of SQL Server Analysis Services are you running Did you install the latest service pack --Artur Tag: aggregation question
  - 11
    - Performing insert / update queries using Pocket PC / SQL CE Keep in mind that the SDF file may be deployed whenever you run the app on your mobile device/emulator. Any inserts or updates done in the copy on the device will therefore not be visible when you stop the app again, since the database file is not copied back to your development machine. Tag: aggregation question
  - 12
    - Page Break stops working after adding condition in Hide property http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2000542&SiteID=1 Tag: aggregation question
  - 13
    - REPLACE Arguments not context or sample DDL or data but how about something like SELECT CASE CAST ( m . UserLevelID AS varchar ( 10 )) WHEN '5' THEN 'Officer' ELSE '' END Tag: aggregation question
  - 14
    - How to schedule to run Integration Packages using SQL Agent/Job? Yes there is. Most problems experienced when using SQL Agent to run packages are down to the package being run as a different user. Is that what you are doing -Jamie Tag: aggregation question
  - 15
    - Question on joins Code Snippet select AcctNo,count(*) from ( select AcctNo, 'A' as Table from TableA union all select AcctNo, 'B' as Table from TableB union all select AcctNo, 'C' as Table from TableC union all select AcctNo, 'D' as Table from TableD ) as [SubQuery] group by AcctNo having count(*) > 1 Tag: aggregation question
  - 16
    - microsoft visual studio cannot shut down because a modal dialog is active We are trying hard to get this to reliably reproduce. We think it is the dialog box that tells you that the data set needs to be released. Have you seen any patterns Tag: aggregation question

lijun

Aggregation SUM adds the numbers together. Is there a similar aggregation function that returns the product of all the numbers

Thanks

Top

Re: aggregation question

Kent Waldrop Ap07

No, there is no built-in PRODUCT aggregate. One thing you could try is taking the exponent of the sum of the logs of the individual rows; however, this will tend to cause arithmetic execution errors if any of the individual rows have zero for a value.

Here is a similar discussion:

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=355075&SiteID=1

Top

Re: aggregation question

Arnie Rowland

Do you mean 'product' as in factorial

Top

Re: aggregation question

Umachandar Jayachandran - MS

Check out the link below for a solution that uses the built-in aggregates to compute product:

http://www.umachandar.com/technical/SQL6x70Scripts/Main21.htm

You can also write a SQLCLR aggregate in SQL Server 2005 to do the same.

Top