Answer Questions

• su45937 Calculated measure based on field in fact table that is not a measure in cube.

  I have several fields in the fact table that are not measures in a cube. In this case I have a OrderEntryDateId, WantDateId, and InvoicedDateId. If the order has not invoiced the InvoiceDateId is 0 (zero). My cube joins the fact table to the time dimension table on the wantDateId. The cube has measures for feet, dollars, pounds, material cost... I want to create a calculated measure called "Invoiced Dollars" that is based on iff(invoiceDateId>0;TotalDollars,0) however invoiceDateId is not a measure nor is it linked to time in this cube. Any ideas Hi. You could make the InvoiceDateID a member property of time dimension at the leaf level. You can then check the member property val ...Show All

• xishan shigri subscription with foreign key relationship - is it possible?

  I have a following questions about notification services: I need to create a subscription with parent-child relationship. For example we have the following two tables to represent the subscription: <Subscription> - subscriberId - subscriptionId ,,, other details <SubscriptionState> - subscriptionId - stateId and event data has the following: <EventData> - EventBatchId - EventId - stateId ... other details and the matching rule (very simplified example) will be something along the lines ... AND <EventData>.stateId IN (SELECT stateId FROM <SubscriptionState>) As far as I can see there is no way to create a subscription rule like that. My guess is that I need to create custom tables, stored p ...Show All

• dteviot Data encyption using symmetric keys outside SQL Server

  Hello. I have a problem that spans VB.net, SQL Server and SSIS but is rooted in the need to encrypt column data in SQL Server. I would like to encrypt data that I am bringing into SQL Server in the Data transformation script component of an SSIS package. I have achieved this but I can't decrypt the data because the keys don't match. I would like to use symmetric key encryption but I don't see how to get the symmetric key that I created in SQL Server available to the VB.net script component in SSIS. Please advise me if my approach is correct and what steps I need to take. Here is a link that should be useful. In this link the author was also using ASYMMETRIC KEYS in SQL Server and VB .Net: ht ...Show All

• Yorker Generate documentation of tables and columns?

  Is this possible the tables has a field called description and so does the columns. I need to generate a data dictionary. May i know the string which you are calling from command line I think this is fixed in the latest version on the elsasoft.org site, although the build number is the same at 2.0.20. Can you download the version on the site and see if this still repros I think your connection string is wrong: Executing query to: server = (AHADMD01) ; database = AHAWEEKLY ; Trusted_Connection = yes ; should be: Executing query to: server = AHADMD01; database = AHAWEEKLY ; Trusted_Connection = yes ; that is, get rid of the parens. I thi ...Show All

• dnyandeo AMD vs. INTEL

  dear folks, A few days ago I heard from microsoft’s consultant a great disavantatge between Intel and AMD 64-bit processors when you manage sql25k and obviously other server applications. He stated that AMD could reach the hightest point around 1TB of RAM otherwise Intel only 64 Gb. AMD have a unique bus for all the processors (40 bit) whereas I ntel architecture works in star (34 bit) Is it true TIA thanks. we've selected a intel 64-bit cluster for our business as a migration of our old active-active cluster. I don't think that it will be noticeable in terms of our on-daily basis because never have demanded the full capabilities to our system so that... http://www.sqlmag.com/Article/ArticleID/50365/A_Tal ...Show All

• antonisK SSIS Performance Issue

  Hello, I have been running massive ssis packages and testing the performance. This is my execution design: I have a main package that gets a list of packages to execute from a table. Then using a foreach loop in send the package to execute ( somewhere in the middle i delete the corresponding old log file for that package ), each of the packages configures themselves from the parent package variables. What i have been analysing tells me that for example a package runs in 2 minutes and then the time wasted from the end of the package to the start of the other task is in average 3 to 6 minutes... thats alot... since i run about 20x12 packages witch gives me of wasted time about 20 hours. My question is... what can be causing ...Show All

• Loki70 How to define multi-valued 'default value' parameters for a report on the ReportServer

  Can someone please explain how i would define a multi-valued default parameter within the report Properties -> Parameters. I have an OLAP based report with multi-value parameters. I do not want to set the default values from within BIDS. Instead, I'd like to do this from the ReportServer (after report deployment). I have no problem when i enter a single value as a 'default value', for example: ReportParm1 String [Deal Dim].[Shelf].&[AAM] But, how would i define it with multiple values as a 'default value' , for example: ReportParm1 String [Deal Dim].[Shelf].&[ABC] , [Deal Dim].[Shelf].&[DEF] NOTE: It appears that you cannot use expressions, such as the 'split' function in the 'default value' space. Any ...Show All

