Alexander Petukhov's Q&A profile

• SQL Server comparing DateTime in UK Format

  Hello friends, I am trying to return all records between 2 dates. The Date columns are in DateTime format, and i am ignoring the timestamp. The user should be able to input UK Date Format (dd/mm/yyyy) and return the rows. This sql code works fine for American date format, but i get an error: converting from varchar to datetime when i put in a UK format. eg. 22/11/06. Please advise on this problem! many thanks! ALTER PROCEDURE SalaryBetweenDates ( @WeekStart datetime, @WeekEnd datetime ) AS BEGIN SET @WeekStart = (SELECT REPLACE(CONVERT(DATETIME,@WeekStart ,103),' ','-')) SET @WeekEnd = (SELECT REPLACE(CONVERT(DATETIME,@WeekEnd ,103),' ','-')) END BEGIN SELECT s.StaffNo,s.StaffName,s.StaffAddress, s.HourlyRate, sh.HoursWorked, CONVER ...Show All

• SQL Server ER-Diagram

  Can we say the Database Diagram generated by Enterprise manager (sql 2000) or SQL Server Management Studio(2005) is ER-Diagram Yes - the diagrams inside SQL Server 2000 and 2005 constitute an E-R diagram. There are several types of those, however. You can read more about them in this series of articles: http://www.informit.com/guides/content.asp g=sqlserver&seqNum=62&rl=1 Buck Woody ...Show All

• Software Development for Windows Vista WM_COPYDATA not working in VISTA

  So I have a DLL (writen in Borland C++) which when I send an event to it, it then does things and returns the results via WM_COPYDATA. Using Spy, I see the WM_COPYDATA events, but my code is no longer picking them up in Vista. Works fine on XP and Windows 2003 Server. What do I need to do to get this working in Vista Thanks, Danny ...Show All

• SQL Server Installed SQLServer 2005 TrialEdition

  Hi Fellows, I am really in a fix.I have downloaded the trial version from MIcrosoft site and run setup with named instance. But I cannot find my management console link anywhere. Can anyone help me here . My site is : Windows XP Professional SP2 Installed : SQLServer 2005 180Day Trial Pack downloaded from Microsoft Network. I ran setup from : server directory and also from tools directory. In my programes menu I can only see Configuration Toolsunder which there are three options : 1) SQL Server Configuration Tool 2) SQL Server Surface Configuration Tool and 3) SQL Server Error and Usage Reporting Hi I just uninstalled everything and run the installer again . It sa ...Show All

• SQL Server No cubes can be found error

  In the data panel of the report designer component, every time I try to create or modify an MDX statement, I'm now getting a "No cubes can be found. (Microsoft.AnalysisServices.Controls)" error. Works fine on the Layout and Preview tabs. Just all of a sudden appeared. Working fine against relational sources. As a warning to all, Reporting Services and Analysis Services is definitely not a marriage made in heaven. Proceed with caution. I'm going to have to learn to delete my profile everytime something strange happens with SQL 2005. Somehow, my profile on my primary development machine was corrupted again. ...Show All

• Visual Studio Express Editions How to Detect another applications GUI controls in C#

  Hello, I'm new to C# (and OO programming in general). I'm looking to make a program that detects controls on another application and manipulates those controls. For example, can detect a radio button on an MSI installer and click it, or detect fields of a web form and fill them out. I'm sure there must be .NET libraries for this sort of thing, but I couldn't find what I was looking for. I could use AutoIt instead, but that would hardly be good C# practice :). Can anyone point me in the right direction Thanks. Spying is not the purpose, though I suppose it could be used as such. The purpose of my application is automation of other applications for testing purposes. So if you had a web or desktop based appl ...Show All

