JGreene's Q&A profile

• SQL Server Concatenate Rows into Columns

  I have a table 2 columns (Object and Weight) with data like below: Object Weight(lb) table 5 Chair 6 Computer 3 Computer 5 TV 20 TV 15 Radio 10 Computer 10 Question: I would like to create a new table with one column that would join the above two columns like below Object table 5 Chair 6 Computer 3, 5, 10 TV 20, 15 Radio 10 Thanks for your help in advance. SELECT t3 . Object , MAX ( case t3 . seq when 1 then t3 . Weight end ) + MAX ( case t3 . seq when 2 then ', ' + t3 . Weight else '' end ) + MAX ( case t3 . seq when 3 then ', ' + t3 . Weight else '' end ) AS Weight FROM ( SELECT Object , Weight , ( SELECT COUNT (*) FROM mergeTable1$ AS t2 WHER ...Show All

• SQL Server Parameter validation

  Is it possible to create a server side or client side validation for parameter inputs For example, I want a calender input to error when a user tries to put in a date past the current date time Hi mahimam, I think you forgot to do this. Go to the Report Parameters and Add named it Validate with the datatype is string . Checked the Hidden and Allow blank value ckeckboxes. In Available Values choose Non-Queried and from Default Values choose Non-Queried in right side of textbox then press the FX button then paste this code. =CODE.CheckSignificantDate(<parameterStartdate>.Value,<parameterEnddate>.Value) Report generation should stop because you already set the parameters to the report properties once you cl ...Show All

• Visual C++ Advice needed

  I have been tasked with providing a front end interface to an existing MFC-based DLL. It is a plain, old DLL - no COM interfaces. The DLL has some APIs that have parameters that involve template types and pointers. The goal of the project is to provide a .NET DLL that acts as a "pass-thru interface" into the existing DLL so new, .NET clients can easily utilize the DLL. My question is, would there be any benefit one way or the other in using C# or Managed C++ for my new front end application thx in advance, todd I would create a C++/CLI class library project, and add your C++ code to it (except the DllMain entry point). Design a managed class wrapper that instantiates the C++ (native) ob ...Show All

• Visual Studio Express Editions Action on Click Question.

  I am trying to make a program that utilizes an SQL Database to save data. I want to be able to click on the line in a table and have a very detailed screen pop up that the data would be entered into (Not all the data would show up in the table). I cannot find a way to do this, and figure it must be possible. Does anyone have any ideas or is able to point me in the right direction Any information would be greatly appreciated. I would also like to resize the columns and possibly change the column header colors, etc. Thanks again for any help. -Matt Hi Matt, Take heed of Marks points. They're completely valid and you'd do well to take them into consideration. As to the question of WHERE the code wou ...Show All

• Windows Forms Why does Control.DoDragDrop swallow exceptions?

  I came across a situation where an exception thrown in a TreeView's DragDrop event handler was not bubbling up to my application's UnhandledException / ThreadException event handlers. A little searching led me to this blog post: http://www.vandervelde.co.nz/2006/02/exceptions-disappearing.html I used Reflector myself to confirm the behavior. Any comments from the Windows Forms folks at Microsoft as to the reasoning behind this Brian Baker wrote: Yeah, makes sense. Too bad there isn't any "official" documentation on this at MSDN. I'm sure lots of folks have run into it before. Yeah, it can be a nightmare. Sometimes I just have blocks of code that don't execute after dodragdrop! I t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Applying custom effects to an imported model

  Hi everybody! I'm playing around with my shiny new Beta2, and I'm loving it. :) I've hit a bit of a stumbling block, though: I have a .x model that I've imported, which was pretty elementary.... What I've not been able to do is find the proper methodology for associating a custom, imported effect with the meshes in my model. How exactly do I do that And what if I want different material effects applied to different meshes in the model Thanks, and I appreciate the help! Does your custom effects have a worldprojection matrix for its vertex shader inputs You don't seem to set any of those effect parameters in the code. in fact the code you posted doesn't set any parameters at all. You have to set somethi ...Show All

• Windows Forms DataView.RowFilter not working!!!

  dtUnassignedList // is a prepopulated dataTable. dvFileteredData // is a prepopulated Datview String strrequestID = string.Empety; for ( int i = 1; i < dtUnassignedList.Rows.Count; i++) { strrequestID = dtUnassignedList.Rows [ "RequestId" ].ToString() + "," + strrequestID; } strrequestID = strrequestID.Remove(strrequestID.LastIndexOf(",")); strrequestID = "REQUEST_ID NOT IN (' " + strrequestID + "')"; dvFileteredData.RowFilter = strrequestID; dvFileteredData.RowStateFilter = DataViewRowState.ModifiedCurrent; Can any one say me why the RowFilter not working, i have tried all the ways but the number of columns remains the same. This Code i am us ...Show All

• Visual Studio Team System Source Control Explorer InvalidArgument Error on Vista Client

  We are using TFS Workgroup Edition with SP1 installed with a Visual Studio Team Suite with SP1 client running under Vista Ultimate RTM. We are getting a Source Control Explorer error when starting Visual Studio on the client. Source Control Explorer InvalidArgument=Value of '-1' is not valid for 'index'. Parameter name: index After the client has started and we open a source control tree we get this error: Error Object reference not set to instance of an object. I thought this bug was fixed in TFS SP1. Any help is greatly appreciated. Jeff Lynch MVP Windows Server System - Commerce Server http://codebetter.com/blogs/jeff.lynch I've opened a support case with PSS and am testing out a few things right now. I'll po ...Show All

• Visual Basic Alarm Clock

  Am trying to learn VB with 2005 express and am having problem with this. How do you get a time from datetimepicker and compare it with the current time on the machine TimeOfDay is a timespan type which is measured in ticks A tick is equal to 100 nanoseconds...The interval on Timer_Tick is measured in milliseceonds...even if you set your interval property to 1 you would have an extremely difficult task to be able to match the timespan to the millisecond of a user setting Since you don't need that type of precison in an alarm clock I would try and use a Time data type versus a TimeSpan...or If DateTimePicker1 . Value . Hour = Now . Hour AndAlso DateTimePicker1 . Value . Minute = Now . Minu ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Studio Express Unhandled exeptions

  Having recently installed XNA Studio Express Beta I attempted to build and debug the included SpaceWars game. I received an unhandled exeption error in the penultimate statement: this.GameComponents.Add(this.graphics); The message received is: " NoSuitableGraphicsDeviceExeption was unhandled" and the values used in the attempt to create the GraphicsDevice were invalid. Any ideas on a fix for this or is it a bug in the package itself Nigel.. Not wanting to be rude but you could have found the answer to this really easily by just searching the forum. Searching for "NoSuitableGraphicsDeviceException" returns all these threads . Quick answer is its likely your graphics card can't cope with the de ...Show All

• SQL Server Get Previous step result in an SSIS Script Task

  Hello, I am using SQL Server 2005 Integration Services to create new values for my tables. One step I must do is execute a query and the script task that receive its constraint (it is set to completion) must do different things depending on the query result. My question is: how can I know the result of the precedence constraint Thank you, Pablo Orte Hi and thanks for your replies, The problem I have is that I have to do this in a script task situated after an "Execute SQL". This cannot return any parameter and I need to have something in the code like this IF objDTSPackage.Steps("DTSStep_DTSExecuteSQLTask_1").ExecutionResult = 0 THEN This code wor ...Show All

• Windows Forms Splitter control on event

  I am trying to figure out a way to design a winform that allows me that on the left side to select a button, and on the right side of splitter, to load another winform or user control. Is there a way to facilitate this Basically, the form would be invoked by the user, and have a default screen showing a splash image on the right side of the splitter control, and on the left side would be a collection of buttons. When the click event is raised on one of the buttons, the other side of the splitter would switch to either a seperatly designed user control. The purpose of this is I am trying to consolidate the amount of windows that are opened in our in-house application. basically everything that is clicked right now brings up a new window an ...Show All

• SQL Server Sql Server Express Hangs and does not allow any connections

  Hi, We have few installations of SQL Server express on Windows 2003 servers, platforms varrying from Celeron to P4. Sql Server on system hangs after running for some time. Time varies from few hours to few days. When we try to connect it just gives connection timeout error. Any idea how to isolate the problem We would like to to enable more detail tracing but do not know how to do that. Thanks in advance. User Instances are completely separate process from the main instance of SQL Express, and they don't run for several days, they are started at runtime and shut down about 60 minutes after the last connection to the User Instance is closed. User Instances also have separate log files located at C:\Documents a ...Show All

• Visual Studio Team System Installing Teamserver 2005

  Hi, When i try to install Teamserver 2005 after installing sql 2005, i get error message to uninstall prerelease products like framework 2.0 beta version.When i remove framework 2.0 beta and install Teamserver 2005, setup fails saying sql server is not running. Sql 2005 is corrupted as soon as i remove framework 2.0 beta version Help me out Raja.K hi, you mean to say that i should go to dual server installation of TFSand then i should "install the team foundation databases tier only" for sql 2005 raja.k ...Show All

• SQL Server why data can not be seen

  I meet a problem during a project,in SSAS the deploy success,and we can see dimension's data ,but we can not see measure's data,why (data exist in database). You can debug your problem by reprocessing the measure groups. Try to see if the fact data is actually read in from the relational data source. You can use the profiler tool to monitor all SQL queries generated by SSAS. ...Show All