• stak32 Four-Part Name Requirements for OLE DB Providers

    Could any one pls Explain about the Four-Part Name Requirement for  OLE DB Provider. Thanks -Sivaraman Latchapathi Did that answer your question HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- DO you need an explanation on the for part name or any insights of the OLEDB provider THe four part name is nothing else than the full declaration of the aquirering object: ServerName.DatabaseName.SchemaName.Objectname The identifiers may vary from source system to source system as there is something like a library in DB2 You probably would have to combine the dateparts to a complete date to keep the logic of comparing a date, so it woul ...Show All

• Rahul Garg ORDER BY, only orders by the first character?

  Hi, I am using a stored procedure that is databound to a dropdownlist. The stored procedure works fine, aside from the fact that the ORDER BY only sorts the list of items using the first character in the cell. E.g. The numbers 1, 20, 100 and 200 would be ordered as follows: 1 100 20 200 clearly i am doing something wrong and i apologise if it is a stupid question, but could anyone please offer me some help Thank you, Shep If your are only using the single rightmost character ( as in your examples) as alpha, then the following may work for you. BOTH strip off the last character, AND convert to an Integer ONLY in the ORDER BY clause. DECLARE @MyTestTable table ( MyCo ...Show All

• Walter30140 How to get DBName, IP, Domain Name, Data Path and stop services

  How can I get dbname ip domain name Data path using TSQL. how can I stop services using TSQL Emad Hi, I guess these views won’t give you the information back if you are using any other protocol than TCP/IP. Perhpas this article helps you to find out the information: http://sqlserver2005.de/articles/3/ HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- If you are using sql server 2005 you can use the dynamic management view sys.dm_exec_connections. ( http://msdn2.microsoft.com/en-us/library/ms181509.aspx ). Run select * from sys.dm_exec_connections to get the ip of the both the server and the connecting host. By Dath path if ...Show All

• Renis Cerga exec a ssis pkg from java or .net application

  hi, does anyone know if an ssis pkg can be executed from a java or .net application If running a .net app from a citrix server, would any componenets need to be installed like they had to be for DTS in SQL 2000 I keep trying to find some info on this and can't find anything. Thanx, Mike I think you meant DTExec, not DTSexec. You can execute packages using the DTSExec program and passing it command line arguments. And this could be done in any windows application where you can invoke the DTSExec program, including .NET and Java applications. ...Show All

• Cory Cundy Data Mining : Drug Trial Question

  I have a a simple situation. I am trying to determine for how long (in months) two drugs should be given to a patient. Both the drugs are administered at frequent intervals and their dosage and the condition of the patient is recorded. How do I determine for how long should I continue to adminster the drugs,at what point should I stop I am dealing with the following variables : Drug 1 dosage,Drug 2 dosage, Period of medication (in months). Can I use SQL Server 2005 data mining capabilites to get the answer Please let me know. You could use Logistic Regression, Neural Nets, or Decision Trees. DT will give the most understandable model. I would try all three and use the accuracy chart to see which model does the best job at predic ...Show All

• su45937 Joining two tables with repeating rows

  Hi. I am trying to get data from two different tables. The first table contains user access data for access to different modules of our application. There are only records for the modules that the user has access to. So if User1 can only access 2 of the 5 modules, there will be 2 User1 records. The second table lists the modules. UserAccess table: UserID ModuleID AccessLevel User1 1 1 User1 2 1 User2 1 1 Modules table: ModuleID Description 1 Mod1 2 Mod2 3 Mod3 4 Mod4 5 Mod5 What I am trying to select is a list of all modules for each user, whether they have access or not. So basically I would like the data f ...Show All

• Nassir DROP DATABASE problem

  I am facing a trouble with DROP DATABASE command. Let me explain it this way: Actually I am building an installation package which executes a series of SQL scripts to do the database changes on the target machine. Steps are briefly listed below: 1 - Create a database with simple CREATE DATABASE command 2 - Restore the database created above with RESTORE DATABASE command (with replace option) 3 - Configure other objects such as logins etc etc. Now, everything works fine as long as all the scripts execute correctly. However, I have seen instances when RESTORE DATABASE fails with "timeout expired" error. Well, I overcame this problem by simply increasing the timeout limit. But in that course what I observed is that when a restore da ...Show All

• Joe H Using SQL Server CE in a NON .NET Delphi Application

  Hi, I'm looking at using SQL Server CE as a replacement for MS Access in a WIN32 Delphi Application. This limits my database options to Providers that is usable from ADO. I see that the OLE DB Interfaces are implemented, but I can't connect to a SQL Server CE database from Delphi. I've cut and paste a sample connection string (replacing the data source bit) but no go I've installed the Runtime Environment, VS2005 bit, Connectivity Tools and the SDK :) Any help Anything that I might have missed Thanks, Dawid Still doesn't help me as the new version does not support Delphi 6 D. Delphi 2006 patches are up to date. Why is SQL Server CE not listed as a n ...Show All