coolarian's Q&A profile

• SQL Server capture delta

  how can I capture delta in SQL Server 2005 to refresh base tables in a data warehouse When you install SQL Server, by default it will also install SQL Server Books Online, the product documentation. Try looking "SCD" up in the index, it has an entry "SCD transformation". This will take you to the "Slowly Changing Dimension Transformation" topic. Here is the online link as well- http://msdn2.microsoft.com/en-us/library/f8849151-c171-4725-bd25-f2c33a40f4fe(SQL.90).aspx There are products out there that can read a transaction log, Apex SQL, Red-Gate, Lumigent all have them, but I think they are all interactive tools, rather than a way of capturing and replaying the statements. You could use SQL Trace (Pr ...Show All

• Windows Live Developer Forums Zipcode/Ip address to Geocode conversion API

  Hi, Is there a way to get the geo code frrom the IP address or the Zipcode I have looked at options from sites like http://www.localsearchmaps.com/geo/ by_ip=1&ve=1 We would prefer using the VE api. Is there a way we can do it with VE API. Any help or pointers is appreciated. Thanks, Srikanth. "Yes" by ZIP code, "no" by IP address. For geocoding ZIP, just pass the ZIP code to the FindLocation() or Find() method. ...Show All

• Visual Studio 2008 (Pre-release) How to find TreeView from TreeViewItem

  Hi How do I find the hosting TreeView when I only have a TreeViewItem Best regards, Thomas Andersen Lee's right. Looping through TreeViewItems until TreeViewItem.Parent is null and then using the method works. Thanks to you both :-) ...Show All

• SQL Server Can't create file at the root level of Mount Point

  Dear all, I was trying to create filegroup and files on Mount Point, e.g. C:\MOUNT\FG1D1 If I try this: ....... FILENAME = 'C:\MOUNT\FG1D1\FG1F1.ndf', It doesn't work, no matter what ACL I set on C:\, C:\MOUNT, or C:\MOUNT\FG1D1 But if I do this: ...... FILENAME = 'C:\MOUNT\FG1D1\DATA\FG1F1.ndf', It will work, no need to set any ACL at all. Any ideas dong ...Show All

• Visual Studio 2008 (Pre-release) hyperlink Click bug when used in Frame

  Hi, The following code is what I used to navigate to the second page when Link1 in the FirstPage is clicked. After the second page shows up, if I just hit "Enter" key, the same event will trigger again and at this time, service will be null (since Page1 has already been unloaded) and the code will crash. It seems the Link1 still got the focus even if Page1 has already been unloaded. I can workaround the crash by add a null check for the service but that doesn't sound like a good solution. I tried the same thing with NavigationWindow and it works fine. It is only a problem with Frame used inside a normal window. void Link1_Click( object sender, RoutedEventArgs e) { Page2 page = new Page2 (); Navi ...Show All

• Visual Basic Session state in VB.net

  Hello all! I know there is a session state in asp.net. Is there something in a vb.net application that does the same thing Thanks! Rudy Session state is required in a web application because its a stateless model. Windows application can maintain state - so there is not as much of a need for a session state implementation. ...Show All

• Visual Studio Express Editions C++ Express Compiler fails after installing SP1 beta

  I have just installed VSC++ Express SP1 beta and now nothing compiles because there seems to be problems in the xutility library. Here is the version information from help: Microsoft Visual Studio 2005 Version 8.0.50727.363 (SP.050727-3600) Microsoft .NET Framework Version 2.0.50727 Installed Edition: VC Express Microsoft Visual C++ 2005 76542-000-0000011-00125 Microsoft Visual C++ 2005 Here is a simple Hello World program that won't compile: // HelloWorld.cpp : Defines the entry point for the console application. // #include "stdafx.h" #include <iostream> int _tmain( int argc, _TCHAR* argv[]) { std::cout << "Hello World\n" ; return 0; } Here ...Show All

