bbossi's Q&A profile

• SQL Server Group by on a concatenate field

  Select TOP 100 CONVERT(VarChar(10),Service_Prefix)+ '' + CONVERT(VarChar(10),Service_Code) as CODE, Date_Issued, sum(Amount) from dbo.Enterprise_Credits_Import_90_days where CONVERT(VarChar(10),Service_Prefix)+ '' + CONVERT(VarChar(10),Service_Code) <> ' 0' and Service_Prefix like 'F' Group by How can I group by the field that I selected as CODE I tried the first statement and was able to make it work. Thanks for the info. The second query gave me this error Server: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'with'. Also due to the fact that the database has around 6 million records the group by's seem to make the query take a while to run. Is there a ...Show All

• SQL Server how to get the real boundary of "time" dimension of a subcube dynamically?

  how to get the real boundary of "time" dimension of a subcube dynamically e.g. CREATE SUBCUBE [SMS2005] AS ( SELECT ( [time].[date].[date].&[2007-01-01T00:00:00] : [time].[date].[date].&[2007-01-10T00:00:00] ) ON COLUMNS FROM [SMS2005] ) go I want to create a global measure that show the stocks on the boundaries of the subcube'range (in this case , they are 2007-1-1 and 2007-1-10). Whenever a different new subcube (focused on time dimension) is built, this measure can behave differently based on the subcube. To this problem , I think the key is that how to get the real boundary of "time" dimension of the subcube dynamically in the definition of the globally wanted measure. Does anyone ha ...Show All

• Software Development for Windows Vista 360 as extender to Vista MCE, DW20.exe crash??

  Anybody else experiencing this problem It runs ok for a little while and then the 360 MCE stops and gives me connection error. Log file in vista says its DW20.exe that causes the fault. I've searched, and seems its to to with office application feedback or somthing. It ran smooth before, so it might be because I installed Transcode 360 beta, will of cause try and uninstall. The MCE in Vista runs smooth without any problems. Only in the 360 it appears to cause problems. I tried two different 360's just be certain the problem was not here. Any clues Thanks Please note that this forum is geared toward software developers creating their own programs. That said, see the link below which may help you wit ...Show All

• SQL Server Orphaned SQL Logins on the Mirror

  Hi there, I’ve recently set-up database mirroring between two servers in the same domain: DMZSQL01 and DMZSQL02 with a witness of DMZSQL03. The mirroring as all gone according to plan. Set up all the users/databases on the Mirror (DMZSQL02) and then do a back-up/restore to sync the databases and then enable the mirroring, this has all gone fine and we have lots of synchronised/mirrored databases now. However, if I do a failover the logins on the mirror are not valid, they are in SQL Server and also the database but they don’t work. I’ve read through other posts and found links to this SQL Server article: http://support.microsoft.com/kb/918992/ This has had no effect though. Do I need to remove ever ...Show All

• Windows Forms Change Opacity of form...?

  Hi... I want to change the 'Opacity' property of my form when i move my form using mouse from one place to another while application is running. I want same effect as we can see when we get an exception while debugging any application in VS2005. We get one form & if we try to move that form its opacity chnges & that form becomes normal when we stop moving that form. Thank & Regards, Vinay Dear Vinay, Try this link http://www.codeproject.com/csharp/diffusedialog.asp df=100&forumid=197828&exp=0&select=1180440 HTH, Suprotim Agarwal ...Show All

• Smart Device Development How to put the application into the device?

  Hi, newbie needs help ... I have developed a helloworld application written in C# and it runs well in the Windows Mobile 5.0 Pocket PC Emulator. If I want to put this application on my mobile, what will be my next step I have changed the Solution Configurations to "Release" and have found the "Hello.exe" & "Hello.pdb" in the "\bin\release\" folder. When I use the USB cable to put these files into the mobile (with activesync activated), they cannot be run. In fact, I just want to create an application which can be run under "Programs"... Do I need to create .cab file What steps should I do Pls help. Thanks. First try whether the correc ...Show All

• SQL Server Is SQL Server CE really the solution?

  Hi,   So far, with other programming platforms, I used to have the facility, embedded within application .exe, to:        1- Interface with already existing "multi-user" database (ex: Oracle, Access, etc.)        2- Create/access "local"/"Single-User" files for processing purposes.  (try to minimize network trafic...)   So far, I've read a lot about SQL Server products (SQL Server, Sql Server Express, SQL Server CE), at least all articles I could find, and would like to have your opinion on what would be the best approach        1- What SQL version to use for "multi-user" databases &n ...Show All

