Answer Questions

• pn123 storing values

  I want to store the whole values returned by a while loop. How to do this my store procedure is like this create proc start_proc @country varchar(20), @c_code int, @p_id int, @out_put varchar(500) output as if exists(select start_date from new_start where country=@country and country_code=@c_code and program_id=@p_id) begin set nocount on declare @@msg1 datetime Declare out_put cursor local Scroll Keyset Optimistic For select start_date from ne ...Show All

• fightingzero How to create a datasource which Connection type is SQL Server Anlysis Service in rss script?

  I am making a rss script to deploy the reports and datasources. I need to create a datasource which Connection type is SQL Server Anlysis Service. Thanks. I assume this has already been resolved but for anyone else; Create a Datasouce in VS (or BIDS) of the Connection Type that you require and then open up the resulting .rds to view the resulting connection type code. i.e. For Analysis Se ...Show All

• tanis15063 SQLEXPRESS default Owner wrong

  I'm getting the "This database does not have a valid dbo user or you do not have permissions to impersonate the dbo user,...." error message when trying to add a Database Diagram from Visual Studio Server Explorer. I can add the diagram without a problem from SQL Server Management Studio Express CTP. When I view the properties of the database in VS, the owner shows as XYZ\MyOldUserName. This is wrong. I just added this database t ...Show All

• Rabarbers How to Delete Files on Maintenance Plan

  Hello, I am creating a Maintenance Plan in SQL Server 2005. The 'Back Up Database Task' has the choice 'Create a sub-directory for each database' as SQL Server 2000 does. But when I add a 'Maintenance Cleanup Task' I do not see a choice to delete files on subdirectories. Looks like it only deletes the files from the directory I specify. So, looks like SQL Server 2005 is removing some functionality already available in SQL Server 2000. ...Show All

• tpack What use ScdStartDate/ScdEndDate/ScdStatus/ScdOriginalID?

  Hi, In AS2005 one can set the Type property of attributes to ScdStartDate/ScdEndDate/ScdStatus/ScdOriginalID for type 2 slowly changing dimensions. What, if any, effect does this have I can not see that it does anything in either the VS cube browser or in Panorama 5. Are there any other clients that make use of these settings, or am I missing something Thanks!Kristian So what are these tools that can interpret these ...Show All

• dEkS Passing a report parameter to Reporting Services from VB

  I have a Report that I want to access that has a parameter input for the date, Production_Date. I want to allow the user to use the DateTimePicker to select the date to use for Production_Date. I can't seem to find the correct way to format what I'm tring to do. My production date field is in a format without punctuation so that it becomes: Dim ProductionDate = ((DateTimePicker1.Value.Month * 1000000) + (DateTimePicker1.Value.Day * 10000) + ...Show All

• Jason E Please tell me you are joking - All member multivalue parameter

  In 2005 SP1, there is no longer an automatic <Select All> option for multivalued parameters. You now need to modify the dataset providing the values for the prompt and modify the dataset containing the parameter. This makes no sense! I am so confused. It was working fine. Why did you have to go and mess with it If you want to add value somewhere, try making the width of the drop down box for multi value parameters resize to the text in th ...Show All

• B. Clubb CLR Enabled

  Can anyone tell me what this means and how to fix it I created a stored procedure in VS2005 and did a build. When I went to SQL Server there was the stored procedure but when I run it I get the error.... Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option I changed the 'clr enabled' property to 1 using sp_configure but I still get this error. Thanks Mike Thank you again Gorm! &nb ...Show All

• rob444 Datetime behavior

  Hello, i'm using SQL Server 2005 Ex SP1, i would like to ask may be newbie question. On some machine have to input query in this datetime format '21.6.2006' and on the other one in '2006-06-21'. Collation setting is on both the same. What's dependin on, please Thank you for any help. YES! That's it. Thank you Jens, for your kind and fully qualified help. The formats in ...Show All

• nielsvdc1 Instead Of Update Trigger w/ Self-Referencing Table

  Setup: Using SQL 2005 Oh, just to add on, I found that if I went to the self-reference relation and set "Enforce Foreign Key Constraint" to "No", that "solves" that issue. I hesitate to use "solve" as it could very well cause tree structure issues later on if I manually do stuff to the table. Nathan Shoot Louis, My code should have updated if ID=1, not 2. T ...Show All

• ShyamN How to create an SSIS package correctly by programming?

       Recently I try to create a package completely by c# code,not the ETL tool.      The package is designed to transfer data from source table to destination table.      And I wrote the following codes by referring to the msdn library,but unfortunately,it doesn't work.       //this is my code //////////////////////////////////////////////// ...Show All

• Murali Karlapudi How I can scan all rows of the datasource?

  How I can scan all rows of the datasource How I can move at the first row of the datasource How I can move at the next row, the last, the previous... It's the reporting designer of Visual Basic .Net. I would like to scan all rows to find an element or to do an operation, ... Thanks. Huh I didn't get the point. Mira, si eres de un pais de habla hispana escribe tu pregunta en espanol; tal vez pueda ayudarte ...Show All

• donkaiser How to set an action?

  Hi,   I want to link to a website (like www.google.com ) when user click any cell in cube browser.   Then I set an action, the setting detail as following:     Target Type: Cells     Target Object: All Cells     Action Content Type: URL     Action expression: www.google.com   But it's not work fine. When I click any cell in cube browse there is an error message.   Is any prob ...Show All

• sr101880 How to encorporate IF

  How can I put an If statement saying If # RECORDS returned from the query below IF  # records returned is > 1 then     SUM(rmstranamt) AS  rmstranamt10   ELSE rmstranamt AS  rmstranamt10   here's my statement ------------------------- SELECT     RMSFILENUM,           rmstranamt AS rmstranamt10   <-----If statement goes here ...Show All

• chilling Using custom assembly problem. Help!

  I've created C# assembly which was included into Script Task code as following: -------------------- Imports DTX55AppDefaults.DTX55ApDefaults --------------------- The ScriptMain window recognize this assembly and can see all methods with no problem. The class View window see the assembly with whole list of methods with no problems. I build the code when ScriptMain window was open and save the code. Then I close window and run the package in Deb ...Show All