SimonS_'s Q&A profile

• SQL Server A thought this would be simple...

  I had originally thought a full outer join would solve this, but alas I'm a roadblock. Perhaps it's because it's a Friday! The goal is to create the most efficient query that will display results of the daily calls and sales as this: Date EmpID Calls Sales 7/1/2006 1 20 5 7/1/2006 2 25 7 7/1/2006 3 NULL 1 7/1/2006 4 10 NULL The problem is a simple full outer join ends up ignoring EmpID 3 who has no Calls in t1, but I still want that row displayed in the results. Any ideas TIA create table t1 (Date smalldatetime, EmpID int, Calls int) create table t2 (Date smalldatetime, EmpID int, Sales int) insert into t1 values ('7/1/2006', 1, 20) insert into t1 values ('7/1/2006', 2, 25) insert into t1 values ('7/1/ ...Show All

• Visual C++ Sending CB_GETCOMBOBOXINFO Message in a Winform Application

  Hi, Trying to send the message by use of SendMessage function to a ComboBox control, first the compiler does not see the defined value of the CB_GETCOMBOBOXINFO, although the windows.h header file is added to the project. Still, have added the actual 0x0164 value of the message-constant to the code, the compiler generates errors regarding the four arguments required by the SendMessage routine. Any links to proper documentation for this task, or comments Best Regards, Reza Bemanian The DllImport is used base on some of the articles regarding the use of win32.dll with the net framework. Unfortunately this is a rather large project and I would not be able to send it to you. I appreciate your offer. ...Show All

• Visual C++ window pointer for a new window

  Hi, I have created a new window using the following method AfxGetMainWnd()->PostMessage(WM_COMMAND, ID_FILE_NEW); How can I get a pointer to this new window What is the difference between a window handle and a window pointer Pritha Hi, You can use "CWnd::FindWindow()" method or "GetNextWindow()" to retrieve a pointer to the window. As I think a window handle and a window pointer are equivalent. Take a look at CWnd members. Regards. ...Show All

• SQL Server Control/Limit Memory usage

  Hello, I was wondering if there was a setting or a way to limit or restrict the amount of Memory an SSIS package can use I know that by default the windows OS limits a process (a package in this case) to 2GB and up to 3GB with AWE enable but what if I wanted to say Limit it to 1GB of memory is there anyway to do that Is there an SSIS Engine setting or Package property somewhere Thanks! See if this helps you. Check out the Buffer size section in this paper: http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx ...Show All

• Visual Basic Working with RichTextbox control in vb.net 2.0

  Hi to all, I have a requirement like this, In my vb.net 2.0 Application, Im using a richTextbox Control. In this How can i add a short cut key to change a word to bold when i press ctrl+B.(Similar to in MS Word Ctrl+B,Ctrl+U,....) Please send me a solution. thanx in advance. Actually, its much more complex than just creating a new font from the current SelectionFont and setting the style. First, you want to be able to combine styles such as BOLD and UNDERLINE so you can't just set the style property - you have to add or subtract styles from the existing one. Second, if the selection contains more than one font type, the SelectionFont property will return NOTHING - this has to be handled... Her ...Show All

• SQL Server Date field in exported excel file

  Date field in exported excel file. I export a table to excel file by using DTS. It seems the date field show as ###### when I open the excel file. If I expend the column I see the date. Is there any way I export in away that this date field will not show up as #####. Hi, I didn't find any issue here. There is nothing wrong with your data; the cell simply isn’t big enough to display the result. Widen the column SQL Server's task is to export data into excel & it does properly. You are not loosing any data here. When it export the data it doesn't format any data, it fills/writes all the data on Rows & Columns. It uses the default column width to fill the data(64 Pixels). You can expand your columns to read your data p ...Show All

• Visual FoxPro Looking for some good software to document a project.

  Hi, I want to document a project written in VFP 6.0 I would be interested in a software which lists all programs/functions called for every menu option avaiable on the main menu. Also I want to list all dbfs used and all memory variables created for each program file. Thanks in advance. Regards, Dinesh jain_dinesh@hotmail.com Hi Andy, Sorry please ignore my previous reply. The correct details of what I am after is as follows:- I have executed the FoxPro built in VFP dcumentation wizard. But it is not offering the details that I am after. What I want is a simple heirarchical listing of programs used for every menu option defined under the Main Menu. for eg:- for <Menu Option 1 selected> - Calls: ...Show All

