perf101's Q&A profile

• Microsoft ISV Community Center Forums ADO Recordsets

  I have a routine in Excel, which pulls data in from a SQL Server database into two ADO Recordsets using two seperate queries. These recordsets contain only 1 field, being customer ID, each with in excess of 65,000 records. I need to compare these two recordsets to establish how many customer IDs are present in one, but not the other and vice versa. Is there some clever way of looping I could use to achieve this The only other thing I can think of is a local query within my module on the two datasets, but is this possible Cheers for any help! Keith Hi KeithyBoy, You could write a function that does the search but it would be better to get the relevant data from SQL Server so you would ...Show All

• SQL Server Latest value for all members at a given point in time

  We have a fact table with a current balance record. For this balance rows are added to the table only when the balance has changed. This way we can reduce the volume in the fact table by not saving redundant information for every point in time that we want to analyze. In SQL it is a simple task to get a view of the lastest fact records for a given point in time. SELECT f1.* FROM factTable f1 WHERE f1.timestamp = (SELECT MAX(f2.timestamp) FROM factTable f2 WHERE f2.timestamp <= givenPointInTime AND f2.balanceKey = f1.balanceKey). In other words, the given point in time directly determines which rows should be fetched from our fact table, one row for each balance record (balanceKey). This row will of course include several dimension at ...Show All

• Visual C# CryptUIDlgSelectCertificate question

  Hi, I need to use the function "CryptUIDlgSelectCertificate" in my application. I am new to security in .NET. Can someone please advise me as to how I can use it my application, a short example. I need to authenticate the client at the start of the application(which is obvious). The application is a windows application and I am using C#. I have asked this question in the windows forms forum and after waiting a few days for an answer and extensive search for information on msdn and internet I have posted the question here. I hope I will get some help atleast in this forum. All help is very much appreciated. Thanks ...Show All

• Visual C++ Resource compiler truncates text in dialog template to 256 characters

  Resource compiler (VS 2005) issues a warning if the text length in a static control exceeds 256 characters: "warning RC4206: title string too long; truncated at 256". AFAIK dialog template has no such a limit. Is this warning just a 16-bit legacy   This was not an issue until now - we always were able to rephrase a text to fit it in 256 limit. Now we are localizing our product. After translating to German and French the length of the text in many controls became longer than 256 chars and resource compiler truncated it to 256.   So we moved long strings to the string table and setup control text at runtime. The disadvantages are obvious: rather than just translate resources we must change source code and English ...Show All

• SQL Server SP2 CTP November 2006 installation failed

  I have Windows XP Home Edition SP2 English Version. I installed MS SQL Server 2005 Developer Edition and after reboot I Installed SP 1. Now I try to install SP2 CTP November 2006. In Installation Progress dialog when Setup Support Files are in progress I get an error message - Unexpected Error Occured Unable to create backup folder and show me second message box with error Hotfix.exe has encountered a problem and needs to close. Regards Maciek Hotfix.exe was written to use UNC paths to reference files in the payload, as well as files on the local machine. If the user turns off default network shares, then the OS will not resolve the UNC paths that Hotfix references, and the execution fails. I ...Show All

• Visual Studio Team System How to check for code comments (XML Docs) in methods and properties.

  I am trying to write a custom rule to check for code comments (ie. XML Documentation) in FxCop. I found a property called Documentation in Method class. But it is always holding null value for all the methods and members. Can anyone help me out in writing this custom rule And i am also interested in finding all the method calls (method names) inside a method. Someone please tell me how to do that. hi, can you use Method.Documentation to get all the xml comment for a method and its parameters Thanks, Michael ...Show All

• SQL Server Attribute not found

  What is the best practice for handling blank columns in a fact table The Fact table i'm using contains a column called "Project" which is allowed to be an empty string in the production database. When processing the cube I get an 'Attribute not found" error. I can add an empty string record to the dimension table and the cube will process, but that doesn't seem ideal to me. Is there a better way to solve this Assuming that you're using AS 2005, this MSDN paper discusses options within SSAS for dealing with Referential Inegrity issues like yours. But many people prefer to handle such situations upstream, during ETL and data staging (eg: by substituting a special value): http://msdn.microsoft.com/library/default.asp u ...Show All