• Visual C# Reading the end of an XML file

  I have a program that cycles through an XML file and outputs to another file every 1000 records. Thyis works fine until the end of the XML file is reached, when it fails saying my 'root' tag is not closed - although it does for the previous files. It seems to be having issues with recognising the end of the XML file, so can someone please confirm how this is done Currently I have a while loop to do this, with a for loop inside to cycle through the records, ie: while (XmlReader.Read()) { ... for (int i = 1; i <= 100; i++) { while (reads in a node here) { does the work } } Close the XmlReader and XmlWriter } This works fine for the beginning, until the end of the file is reached; is my way of reading the XML file correct (I have also trie ...Show All

• .NET Development Trouble with root node of a transformation

  I’m having trouble with a transformation where the XML document doesn’t have a root node. Instead, the XML document has a root element with attributes which (I believe) is the reason why I can’t get the result I’m looking for. Below is all the code. Thanks for you help. I have the following XML file <FIXML r="20030618" s="20040109" v="4.4" xr="FIA" xv="1" xmlns=" http://www.fixprotocol.org/FIXML-4-4 "> <Batch> <AsgnRpt RptID="426522297" AsgnMeth="R" BizDt="2006-08-01"> <Pty ID="OCC" R="21" /> <Pty ID="00234" R="4" > <Sub ID=&qu ...Show All

• Windows Search Technologies New to WDS - Don't like it so far. . .

  I was instructed to install WDS 3.0 onto my PC builds, which I promptly did. Afterwards, I attempted to use it on a few PC's and, as far as I can see, it really was not working at all. a) I don't see how I am able to browse/navigate around the c:/ drive or any other drives in order to pinpoint where I want to conduct my search. b) When I attempt to search for a file, I am not seeing that it is doing anything (all I set is the word "Searching" on the toolbar and nothing else. . .no indication that it is scanning other than the fact that the task is "running" when I go into Task Manager and certainly no results to speak of). c) The entire PC freezes after awhile and I need to cold boot. Am I doing something i ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. "Use of unassigned local variable" error on Xbox360 but not Windows

  Anyone know why the compiler produces an error when the following code is compiled in an Xb0x360 project but not when it is compiled on a Windows project public void GetTileRect( int tileX, int tileY, out Rectangle tileRect) { Rectangle myRect; myRect.X = tileX * tileWidth; myRect.Y = tileY * tileHeight; myRect.Width = tileWidth; myRect.Height = tileHeight; tileRect = myRect; } I get a "Use of unassigned local variable 'myRect'" when assigning it to tileRect. It's not a big deal, I can get around it by simply using "myRect = new Rectangle()". I'm just wondering why it works in one case but not the other. you know, I came across this ve ...Show All

• Visual Studio Express Editions Convert 4 byte String to hex to number

  Hello everyone, I am fresh to VB programming but I find it enjoyable and easy to learn. I have been fighting a small issue with some code that I hope someone can help me out with. I have a 4 byte string variable containing a representation of a 16-bit word value. Each byte contains an ascii character 0000-FFFF I need to convert this psuedo-hex value to corresponding decimal (0-65535). Is their a way to parse this 4 byte string into a Ushort variable and then convert it to a number I would greatly appreciate any tips or advice, Thanks in advance!! Dim s As String = "0000-ffff" Dim hbytes () As String = s . Split ( "-" ) Dim i As Integer = Convert . To ...Show All

• Visual Basic How do I make a application close on button click?

  Topic Thanks Private Sub cbEverLovinButton_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles cbEverLovinButton.Click end ' or application.exit End Sub ...Show All

• Visual Basic A very strange incident... and strange question.

  Well I was working on a MS-Access 2003 project that has a bit of VB code that executes once a certain text box loses focus. When it loses the focus it calculates a couple of lines of code. Everything worked fine. Now for some reason it seems to crash, when I debug it, it goes to a line where the following happens 'cPrice get's a value on the form e.g. R150.00 'iWeight get's a value from the form as well e.g. 5t tTax = cPrice / iWeight But it keeps stalling there, VB auto casts it's types if I am not mistaken, so anyone any ideas why this keeps failing What types are cprice, iweight and ttax if they are decimal, the division can cause exceptions for overflow or division by zero. For integers, the ...Show All

• Visual C# A question of OO structure...

  Hello All, I'll do my best to explain what I'm trying to accomplish and look forward to any and all suggestions you have for the "proper" way to do this (realizing there is no 100% correct way, but some methods are more optimal than others). I apologize in advance for my n00bness. For this example, I'll use football (american) players. I want my Player class to have a List<Stat> collection of my Stat class. Each Stat, which is an indicator of how well a player plays a particular position, should have a base value but be able to return a "true" value which is a calculation of the base value plus a percentage of one or more other stats. For example: a Player's Halfback stat might be base value plus 50% of the Fullba ...Show All