dogbear's Q&A profile

• SQL Server XQuery to SUM multiple XML fields

  select SUM ( B . n . value ( '.' , 'decimal' )) from _Daily_Index cross apply FormXML . nodes ( '/A/value' ) B ( n ) WHERE CompanyName = 'A CORP ------------------------------------------------------------------------------------------------------------------------------ select SUM ( B . n . value ( '.' , 'decimal' )) from _Daily_Index cross apply FormXML . nodes ( '/B/value' ) B ( n ) WHERE C ...Show All

• Visual Studio Express Editions why is vb.net printing so difficult?

  Hi, I have loads of VB6 apps I am trying to migrate to VB.net and the biggest problem I have is that printer.print has no equivalent in vb.net Can anyone tell me a simple way to print in dot net Thanks Impossible is about right. I just can't see what to type to make something come out on paper, and I have written some neat VB stuff (IMHO) in th epast but this dot net thing has me stumped. Am I missi ...Show All

• Windows Forms Please post here if you are running a Terrarium server.

  I want to get a feel for how many are out there, if any. Thanks! It's up!  I had a little time last night and things went well.  Since it's not running on a dedicated server I may need to limit the number of&nbs ...Show All

• Smart Device Development GPS Sample Latitude/Longitude not correct

  I have a Pharos GPS unit with both the Blue Tooth and USB interface. I used hypertermal on a XP machine with the USB interface to record some raw GPS output. Then I used the file redirect to run the GPS WM5.0 Sample code in VS2005 WM5.0 device emulator. It displays the correct information on the screen Lat 42 / lon 83 when reading the raw GPS data file that I created. When I move the program to my WM 5.0 device and connect up to the GPS un ...Show All

• Software Development for Windows Vista CreateProcess not collecting Std Out from Process's children.

  Hi All,    I've been working on creating a program that automates my program building and testing.  A portion that I'm having issues on is collecting the stdout and stderr on process's children processes.    I've attached a portion of *sample* code that I'm working on trying to perfect so that I can incorporate it back in to my program.  I've tried taking care of security access issues (possibly a rea ...Show All

• SQL Server Microsoft Visual Studio is busy

  I get this message in a balloon that pops up frequently when I am trying to work in the SSIS designer. For example, I get it when working in a DataFlow task, trying to open editors for the OleDb Source and Destination. Is anyone else getting this What could be the cause, it seems to get sluggish. Thanks. Have you recently installed any other software that interfaces with Visual Studio ReSharper, for instance ...Show All

• Visual Studio Crystal reports 8.5

  Hi all, This is my query in SQL Server select customerid from v_verifiedtrips where startdatetime>'7/1/2005' and enddatetime<'7/31/2005' and customerid not in ( select customerid from v_verifiedtrips where startdatetime>'6/1/2005' and enddatetime<'6/31/2005') I want this for one field Could any one help me out in writing formula in Crystal reports 8.5 using above query ...Show All

• Visual Studio Express Editions Using Regex

  I googled this several times but I couldn't find anything right =/ Does anyone know how to use Regular Expressions in C++ .NET Or how to access them. I mean I know Regex stuff I am pretty good at making patterns but I can't seem to access them in C++ Thanks in advance You can use the regex class in C++/CLI. By just using the appropriate namespace and compiling with /CLR Take a look at http://msdn2.microsoft.com/en-us/library/594w4665. ...Show All

• Software Development for Windows Vista Statemachine not Stable !!!!

  I checked in several constellations. Rasing Events works between 1 - 20 times than I get by random Event can not be deliverd. By seeing the unanswerd request here in the Forum I think it's not working. If yes some good Ideas are always well come. Wolfram Hi, I dunno this is helps or not, but the ONLY time I've seen this so far is when trying to raise an event handled in a state that ...Show All

• SQL Server Can Data Extension built with VS2005 work with RS2000 ?

    For various reasons our next release of our software needs to continue to support SQL 2000 and Reporting Services 2000. We are using a Data Extension written in C#. Can we build a data extension in VS2005, using .Net 2.0 and have it work with RS2000. A quick test did not work. Is this a valid / supported configuration If it is, what steps, modification to the various configuration files would I need to make to  get it to ...Show All

• SQL Server Deployment worked when it shouldn't have done

  I've just had a situation where, when trying to process a cube, it failed because one of my Script Commands referenced a non-existent dimension. Now I have no problem with that - its easily fixed. My problem is that the cube is obviously faulty so why was I allowed to deploy it The deployment should surely have failed shouldn't it Is this a deployment bug Here is the script command: Scope ( Leaves ([Currency]), EXCEPT ( [C ...Show All

• SQL Server Random variable modeling using T-SQL

  Good day. i'm a new person here and not that familiar with T-SQL... the question is: is there any buil-in functions or special libraries in T-SQL that can help to generate correlated random variables with non-normal distribution function It would be also good if someone could advice if there is any application (statistical programm or non-microsoft developed library) that can deal with MS SQL and has modeling and forecasting capabilitie ...Show All

• Visual Studio Tools for Office Intercepting the Saving of a Word document

  I want to intercept the saving of a Word document so that I can do something different to the normal Word approach to saving. I have tried the following 2 approaches: Created an event handler for the BeforeSave event. This helps me intercept, but then Word goes and saves normally after my code. Override the Save() and SaveAs() Methods of the document. I am able to write this code and run the solution, but my methods never get executed. ...Show All

• .NET Development How to generate 64 bit executables with visual basic .net?

  We have code that was created in visual basic 6. Now we have a new itanium 64 bit machine, and want to take the old code and generate 64 bit executables that will run on the ia64 machine. The question i have is what is the easiest way on doing that From what i see on the forum it looks like i have to take the project generated with visual basic 6 and convert it to .net 2005 edition, and than using the .net framework 2 beta will cr ...Show All

• Windows Forms Merge Menu Nightmare

  MergeMenu behaves strangely - the documentation is extremely skimp, behaviors are unexpected, MergeType - add, remove, replace, mergeItems are extremely confusing. Question: Does anyone have their own methods for doing this   I have my own merge menu routine, but  ...Show All