Estitxu Round's Q&A profile

• SQL Server Count CustomersOrders

  Assuming you have the CustomerID in the Orders table as a foreign key back to the Customers table, you can do a group by on the Orders.CustomerID and do a count. Using the Northwind database schema:   select CustomerID , count ( OrderID ) from Orders group by CustomerID This will only give you results for the customers that have orders. If you need the customers without orders as well, you will need to include the Customers table. For example with a left outer join: select C . CustomerID , count ( O . OrderID ) from Customers C left outer join Orders O on C ...Show All

• SQL Server SQL 2005 Enterprise June CTP Installation Error

  Tried to install several times (on Win2003 Ent. SP1) but I always get the following error: Failure adding user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005MSSQLServerADHelperUser (1388) The user varies (sometimes NT AUTHORITY\SYSTEM) and so does the local group (sometimes SQLServer2005SQLBrowserUser). Any tips Regards Roger I have tried to install SQLDEV ,But got the same error mesage. ...Show All

• Windows Forms Inherited Form

  Hallo, I have create a base form with a bsaic layout. This form have a datagridview, a button and a label in an own namespace. I 'll this form inherit an override functions to set an SQL CommandString and the columnheaders. The designer show the message "Object reference not set to an instance of an object" Who is my fail thanks ...Show All

• SQL Server Linked Tables

  I currently have a SQL Database with 1 Table. I have connected to the SQL table via MS Access 2003 via Linked Tables. I can import records from either an XLS or CSV file to the Link Tables all day. However, I cannot update nor delete records. I have given my account full DBO access to the SQL Database and Table but still cannot make any modification from within Access. Is this even possible for what I am attempting to do within Access If so, please tell me what I need to modify within SQL. Thanks in advance! colinrobinson wrote: Access has problems updating linked tables that dont have a primary key d ...Show All

• .NET Development Urgent: MSI forms Memory Leak: Major Issue

  Hey guys, We have, a windows form application in VB.NET. The way this application is structured is, there’s a MasterForm which contains a Main menu and acts as the mdi parent to around 20 windows forms. We have a BaseForm with some controls on it inherited by 20 other forms. The problem we are facing is, as we work on the application, as new instances of the forms are created, the memory used by the application keep on increasing (Memory leak happens). We have even run QTP scripts and observed the Memory usage on TaskBar. It just keeps on increasing consistently. On some of the forms we have like around 30 labels and equal number of textb ...Show All

• .NET Development Web service request fails with HTTP status 400: Bad Request

  I am having troubles with the 400: Bad Request error with my web services, called from ASP.NET 2.0. Here is the setup: App Server A: IIS 6, Windows Server 2003, ASP.NET 2.0 (local dev box) App Server B: IIS 6, Windows Server 2003, ASP.NET 2.0 (test server) App Server C: IIS 6, Windows Server 2003, ASP.NET 2.0 (production server) DB Server D: SQL Server 2005 running native web services (Windows Server 2003) Servers A, B and D are on the same subnet. Server C is on a different subnet. Scenario: Servers A and B work fine! I can call the web services exposed on Server D without any problems. Server C is the troubled server. The first web servic ...Show All

• SQL Server inner join on reverse records

  I have some data that looks like this Col1 Col2 SumCol XXX,YYY, 5 XXX,ZZZ,6 ZZZ,XXX,7 YYY,XXX,2 I want to do a inner join on that data so I get this XXX,YYY, 7 XXX,ZZZ,13 Right now I'm using a CTE set to do that, is there a better way akula wrote: I want to do a inner join on that data so I get this XXX,YYY, 7 XXX,ZZZ,13 Why that should't be a YYY, XXX, 7 ZZZ, XXX,13 or YYY, XXX, 7 XXX, ZZZ, 13 ...Show All

• Visual Basic Where to find BASIC help after downloading and installing Express with small option

  I thought I remembered being asked if I wanted to download a monster help file and since I wasn't sure about Express, I said no. Now I have used it for a while and want to avoid the online help - where do I find it Other learning resources can be found here: http://msdn.microsoft.com/vstudio/express/vb/learning/default.aspx The only place I saw to download the express MSDN library was with the express products...Download it again: http://msdn.microsoft.com/vstudio/express/vb/download/ Full Installation: 1.3 GB Also includes MSDN Express Library 2005 and Microsoft SQL Server 2005 Express Ed ...Show All