• Microsoft ISV Community Center Forums Web Page Components

  Hello All, I am a complete beginner with Web Pages!. With the help of various forums I have managed to get to a web page via a Sign In page (that is I can get my VBA code to fill in the username and password). The next page I get has some options on it. (Normally if I was to "hover" over them they get underlined, are these links . If so how do I click the appropriate one If I ever get past this the next page will have a combobox where I will have to make a choice again. How will I make that choice . (Ther will be about 5 or six drop down choices. Basically I would like to know how to reference these "controls ". I am assuming this is what they are . As I mentioned earlier, I am a complete novice to this a ...Show All

• Visual Studio Team System Unit testing woes...

  We had something interesting happen to us that we have no idea how to fix and can't seem to find any documentation on as it was working just fine a week ago. Our build process is presently failing with following error on 116 unit test: The web site could not be configured correctly; getting ASP.NET process information failed. Requesting 'http://localhost/VSEnterpriseHelper.axd' returned an error: The remote server returned an error: (510). About that HTTP 510 error there at the end, it's the status value we use to indicate that something has go wrong within our framework. In this case, we're saying that we were unable to find the content requested to serve, much like a 404. So we're not sure what the error means (Is that a web ...Show All

• Visual C# View console app before termination

  Hi everyone..... I have a very basic and probably stupid question. I am just learning C# using the C#Express software and have a problem trying to view the output of my console apps. I have started a console app project, compiled and run. I see a brief flash and then the app closes and terminates. Q. How can I prevent the console closing down so that i can actually see somthing. You could make the console app sit there until a certain key is pressed: while ( KeepRunning == true ) { } Then just make a method that waits for CTRL + X. when the keys are pressed you can just do: KeepRunning = false, then the while condition will finish and the app will close! Proberly not the solution you need, but ...Show All

• SQL Server Report Builder - Numeric Aggregate Aggravation

  So I'm building a report model containing several 8 or so numeric amounts.  All amounts are numeric(10,2), and there is nothing that would differentiate the columns other than their names. One of the columns WILL NOT generate any aggregates.  It just appears as an attribute.  It's inexplicable.  I've even tried to build a model containing just this one numeric attribute, and it still does not work!!  VS just hates this one element!  Anyone seen anything like this   I'm running VS 2005 Sp1. WHAAAAAAAAAAAAAAATTTTTT     What genius came up with that!  Any why would an ID field be numeric 10,2!!   Thank you thank you ...Show All

• Visual Basic Net Programs & Dual Core

  My .Net program uses 80-100% CPU (memory operations - no disk activity). If I get a dual core, could I run two instances without performance issues ...that is running each app on a single CPU. Thanks Performance can be a tricky issue, and it is next to impossible to give a "once answer fits all" reply to a question like this... Improving .NET Application Performance and Scalability article contains a lot of useful information and tips on how to plan for and measure the performance of your application. Depending on what the limiting factor is for your application, having two processing cores may or may not impove your performance - for some applications it could even decrease performan ...Show All

• Visual C++ Error messsage

  The version of SP is 20040803.231319. It has been suggested that I post my query in another forum. This I will do. Thanks for responses. Thanks for your response. I was unable to open BTHelpNotifier.exe and examine PSIPA.DLL.  I have the file in Windows.  The problem would appear to be with the BT software and I will contact them.  What do you think ...Show All

• Smart Device Development Image/Graphics delay

  I'm transmitting some graphics (jpeg) from Server to smartphone after an interval of 5 seconds (Running .NET 2.0 CF SP1) The images are not big at all, they are about 40KB-78KB Now it does this fine at first. After a while, it slows down - it seems like it takes twice as long to display the next image being transferred even though there is no timer or anything like this on the smartdevice project, the only timer is on the Server app which works fine (checked this myself) I can see that every 5 seconds not only does it output the image on disk (Server) but at the same time it also transmits it via networkstream. As said, the first few images show instantly but then it gradually becomes slower, taking twice as long to s ...Show All

• SQL Server ProcessAdd for dimensions

  I'm poking at some code that sends uses an XML/A ProcessAdd command to incrementally process a dimension. The command contains the out-of-line binding which specifies the query for the new rows. However, when the command gets submitted, I don't see anything that looks like the specified query in the profiler log. As I figure it, either: a) The command isn't constructed correctly. SSAS is claiming success, and the dimension is processed at the end, so if the command is wrong, then I don't know what SSAS would be doing instead (a full process a process update ). b) My expectation of seeing that query, or something like it, in the profiler log, is wrong. We also have ProcessAdd commands for partitions, and those queries DO end up being displa ...Show All

• .NET Development DataAdapter.Update returns error on very simple example?

  Hello, I'm trying to do a very simple data update using the Northwind database...I just want to change the very first element in the table to the word 'Test'. However, I get a run time error of Message="Update requires a valid UpdateCommand when passed DataRow collection with modified rows." What's happening This is supposed to be a super simple test..pulled from one of the examples in the book. Dim dcMSAccessConnection As OleDb.OleDbConnection = New OleDb.OleDbConnection( "Provider= Microsoft.Jet.OLEDB.4.0;Data Source=c:\northwind.mdb" ) Dim daMSAccessAdapter As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter( "Select * from Customers", dcMSAccessConnection) Dim dtMSAc ...Show All