Metaman's Q&A profile

• SQL Server Making "incremental" updates to a data warerhouse

  We have a legacy database whose data needs to be included in our yet-to-be-built sql 2005 data warehouse. Some of the tables don’t have any natural candidates for a primary key. (Of course, we also need to add other data to the mix.) Suppose we load the empty warehouse initially. In following loads we don’t want to include those records that haven’t changed from the first load (“duplicates”) but we also don’t want to delete the contents of the entire warehouse because of the load time. Any ideas/best practices how to handle “incremental updates” to a warehouse would be appreciated. TIA, Bill ...Show All

• SQL Server Using a Case to decide on the join statement?

  I'm trying to join a table and based on the value of a given column I would join using the column in question, however if the column is NULL then I want to make the join without the column in the join. so I think I want to do something like this: Case E . a when NULL then LEFT JOIN EPD ON EPD . b = D . b AND EPD . SD = ( SELECT MAX ( E1 . SD ) FROM E1 WHERE E1 .b = EPD .b AND E1 .a = EPD .a AND E1 . SD <= T . WD ) Else LEFT JOIN EPD ON EPD .a = D .a and EPD .b = E .b AND EPD . SD = ( SELECT MAX ( E1 . SD ) FROM E1 WHERE E1 .a = EPD . ...Show All

• Windows Forms Detect control movement in screen ???

  yes, indeed we can use Control.Move event to know when a control moves. But, what if the control moves in screen because we move the form  Yes, we can solve this by adding event handler to the form's Move event. But again, what if the control has multiple level of parenting i.e. control is contained within a panel then contained within a form ...Show All

• Visual Basic dlookup Newbie Troubles

  Hello I am a newbie to VB programming, and I downloaded VB2005 Express. Anyways I was wondering if there is an equivalent to dlookup in VB2005. I found a page on the web talking about it, but as I only know how to use VB2005, I'm not sure how to get it working. In my app I use table adapters, not recordsets. Thanks Jeff There are a number of ways to get data from a database but this is the way I would get a single value: Dim myConnection As New OleDbConnection( "See www.connectionstrings.com for examples of valid connection strings." ) Dim myCommand As New OleDbCommand( "SELECT D ...Show All

• SQL Server Date picker not showing...

  I have report parameters configured to use date pickers...but they don't show up when I run the report.  I see the date picker controls when I preview the report in design mode, but they don't show when I open the report in a browser.  Any thoughts It could be unrelated, but the error I get when I try to run the report with text dates is: Collection was modified after the enumerator was instantiated. I was wondering what the status is on this issue I am having this exact same problem but am running VS 2005 8.0.50727. Could it be because I have the reportviewer in a webpart Thanks, ...Show All

• Windows Forms update db from textbox

  I have a textbox connected to a dataset and appropriate oleDBDataAdapter and oleDBConnection in C#. The textbox (databindings) text is connected to the dataset. The textbox gets filled with the data correctly. But when I want to save doing Update nothing get saved in the db. The right value is in the dataset I have checked. I've tried to debug and step into ...Show All

• Visual Studio Problem building

  I have been successfully using VS 2005 Beta 2 (VB.NET) for about a month now.  Yesterday, I started getting the error: Error 5 Unable to copy file "obj\Debug\BO.dll" to "bin\Debug\BO.dll". The process cannot access the file 'bin\Debug\BO.dll' because it is being used by another process. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\Microsoft.Common.targets 2274 9 This error does not occur the first time I build the solution after just opening it in VS.  But all subsequent build attempts fail with this same error.  If I exit VS and reopen the project then I can again build one time and al ...Show All

• Visual Basic RC1: "Compiler has encountered a problem..... NEED HELP from MICROSOFT

  I do have a rather big VB Windows Project and I get all the time interrupted by a compiler error &Hc0000005&. Have to restart. It happens while I edit the code, two three keys pressed and I get the compiler error. Don't think there is any error in the code itself. It is close to impossible to work with VS anymore. Thanks very much for your help - Thomas I'm having the a similiar problem, some solutions already found. been you able to solve the problem any suggestions are welcome. regards Wolfram ...Show All