• Visual Basic Error Message

  I'm currently working for a engineering company and it is my first time using visual basic. This piece of code was written by another person and i must fix the problem within the code. If anybody can find it, it would be really thankful. Here's the code (This is one section of the whole code, one class): Sub CheckSummerWinter() 'Check to see if Summer/Winter selection changed 'Remove protection Passwrd = "ESGtrcCv" & Trim(Right(Worksheets("EnerSpectrum Group").Range("Version"), 4)) Worksheets("Avoided Load Profile").Unprotect (Passwrd) Sheets("Avoided Load Profile").Select ...Show All

• Visual Studio Express Editions Error Installing Visual Studio C++

  Hi guys I have a problem installing VC 2005 Express and I hope that you can help while installing it I get this error " Error. Writing to file: Microsoft.VSDesigner.dll.   Verify that you have access to that directory. " then when I click retry I get this " The installer has encountered an unexepected error installing this package. This may indicate a problem with this package. The error code is 2350 ." I'm very sure that the CD is ok and there is enough disk space please help because I'm very excited about VC++ 2005 and I can't wait to get it installed . Hi there - Does the install conti ...Show All

• Windows Forms ErrorProvider's validation events gets lost between tabControls.

  First off I have used the ErrorProvider before and understand the concepts and have placed them successfully on other dialogs. But I have run into an issue where the validation event goes missing...I can recreate the scenario here, it involves two tab controls, a button and a textbox: Working Scenario Create a Winform application. Add an errorprovider component. Add a tab control (#1) to the form. To the winform: Add a textbox which will handle the validating event. Override the validating event of the textbox to show an error message. To the tabpage 1: Add a button which will signal the validation event. Add the SetIcon alignment to the w ...Show All

• Software Development for Windows Vista InnerException {"Event \"HighRiskEvent\" on interface type \"MainWorkflow.ICommunicationService\" for instance id \"feae4f11-

  Hi, I am getting following error: - Exception {"Exception has been thrown by the target of an invocation."} System.Exception {System.Reflection.TargetInvocationException} - InnerException {"Event \"HighRiskEvent\" on interface type \"MainWorkflow.ICommunicationService\" for instance id \"feae4f11-87e5-43a1-8807-cfd98d9ca81d\" cannot be delivered."} System.Exception {System.Workflow.Activities.EventDeliveryFailedException} - InnerException {"Event Queue operation failed with MessageQueueErrorCode QueueNotFound for queue 'Message Properties\r\nInterface Type:MainWorkflow.IC ...Show All

• Visual Studio Express Editions Data types: Decimal vs. Double

  Can someone explain to me the difference between a Decimal type & a Double type & explain where it is appropriate to use each one Thanks... One difference is that, from memory, it's Decimal that, when divided by zero, doesn't throw an exception, and has a value of infinity in that case. That's bitten me in the past, especially in VB, which is weakly typed, so a Double can turn itself into a Decimal, as if by magic... ...Show All

• Visual FoxPro newbie here...

  hi to all... i have a form named customers and i have txtboxes to input all information i needed. i have a grid that shows all the records in the table customer. works fine on loading. now, i have 2 buttons previous and next respectively. my codes are as follows: Previous Button: USE customer if not BOF() skip -1 thisform.refresh() if BOF() go top endif endif Next Button: USE customer if not EOF() skip thisform.refresh() if EOF() go bottom endif endif Now, my problem is that when i move to another record by clicking next button, my data on the text boxes moves fine and my grid goes white with no data on it, ...Show All

• Visual Studio 2008 (Pre-release) runtime compilation of Linq code

  Hello, Would you know of any ways to provide on-the-fly compilation of C# 3.0 code There must be some CSharpCodeProvider for it somewhere.. Thanks, NR Why would you need it You might create source code and invoke Linq compiler to generate an assembly, inmemory perhaps. ...Show All