• Visual C# Status Strip Progress Bar? C#

  Hello all, I have Visual C# 2005 and I have only been working with it for a couple of days but I'm stuck. I'm trying to get my progress bar, located in my status strip to do something but I can't seem to figure out the right code for it. Could someone help me fill this in, so I can move on. Thanks for any help in advance... oops 1 more thing... it says ProgressBar1_CLICK I want the bar to load the progress of the browser as it loads web pages. So is that correct Sorry for the noob questions, just trying to learn... private void toolStripProgressBar1_Click( object sender, EventArgs e) { } Add using System.Threading; at the top. When you see ...Show All

• Windows Forms [SOLVED] Selecting a certain cell?

  Hello, [C#] A quick question. I have a DataGridView with 4 columns (title, name, age, misc). How do I display a certain cell value to a TextBox field, as in when I select or trigger one of these events RowHeaderMouseClick or CellEnter event I want : textBox1.Text = the current rows "age" cell .Value.ToString(); Thanks all. you could also use: textBox1.Text=dataGridView.Rows[ dataGridView1.CurrentCell.RowIndex ].Cells["age"].Value.ToString(); ...Show All

• Visual Studio CAB File Project: DLL Version for CAB file

  Hello, I hope that I have the right forum for this post. Anyways, I have a Microsoft Visual Studio 2005 CAB file project. The project builds the CAB file nicely packing properly the single DLL and its corresponding INF file. VS05 also automatically adds an OSD file to the CAB file, which it automatically creates. Here is where my problem lies. The DLL does have version information and is signed. The DLL reports and furthermore viewing the properties for the DLL shows the correct version string (i.e. 2.0.60914.1). The problem is that the OSD file The file, shown below, should show the version as "2,0,60914,1" but rather shows "1,0,0,0". What I don't understand is how VS05 arrives at the version number and how can I get ...Show All

• .NET Development Control individual pins of serial port using c#

  Hi all. I had a question about controlling the serial port (9pin). Basically I am trying to control some TTL chips and I need at a minimum 3 pins that I can control at will. I would like to be able to send info bit by bit. I have never done anything interfacing regular logic chips with the PC, and I hope to learn with this. I am not able to use a parallel port because no motherboards I use have a parallel port and the environment I will be using this in has only serial ports. I would love to be able to do something like: Pin1.setHigh(); Pin2.setLow(); Pin3.setHigh(); Pin1.setLow(); Pin2.setLow(); Pin3.setLow(); I reallyhope this is possible. Also if this would be easier using USB and some other chip, then that would appreciated too. ...Show All

• Visual Basic click and drag, howto?

  How to click and drag a component, such as textbox for windows application and smartdevice app I'm sorry..but it still got an error 'Location' is not a member of 'System.Windows.Forms.MouseEventArgs'. I try to change e.location with textbox1.location > no error! but I can't find the the textbox events such as MouseMove, MouseDown, Mouse Up still need help, thx ...Show All

• SQL Server How to Give the "Null" Value in the Derived column Expression Value

  Hi I want to pas one Derived Column Value is "Null" Default . How to Give the Expression " For Example" The Derived Column i gave one Column Name Derived Column Name Expression Data Type Price "" Any one give me the Solution If you look in the top right-hand pane of the editor, there is a node in the functions/operators tree view for Nulls. You use the keyword NULL, but also need to type it, so the exact expression will depend on teh column type you have. For a unicode string DT_WSTR, length 10 - NULL(DT_WSTR,10) For an integer DT_I4- NULL(DT_I4) ...Show All

• Visual Studio 2008 (Pre-release) SQL SubQuery using LINQ

  How to write a LINQ Query with Subquery where I want to use "In" or "Not In" clause It would be helpful if someone could please provide an example: For example I wanted to convert following sql query to LINQ. "Select CusotmerID from Customers where ProductID in (Select ProductID from Products)"   Please convert following query using LINQ syntax: "Select CusotmerID from Customers where ProductID not in (Select ProductID from Products)" Thanks, Rajesh ...Show All

• Visual Studio Team System TF30063 error using Cruise Control

  I'm trying to get Cruise Control working with TFS. I have TFS on one machine and Cruise Control on another machine. Both machines are in the same domain. I have installed VS2005 on the Cruise Control machine and can connect to TFS using my Windows login username and password. I have set the TFS Build Services to allow the Windows login username to be one of the members of the Build Services group. When I run Cruise Control I get the error message: Microsoft.TeamFoundation.TeamFoundationServerUnauthorizedException: TF30063: You are not authorized to access kSource. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized. So I'm at a lose what the problem is. I've search the forum but I haven't found the twea ...Show All