Answer Questions

• Jandost Khoso StrToMember performance issue

  I am building a parameterised report against a cube. After starting with an MDX statement that performed perfectly well and parameterising it the performance went downhill fast. I was able to replicate similar symptons against the Adventure Works cube. In this example I am getting sales values at 2 different dates and breaking them down by Sales Territory and Customer Geography dimensons. In fact they could be any dimensions, but I do need to add a crossjoin in order for the problem to show itself. WITH MEMBER Measures.FirstDateAmount as --([Date].[Date].&[32],[Measures].[Internet Sales Amount]) ( StrToMember ('[Date].[Date].&[32]'),[Measures].[Internet Sales Amount]) MEMBER Measures.SecondDateAmount as ([Dat ...Show All

• Tryin2Bgood BETWEEN LAPTOP AND DESKTOP

  Hi, I want to jumpstart my learning of SQL Server so I downloaded the Express edition onto my desktop in the office and also onto my laptop. I usually connect the two machines (through a LAN) to update whatever I was able to do at home while in the office. What should I do in order to view or edit whatever I started on the laptop from the desktop Would the databases I create on one be accessible through the other machine for editing and the likes Glint. hi Glint, you first need connectivity.. if that has to be performed at work, this is not a problem, as you just plug the office lan cable and you are on.. actually you do not need SQLExpress to be installed at all in the desktop pc as your ...Show All

• Coleby SQL Server 2005 code error

  Hey, I need someone to look at a small piece of code and tell me where I'm going wrong in SQL 2005 Server. Where should I post Thanks in advance, Danny Problem: When I run this I'm told NoOfContractsCount is an invalid column name when I try creating my cusor USE SLXDEV SELECT Count ( MCS2_CONTRACT . accountid ) AS NoOfContractsCOUNT , MCS2_CONTRACT . accountid , CONTACTID INTO #TempTable FROM sysdba . MCS2_CONTRACT , CONTACT WHERE MCS2_CONTRACT . accountid = CONTACT . accountid GROUP BY MCS2_CONTRACT . accountid , CONTACTID HAVING Count ( MCS2_CONTRACT . accountid ) > 1 DECLARE @CountTemp int DECLARE @accountIDTemp CHAR ( 12 ) DECLARE @ContactIDTemp CHAR ( 1 ...Show All

• AlanKohl Newbie question here - stored procedures

  Hi I just installed sql server 2005 for the first time today. Anyways I have a bunch of stored procs from an application i developed on the SQL 2000 server. Anyways I am having a problem with one of my stored procedures. CREATE PROCEDURE ProvinceRetrieveAdHoc ( @whereClause VARCHAR ( 256 )) AS EXEC ( "SELECT * FROM tblProvince WHERE " + @whereClause ) RETURN GO However this isn't working, I am getting this error: Incorrect syntax near 'SELECT * FROM tblProvince WHERE '. Now I am guessing the EXEC statement must have changed, as every stored proc that uses the exec command errors out with this same error. All my other procedures run just fine. Can anyone please tell me how to fix it ...Show All

• R.Tutus Future with SSIS

  Hi,   We have a NT service built via Visual Basic 6 which fires dts processes on demand according some criteria. Well, on the whole and basically only for the following rule: -dts process is executed when our service recognize a concrete plain file leaved in a folder. It’s generally generated for a mainframe JCL along with a activator file (.nul file, empty). Each application own a folder and each folder have lots of files as the aforementioned ones. Scheduler for that is an ASP application that lives within a intranet. It also is a monitor and logger   In that schema, keeping on mind that eight out of ten are ETL processes, critical ones and on daily-basis, our question is, how to handle on with this stuff using ...Show All

• Binu Jeesman SQL 2005 woes

  I installed VS 2005 & SQL Server 2005. When I use SQL Server Management Sudio,  I can create a new database in SQL Server 2005, but when I try to create a new table in that database, I get the following error: "Class does not support aggregation. Microsoft.Sqlserver.Sqltools.VsIntegration" any help would be appreciated. Thanks It happens when I create "the most basic" table, or open an existing table.  Yet when I do the equivalent from within the VS 2005 Server explorer, I can do create or view data with no problems. I am running the RTM versions of both products.  I also did uninstall VS 2005 Beta 1 sucessfully before installing the RTM products. ...Show All

• su45937 help

  hi i have table with folowing columns (subid,itemid) i want to write select stmt to get subid where itemid =all group of value('1','2') like this Select subid from subscriptionItem where itemId in all('1','2') but this stmt not work help me Hi, If you mean you want those SubID that have both ItemID 1 and 2, then the above will not work. what you should is.. Select SubID From subscriptionItem Where ItemID in (1,2) group by SubID Having count(0) =2 Assuming that the combination SubID and ItemID is primary (unique). If they are not unique, which I doubt, then try: Select SubID FROM (Select distinct SubID, ItemID from SubscriptionItem where ItemID in (1,2)) si Group by Sub ...Show All

• KarimRadi Data Flow: Converting data in multiple columns

  Hi, I'm just wondering what's the best approach in Data Flow to convert the following input file format: Date, Code1, Value1, Code2, Value2 1-Jan-2006, abc1, 20.00, xyz3, 35.00 2-Jan-2006, abc1, 30.00, xyz5, 6.30 into the following output format (to be loaded into a SQL DB): Date, Code, Value 1-Jan-2006, abc1, 20.00 1-Jan-2006, xyz3, 35.00 2-Jan-2006, abc1, 30.00 2-Jan-2006, xyz5, 6.30 I'm quite new to SSIS, so, I would appreciate detailed steps if possible. Thanks. I think Unpivot tranformation cam deliver the same funcionality you put in your script components; but the multicast; the sort and merge join would be required anyway. Rafael Salas Ok, I have fou ...Show All

• WidgetWorking reporting services

  hi, i have to do some reports of a database sql server 2000 with visual studio 20003 reporting services, The question is: as the possible Query are a lot, what is the criterion to adopt to choose the Query for populate the Reports You are kidding right Ask you boss What does he need the reports for ASking him will help you to meet his expectations. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Hi, could you explain that abit in detail HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- my boss told my to do some reports, but don't told what to put in reports, so what usually is reported in a report: eg ...Show All

• Big Bob Cooley Error in Derived Column component

  I am getting this error, [Derived Column [192]] Error: Converting an input column from type DT_STR to type DT_WSTR failed. An error occurred while performing the implicit conversion on the input column. But I don really understand y there is a attempt to type cast at all Please advise .... thanks in advance Thx for the reply :) In the Data Conversion transform UI, in the Data Type drop down, you should see an option: Unicode string [DT_WSTR] Mark In the column marked Data Type in your Derived Column Shape change the value from Unicode [DT_WSTR] to string [DT_STR] Does this answer your question The expression evaluator almost always i ...Show All

• USJOHN Change SA password. Any effect to replication?

  Dear all, I have some questions regard subject above. I want to know the impact of replication process after SA pasword been changed. Example: server1 (hq), server2 (district) & server3 (district). If server1, SA password been changed, is it server2 & server3 need to change too may i know where is it the replication SA password stored is it replication script refer ID (SA) from Security -> Logins I hope someone can help me.. thanks. changing the Sa password would not harm the replication process ideally... replication is using the account used by the sqlserver agent services. to know what account is your agent services running. click start>run>type "services.msc">look for ...Show All

• Atlantaazfinest SSIS Package will not execute when DontSaveSensitive protection level is selected

  Hi, Can anyone explain to me why my ssis packages will not work when DontSaveSensitive protection level is selected My package configurations are set as SQL server configuration type, and I have a table in a database that contains all the sensitive information (passwords and such). If I select "EncryptSensitiveWithUserKey" everything works, but I will be the only one able to execute the packages (not good, I need others to be able to execute them as well). The error I'm getting tells me that the connection is not configured correctly or I may not have the right permissions on the connection. My guess is that the DontSaveSensitive drops the passwords, but when I edit the data source and re-enter the password, it still do ...Show All

• Strakian Error Processing Cube on 64-bit server

  We are in the process of migrating to a new 64-bit server. We changed the data provider for the cube from "Microsoft OLE DB Provider for Oracle" to ".Net Provider\OracleClient Data Provider" for the 64-bit and when we try and process this cube, we get the following error: Errors in the high-level relational engine. The following exception occurred while the managed IDataReader interface was being used: Value was either too large or too small for a Currency.. This very same cube was able to process on the 32-bit server just fine. The field that the error refers to is a number(28,0) in oracle and is fully populated in the database. I set up a simple cube on my laptop and if I cut the value in the field down to 15 ...Show All

• zille HTTP File Upload

  I'm looking for a way with Integration Services in SQL'05 to upload a file. How could I do this Is there any examples out there This partuclar HTTP Server has WEBDAV configured so if I could just point to the URL location and new FILE that would be excellent. Thanks WebDav is just basically a way of allowing you to copy files over http. So if you can connect through a website in Internet Explorer or create a "My Network Places" folder to copy files that way. What you posted looks interesting.. not sure why webdav wouldn't be a built in component though If you could find a VB.Net code sample then you could probably do it through a Script Task. ...Show All

• tbthtbth Hi

  I have a field that I would like to only display the date as mm/dd/yyyy. Current field shows mm/dd/yyyy hh:mm:ss AM. I would most likely create a view that will create a field that will display the date only. Answered there: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=619822&SiteID=1 ...Show All