• SQL Server SSIS from VB 6.0 or VB .Net...

  Dear all, How do I to launch a SSIS package from either VB 6.0 or VB .Net languages Anyone told me that from SMO library you can launch but I haven't idea how would I do too.. Thanks in advance for any input or though, Enric PIA - Primary Interop Assembly, but ignore me on that, got myself the wrong way round. A CCW is a COM Callable Wrapper. You create a wrapper around your managed assembly to allow it to be called from COM. These can be auto-generated, I forget the tool now, try searching MSDN. A better way would be to write a wrapper class in managed code and just expose some simple members. Use this to create the CCW ...Show All

• Visual C# How can I take the path of my program after it was setup-ed?

  Hi, How can I take the path of my program after it was setup-ed , where i used setup project in Visual C# a,d added files on it, but I setup-ed a windows service that see files in [WinDir]/System32/ directory. Regards 22DoorsDown  ...Show All

• Visual Studio comment helper in VS2005

  looking at v 2.0 50727 for the HelpStudio Lite, but see only a feature to highlight a line of code as a comment- where is the export feature to create a XML comment file that was in Configuration Manager Is HelpStudio Lite in this versions I have installed the VS2005 SDK Octover version, but there is no 'Comment Helper' add-in HelpStudio installed but no DocumentX How do I get the xml comments to documentation features ...Show All

• Visual Studio Express Editions Transfer a project from VC 6.0 to visual studio 2005

  Hi, everyone, I have a project in VC 6.0. It's around 200k LOC. It works fine in VC 6.0. But when I tried to compile it in Visual Studio 2005, I got a lot of error messages. For instance, for (int i=0 ; i<10 ; i++) { ; } for (i=0 ; i<10 ; i++) { ; } The above code works good in VC 6.0. But in visual studio 2005, I will get the error message saying "undefined variable i" for the second loop. It's kind of annoying to modify all the codes since this is really a big project. Is there anyway I can use the benefit of visuall studio 2005 but using the old complier Thanks a lot. I ...Show All

• Visual Studio Apply VSS to already-present directory structure?

  We've got a directory structure with common, database, ui, etc components split out into subfolders to enable easier reuse. I'd like to bring in VSS2005 and apply it to this directory structure, not creating duplicate common projects for every project that uses them. It appears to me that if I open a VSS database in VS.NET right now, then "add solution to source control" it's adding all projects in my solution to the project folder in VSS. Rather, I'd like to add the main project to its folder, and the components to their folders so that other projects can reference them. Ideally, I would like to import (check-in) the entire current dir ...Show All

• Visual Basic vs2003 style splitter in vs2005?

  in vs2003 i used to be able to draw up an mdiForm with 3 vertical panels - each panel was docked to the bottom and each panel had a spliter dock=bottom on top. the remaining space above was used to hold child forms. i'm having trouble creating this with in vs2005.  can i use the splitter from vs2003 somehow or is there a way of using the splitContainer differently anyone run into this | know the appropriate document I think the problem is that the Splitter control isn't added to the toolbox by default - to add it, open a form, right-click anywhere on the toolbox, choose 'Choose Items', scroll dow ...Show All

• SQL Server Another Stored Procedure Question...

  Hi, Is it possible whithin a Stored Procedure send the table name as a parameter And some Columns to Ex.: CREATE Procedure Xpto @TableName as @ColumnName as @SomeValue as nvarchar(10) AS SELECT * FROM @TableName WHERE @ColumnName = @SomeValue Thanks JPP Hello... I would not use a table to hold values like this... Those information is already in the DB and there is no need to denormalize it. If there are propper indexes on those fields you want to evaluate you can wrtite a small view that extracts the data you need... By the way... Why is there no SQL Code button on the form ;) create view DocCount ...Show All