• Visual C# PInvoke for LsaNtStatusToWinError in .NET 2.0

  The following signature worked just fine in .NET 1.1: [DllImport("advapi32.dll")] private static extern long LsaNtStatusToWinError(long status); In .NET 2.0 it generates an error "...LsaNtStatusToWinError' has unbalanced the stack." How do I fix the signature that is good. I tried using ulong return type to match Win32 signature better, but that did not help. The signature is wrong! Try this: [DllImport("advapi32.dll")] static extern uint LsaNtStatusToWinError(uint status); it should work fine! Cheers ;-) ...Show All

• Visual Basic Visual Basic_my game

  I would like to know how to include a number of times a button has been pressed in Visual Studio 2005 Tanx Use the VB forums Here's the code to do what you are asking Public Class Form1 Private ICount As Integer = 0 Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click ICount += 1 Me .Text = "You have clicked the button " & ICount.ToString & " times" End Sub End Class ...Show All

• Visual Studio Express Editions making it count

  hi trying to make a label count upwards. what have I forgot Dim tries As Integer = +1 Label10.Text = tries.ToString thank you whoisit, that worked how I wanted sorry I havent got my thinking hat on today, I know how basic that is lol thanks for your replies ...Show All

• Visual Studio Team System Change in Team Edition / Team System Direction??

  I'm starting this thread because all of the threads regarding DB Source Control, being able to open DB Projects in other versions of VS and other questions have gotten me to thinking and researching what is actually the reasoning / usage of Team System It would seem to me that DataDude may have gotten off track compared to the other TS Editions. If we all think back to when TS was released, we were forced to make a choice as to what edition we would migrate to. Most of us probably chose Developer. More important, the original intent (as I understood it) was that ALL TS Versions would have - 1. the same development capabilities (all types of projects, all languages, all technologies (i.e. Windows Forms, ASPNET, Web Services, etc.) ...Show All

• Visual Basic RegExp

  Hi, If I had a textbox that contained the following: --------------------------------------------------- Mr FirstName LastName ABCD Ltd, Address 1, Address 2, Town/City, PostCode, Notes1, Tel: 0171 800900, Fax: 0171 800909 --------------------------------------------------- how can I parse this to -------------------------------------------------------------------------------------------------------------- Mr, FirstName, LastName, ABCD Ltd, Address 1, Address 2, Town/City, PostCode, Notes1, 0171 800900, 0171 800909 -------------------------------------------------------------------------------------------------------------- I now this can be done using Linux GREP but I am new to regular expressions and its options. Any assistan ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Help with a First Person Shooter engine!!!!!!!!!!!!

  Ok, first let me thank you for taking your time and helping me, i am 17 years, and just started to understand DirectX. I have been building up online shooter for quite  along time now, but I have two main problems: 1) I don't know how to make my mouse rotate the Camera in X and at the save time move it (the camera), to give the person the classical feel it him in that game. I mean, i know Direct Input and all, but all the matrix operation I have think of are useless. And I have tried to do something like this: GraphDevice.Transform.View = Matrix.Multiply(Matrix.RotationY(-MousePos.X), Matrix.LookAtLH( New Vector3(-CameraPos.X, CameraPos.Y, CameraPos.Z), New Vector3(-CameraPos.X, CameraPos.Y, CameraPos.Z - Dif), New ...Show All

• Visual Studio Crystal Report Toolbar

  While running my crystal report on web. I am not getting the Crystal report toolbar in a proper format. regards Hmmm... the IE behaviour sounds like a misconfigured Viewers Virtual Directory. Can you check to see that the Directory is configured correctly The steps are listed in the documentation . - Dave ...Show All

• SQL Server where is the IsSorted property?

  Hello.  within a data flow task I have two OLE DB sources that I am attempting to put into a merge join. When I connect them to the merge join transformation I get the following error: The IsSorted property must be set to true on both sources of this transformation. I understand what this means but I cannot see an IsSorted option in the properties of the OLE DB sources so I can't set it. Can you tell me where it is for the time being I'm having to put a sort transform in to get it to work. Thanks     Go to the advanced editor of the OLE DB source; then to the input and output properties. Expand the OLE DB source output node and the output columns folder. There ...Show All