Ooogaleee's Q&A profile

• SQL Server How to callapse rows together

  I'm need to collaspe a few rows together and output one row per group. The rows come from a flat file and are already sorted by orderid. Basically these are transactions with just the changed fields in them all unchanged fields are null (blank). They need to collapsed down to show the final state of all changed fields per order. Obviously the aggregate transform won't work in this situation since the goal is to collaspe instead of aggregate. In a language, I would normally buffer the previous row and apply the logic as needed until the orderid changed and then write out the new row. Then input file has millions of rows so I also didn't want ...Show All

• SQL Server does not install SQL Query Analyzer

  Hi, I am developing and application in pocket pc windows mobile 2003. I have added a reference to System.Data.SqlServerCe.dll but when i deploy the application query analyzer doesnt seem to install. Any help please cheers, michael Hi, Sorry... for info I am using CS VS2005 and SQL Mobile. Thank you. michael ...Show All

• Visual Studio Express Editions Unable to uninstall Express Edition thoroughly

  I am unable to uninstall Express Edition thoroughly. It left a bunch of things like file associations! I made the mistake of installing Visual Studio 2005 C++ Express Edition on a system with Visual Studio 6, thinking they could co-exist. Now I am trying to fix my mistake, but the uninstall left a lot of junk! --Jamie I'd also be interested to know if there is a utility out there that replaces files file associations with windows defaults or if there is a setting within windows that can do this. It seems a common problem with various applications and uninstalling. A pet hate of mine are programs th ...Show All

• SQL Server Report Builder accessed using https over internet

  If you access the report builder application over the internet using a secure connection such as https://<report server name>/reportserver/reportbuilder/reportbuilder.application, will report builder communicate using https If not, will the data being transferred to/from the report server be encrypted by some other method in the application Report Builder actually switches between http and https based on the web service method being called and whether ListSecureMethods indicates that https should be used. You can configure these settings on the report server. Here are a few links that might be usef ...Show All

• Visual Studio Team System Error!SQL Server 2005 Report Server Web site is not running!

   When I installer TFS bete 3,I according to installer guide's content operation,but when installer TFS beta 3 ,System occur error!pls reference below: Warning   Description Physical memory does not meet recommendations Workaround / Remedy The physical memory (RAM) in this computer does not meet the recommendations for installing this product. If you continue with installation, you may experience performance or scalability issues More information For additional information and help please refer to: http://go.microsoft.com/fwlink/ LinkId=52502 Block   Description SQL Server 200 ...Show All

• SQL Server Replication troubleshooting

  We have some transactional replication jobs from oracle to mssql2005. I found an error in the replication monitor as below, ============================================ Incorrect syntax near 'index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax. (Source: MSSQLServer, Error number: 1018) Get help: http://help/1018 Command attempted: if @@trancount > 0 rollback tran (Transaction sequence number: 0x00000000000000000D4300000000, Command ID: 26290) ============================================ I found the corresponding table from the com ...Show All

• SQL Server Data types in SQL Server

  Hi, Can someone please tell me what are all the data types in MS SQL Server 2005 Express used for I have only used Access before and the data types in Access are - DATA TYPE    INFORMATION STORED Autonumber - A number that is assigned automatically and never changes thereafter. Currency   - Amount in the currency format chosen. Date/Time  - Date and Time. The Format property chosen on the general tab to date alone or time alone or both in different formats. Hyperlink  - Hyperlink addresses. Lookup     - Values that come from another table, a query, or a list of values that ...Show All

• Windows Forms Deploy chm file with click-once

  I'd like to include a chm file with the application that I am deploying, but no matter what subdirectory of the project I put it in I can't seem to get the file to be included in the deployment. The help file does work correctly from my application on the development machine where I have it located in the project bin directory. Right now, my deployment is just to a directory from which I burn a CD. Thanks, jerryK Have you changed the BuildAction property of the file to "Content" I think that's about all I did to get it to work.   ...Show All

• SQL Server Managing SQL Server Agent

  Hi, I would like to know what are the possibilities to mange the Sql server Agent in the Sql Server 2005 express edition whit the Sql server mangement studio express, because I can't see it . thanks Hi, you can’t manage it, because it isn’t there: Look at: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Basic User Name of Logged in User (Fill Name)

  Looking for a way to get to Full Name field of Logged in user. I can get to username with My .User.Name or My.Computer.User How can I get to Full Name you can also use system.environment.username... however, If joe smith uses the user account joe you will not be able to return joe smith.  What "Full Name" "Field" are you refering to   ...Show All

• Smart Device Development check device platform at runtime

  hi, how can i check the version of the platform during runtime of the mobile device. i would like to check if the device is PPC or smartphone and the windows mobile version it is running. Often times Platform/Runtime specific information that you need such as that will be static methods of the Application and Environment Members documentation can be found here . Pay special attention to OSVersion to see if that delivers what you need to. ...Show All

• SQL Server Programmatically Accessing Report Item Properties

  Hello All,                   I have been racking my brains trying to figure out how to access the properties of the Report Items in a given report. I would appreciate any help in this direction. The task I am faced with is to break up a given string i fetch from the database and and distribute it over 3 different textboxes in a report. For this, I was thinking of creating a custom assembly with a function which takes in the string and size (width and height) of a textbox, the font information (family, size etc) to determine what substring will fit into the ...Show All

• .NET Development Printing Files To a Pdf Distiller

  Does anyone know of a way to printing files to a pdf distiller (virtual printer) and pass parameters to it as well such as dpi settings, size, etc... this should depend on the method you use to print. There is no difference on whether you print on a virtual or a physical printer. You should use the PageSetupDialog to allow the user to select these settings. These settings will be available for the next print. If you want printing to be done without end-user's intervention then an administrator should select these settings using the PageSetupDialog and you should find a way to save these settings for later us ...Show All

• Visual Studio Team System Check-in Build Policy

  I am rolling my own at the moment but am wondering is there going to be an inherent policy in the Release of TFS for a policy of Build after Check-in   Want to set some expectations for others that have asked me if it will be in the release or will need to create the policy ourselves.   While there would be no out of the box policy, we recognize that it is a common scenario and would be shipping a sample for the same. It is all described in Khusboo's blog at http://blogs.msdn.com/khushboo/archive/2006/01/04/509122.aspx . Look for continuous integration, I believe that is what you are looking for. ...Show All

• SQL Server Force Execution on Import -- Ignore Duplicates

  I have a simply SSIS package with following data flow structure: Flat File Source > Data Conversion > Aggregate > Dervied Column > Ole dB Destination Basically, this package is executed on daily basis to import sales from a text file into sql server. Now there's a possibility that text file may contain previous sales (occasionally). My sql table structure enforces data integrity through primary key and therefore my package errors out if there's a duplicate in text file which already exists in sql server. I'm basically looking for a way to ignore these duplicates and continue to import rest of the file. I need a way to ...Show All