Answer Questions

• Merovingian6532 How to add Drill down option in the Dataset ( + )

  Dear Friends, I have created a Dataset and displayed in the report. In the report, its showing as expanded values by default. There is no option for me to Collapse and Expand. If I create a Table with Report Wizard, I am getting the Collapse & Expand ( + ) option in the report. Is there anyway, I can add the Collapse / Expand in the Dataset kind of reports. Thanks. Warm Regards Rakin Singapore. ...Show All

• Guddy SQL 2005 and Access 2003

  Is there a patch available for Access 2003 that will allow it to interoperate fully with SQL 2005 In general Access should work fine with SQL Server 2005. If you want to use new SQL datatypes you'll likely need to wait for a new version of Access. Paul ...Show All

• Jbasingh Tool for MySQL to MS SQL Server 2005

  Hi, I'm in search of a nice tool to convert the database from MySQL to SQL Server 2005, where the schemas of both the DB are different. I just want to move the data from one database to another with column mapping.. Can any pls suggest me a nice tool for this issue Early reply is appreciated... thanking you VarShant SQL Server Integration Services Am I correct to assume that ...Show All

• Daniele Balducci Generating Reports With Enabled Parameters from Snaphots

  Dear Anyone, Is there a way for RS users to generate reports from snapshots and at the same time still be able to use the parameters to manipulate the report Thanks, Joseph ...Show All

• softodron Read-Only Cell

  Hi, When I create a new xml column using SQL server 2005 the column by default is set to "read-only cell". I've looked around at the properties and don't see anything to change this behavior. Anyone know what I need to do so that I can write to this cell useing the SQL browser. I'm able to update the cell programatically, BTW. Any help greatly appriciated. - Pardner Hmm, Maybe I need more in ...Show All

• MHV642 Is there a way to create a dynamic Insert on Stored Proc?

  Hi, I have more than 30 tables and I want to create just one SP for the Insert statement for all of my tables. Is there a way to do this or do i need to create one sp on every table for my Insert stmt. Thanks Why do you want to do this Using dynamic SQL to perform insert operations has security risks. You will have to grant additional permissions to users to insert into the table. You have to ...Show All

• Wezlie EXCEPT

  I want to use a named query in my Data Source view and I am using the 'EXCEPT' keyword. With the SQL Server Management Studio (and within stored procedures, etc), everything works fine, but when I create the Named Query, I get an error message that the EXCEPT statement is not supported. Unfortunately, that also applies to the EXEC statement, so that I can't use a stored procedure. Is there any work around for that ...Show All

• Orellang Flat File and uneven number of columns

  Please leave feedback for Microsoft regarding this problem at https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=126493 Ok I'm sure it just me, SSIS has been great so far....but how can you import a straight CSV file with and uneven column count. For example: (assume CR LF row delimiter) The,Quick,Brown,Fox,Jumps Hello,World This,is,a,test "Normally" I'd expect this | Col1 | | C ...Show All

• bear007 How can i get the first day of the month and the last day of the month?

  Is there a function that do id or i need to calculate it by myself I think that wont give the proper results, a slight change will help select dateadd(month, datediff(month, 0, getdate()), 0) as [First Day of the Month], dateadd(month, datediff(month, -1, getdate()), -1) as [Last Day of the Month] Hi, there is no built in one, but you can use these ones here which is jus ...Show All

• Jake Mertel SP permissions under SQL Server 2005

  I am just migrating to SQL Server 2005 and I am having difficulty figuring out how to do some tasks that were easy under SQL Server 2000. Specifically, I am not sure about object permissions. (This is what I did for SQL Server 2000) For database access by my web application, I added a SQL login for the IIS_WPG group. I then added a database user (name ASPNET) associated with this database login and give it only datareader and datawriter privil ...Show All

• Jaime A Debugging a customponent used in a Integration Services project

  Hi there    I'm building a SQL Server integration services project with a custom component. I created the custom component as a separate C# library project and compiled it. With the help of some online resources I was able to make it appear in the Dataflow Transformations toolbox items of Integration Services IDE. But this component is throwing some errors. My question how do I setup the environment such that I can set break ...Show All

• Gerald Huff Freeze Panes?

  Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report Similay to the freeze panes functionality in Excel. Thanks I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error [rsFixedHeadersInInnerDataRegion] The matri ...Show All

• Andy Roberts - MSFT Corruption of package?!

  I have done this twice - grrrr! Simple SSIS package contains the following tasks Control Flow 1. VB .NET Script to create a file name with "sometext" + mmddyy + ".xls" 2. FTP Task - logs into FTP site, finds file name created in 1) and downloads 3. Data Flow Task Data Flow 1. Excel Data Source - connects to and maps the Excel workbook/sheet columns 2. OleDB Destination - Inserts rows using the column mappings from 1) abov ...Show All

• Mikelynes Another question about Login failed, but with Windows NT Integrated security for SQL 2005

  Hi, Happy New Year!   I have been struggling with this problem for a while with SQL 2005.   I have never had such login problem with SQL 2000. Here is the scenario:   I have installed SQL2005 standard version on a XP Pro box and I am trying to access it from another XP Pro machine.   I can access it using a SQL user name and password that I set up on the server, but I have not had luck with using Wind ...Show All

• James01 Children of the Children in MDX

  Hi, all   I'm quite new to MDX.   What I'd like to know is weather it is possible to select all the children of the children of a given node in one-line query. Say we have [Driver].[All Drivers] dimension level. And I want to do something like "[Driver].[All Drivers]. Children .Children" instead of obtaining the results with the use of "CrossJoin/Union" . E. g.: { Crossjoin({[Driver].[All Drivers].[564654 - Andrew]},   &nb ...Show All