• Visual Studio 2008 (Pre-release) Support for Group By, Having etc

  How sophisticated are the query capabilities for LINQ. Can a SELECT includes Group Bys, Aggregate Functions, Having Clauses. I have a sophisticated query which runs within the MS Access query designer, but running the same query using .NET OleDb provider results in an error. The query uses joins to selects which have group by and aggregate functions in them. The error message says there is an error in the Syntax after the From clause. So I'm thinking to return result sets back to VB.NET and use LINQ to further process the data into the final result set. The other alternative is use a lot more code to massage the data into the final result set which is going to be nasty. LINQ includes a whole r ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Collision Detection in 2D Games

  Hi, So far I have figured out how to get object moving on the screen. I have also figured out how to detect colissions at the edges of the screen. However, I am having trouble figuring out how to detect the collision between two objects. Say for example, two bouncing balls in a 2D game. How can I detect the collision of this two objects I imagine it has something to do with sine and cosine Thanks, Oblivion. With spheres, it's really simple, subtract the centers and get the length of that vector. Then add the radii together. If the length < radii, intersection. Other shapes are a little more complicated. Note that this doesn't tell you where the intersection occurred either (which might be impor ...Show All

• Visual Studio Team System Required permission for Reporting Services to create project

  Hi, I am trying to give myself permission to be able to create Team Project. I follow this guide, http://msdn2.microsoft.com/en-us/library/ms253091.aspx for assignment permission for the reporting services. However, when I try to create a project, I received the following errors: TF30171: The Microsoft.ProjectCreationWizard.Reporting plug-in used to create the new team project could not be initialized and returned the following error: TF30222: The New Team Project Wizard could not find the data source TfsOlapReportDS on the SQL Server Reporting Services server vstsfs. I was able to overcome this error by assigning myself the "Content Manager" role for the TfsOlapReportDS and TfsReportDS report. However, this permission w ...Show All

• SQL Server Unable to install SQL2005 I64 on a 2003 SP1 Itanium

  Hello, I have many problem when I try to install SQL 2005 Ets edition ia64 on a 2003 ets Itanium edition. When I launch the setup, all is all right. But during the installation, it tryes to start MSSQL services. The staring of this service failed. So I try to start the service mannually. Nothing. Error messages I can get (in the event log) : Source : Service Control Manager ; ID : 7000 Description :Service SQL Server (MSSQLSERVER) failed to start due to the following error: The service did not respond to the start or control request in a timely fashion. Source : MsiInstaller ; ID 10005 Description : Product: Microsoft SQL Server 2005 (64 bits) -- Error 29503. Failure of the starting of service SQL Server. For more i ...Show All

• SQL Server Calling a child package from the Main Package

  I need to pass variables from the parent package to the child package. I got this to work in a small test case. But in the actual project, I get an error when I try to do that. The parent package's log has this error : Error: Error 0xC0012050 whike loading package file "c:\.......". Package failed validation from the ExecutePackage task. The package cannot run.. There's nothing more to go on here in the log. Any ideas -chiraj May be you will have to check the following 1) Check if the child package is working fine - if you execute it separately with the required input parameters. 2) Guess your child package is stored in the filesystem - Check if the calling package's identitiy h ...Show All

• .NET Development How to navigate nodes in an external file

  Hi, I have an XSLT file that loads a source file and transforms it to a target file using a third file for looking up additional information. I load this third file using the following: <xsl:variable name="lookupDoc" select="document('lookup.xml')" /> This works, but it's not ideal. Because the lookup file is a pretty large file, I'd like to specify a certain subnode to use for lookups instead of the entire file. I have tried several things including the following, but they all return zero nodes. <xsl:variable name="lookupDoc" select="document('lookup.xml', /Root/Model/Entities)" /> <xsl:variable name="lookupDoc" select="document('lookup.xml')/Root/Model/Entities&q ...Show All

• Visual Studio Team System Is it possible to set recursion to false?

  Currently when automation script is run, an item is duplicated and incremented in subsequent runs. Is it possible to set recursion to false Thanks Test consultant Thanks for the reply. I was under the impression that there is a property in web test. Each time the test is run, it is expected to add only one item to the shopping cart and create a ‘virtual request’. However on first run it created 2 instances of the same item in the ‘virtual request’. On second run, there were 3 instances. Test Consultant ...Show All

• Visual Studio Nested SQL For Crystal Report

  Dear All, I am very new to crystal report. My problem is quite simple. First I have a table as branch and another one is employee. So I am doing first a select * from branch. Then based on each branchID I do another sql search called as select * from employee where employee.branchID=branchID.branchID. So how do I go about crystal to create this form of reports.Thus the second query is nested in the first query. I want my report to be formatted in this way Branch 1 Employee 1 Employee 2 Branch 2 Employee 3 Employee 4 Employee 5 Can some one pls help me I am very new to crystal reports. Thanks in advance. Hi, I'm not sure why you are using two datasets..you ...Show All