I. Silvestri's Q&A profile
SQL Server Function that returns a table
I have a function that returns a single row table with two columns: dbo.Fun1(@param1) : colA and colB I tried to create a stored procedure that use this function: select col1, col2, dbo.Fun1(col1) from table1 The result is : Invalid object name 'dbo.Fun1' There is no join between table1 and Fun1, how can I select the both columns of Fun1 Thanks in advance. Long You are trying to use a table-valued UDF like a scalar UDF which is incorrect. You can use a table-valued function only in the FROM clause or as a table source. In any ca ...Show All
Visual Studio Team System Build always checks out most of 'Bin' directory? (VS2005 Team Suite RC1)
I searched a bit for this, but VS2005 Team Suite has been checking out most of my 'Bin' directory each time I open OR build my solution. Has anyone seen this before Is this simply an option that I have forgotten to turn off or is this a bug fixed in RTM Its a very annoying behavior, because often I just want to build the solution and don't have any pending changes, but because its checking out everything all the time it picks up all the Bin and Solution (.sln & .vssscc) files as Pending Checkins.. My team is using VS2005 Team Suite RC1 running on Virtual PC 2004 SP1 and connecting to Team Foundation Server Beta 3. Thanks, Graham ...Show All
Microsoft ISV Community Center Forums VB and Excel - Change Event
I am new user. Any help is appreciated. I have column with drop down selection - If a certain value is chosen, I want to control the format of the next cell. The Worksheet_Change event seems to capture this event if the user selects the change from the drop-down, but not if the user types the value in the cell and presses <enter>. How can I make sure that I capture this in both cases Hi, You can draw two types of combo boxes on a worksheet, one is drawn from the Form toolbox and one is drawn from the Control toolbox. The combo from the control toolbox lets you place VBA code behind it. Wit ...Show All
Windows Live Developer Forums WHY?
What was the problem with the previous skin ! I liked it very much, better then this one. It's like messenger 7.5 . The previous skin was colourful and this is ugly! Where are the colours I lidek the real colours not these light things! Why did you change it Why I'm talknig about the new messenger beta ! Please refer to How to get Messenger Technical Support http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=368260&SiteID=1 . ...Show All
SQL Server SSIS error listing
Is there a list of all the SSIS Error codes and what they mean Ex. -1071607778 is an error code output when a lookup task fails to find a match. I haven't been able to find any information on the different error codes. Is there a description file or enumeration file that exists somewhere I think it's still hex, the L at the end is usually included in literals to denote the size of the integer - i.e. L = long, whatever that may be for the platform, 32bits in this case I'd imagine. -S ...Show All
Windows Forms Two Questions
I'm trying to implement a simple DataGrid. I'm binding it to a strongly-typed collection. I have two questions: 1) I have two special columns. Now, I only want the values of these columns to be shown (this is specific for each individual row) if the value of one of these columns (a date) is between the value in two other columns. So, I have&n ...Show All
Visual Studio Express Editions Registration benefits
I just read the announcement about the benefits of registration. I already had registered so of course it didn't let me register again. Is there a way to still get the downloads or should I now know never to register an MS product until they have some registration benefits announced If you are registered you can take part of the benefits. Check the registration benefit portal. http://connect.microsoft.com Log in with the e-mail you registered with. ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Transformation of a single object
Hi! I just started learning directx and here is the first of probably many newbie questions. Please, be patient :) How can i transform a single object I used Sample Framwork to load a "tiny.x" mesh and created simple triangle. I can rotate them together (by rotating the whole world) but how can i transform only one object I've got also small problem with my "tiny.x" mesh. It's not so tiny after all :) If i move my camera, so i can see the whole mesh and rotate the mesh (or move camera too far away) it disappears. Does it have something to do with my projection parameters Can i scale down this mesh after loading it (so do it only on ...Show All
Visual Studio Team System How TFS is suitable for real projects?
Hi all, I know, the question seems to be stupid, but how current version of TFS Beta 3 Refresh is suitable to be used for real work I mean, is this beta could be used only to see the progress and learn, or it is possible to use it with real projects without big risks Especially interesting the source controlling part. How buggy is it Where I could see the known bugs May be there is some experience when try to start/continue some project with current beta was completely failed I am leading a fairly large team that has been using Team System I believe for over a year now (We used Beta 1 for Wor ...Show All
Visual Studio Tools for Office Smart Docs in SharePoint
Hello, First, I'll paint the picutre of what I have set up... I found that I could deploy a Smart Document solution to a Document Library in SharePoint by publishing to the 'Forms' directory inside of the target Doc Lib. The actual publish would fail as VSTO doesn't have the ability to interface with SharePoint yet, but I would just use Frontpage to actually get the files in there. At this point, I have a Smart Document and its assemblies in a Document Library as the document template. When users click the 'New Document' button, the smart doc is brought down (Excel in this case) and everything runs great. When they save it back to t ...Show All
SQL Server Modify the expression to be valid
I pass in a variable SourceServer to my package via the command line. In our production environment we are seeing: The expression "@[User::SourceServer]" on property "ServerName" cannot be evaluated. Modify the expression to be valid Is this just because the evaluation takes place prior to the command line parameters being set and I need to turn off validation Thanks, Chris Chris, Are you running RTM ...Show All
Visual Studio how to find common script folder
Accessing common build scripts, We have a couple projects those are checked into source control, generally people use vs.net to do development and build. I want to enable use of msbuild along with that I want to simplify project files so that it imports common properties. It will enable future changes esier. Issue is how I find the common script folder which in build sub folder under root source folder (which may be different for different users), I don’t want to declare it in env because user may have more than one . Any solution how can I traverse part folders to import a commo ...Show All
Windows Live Developer Forums V8 Beta
What do people think of Beta 8 It is a little to much candy for me, i like a more basic Messanger. Hiding the tabs and disable the nasty mouse hover in you contact list makes it much better. MSN Messager 8 has a lot futures it don't use, but it works fine. I love the Shared Folder future, it is great to share files and they stay shared. So you normally send a file to a contact and the connection fails you must resend it again and again. Now i put a file in the shared folder and my contact can download and re-download it a many times he wants. Only the Alert service is not working well, i receive all Al ...Show All
Visual Studio 2008 (Pre-release) Embedded UI Elements in RichTextBox - Disabled?
I am trying to embed user interface elements inside a RichTextBox control. In particular, I would like to embed a RichTextBox inside a RichTextBox. I can't seem to get the embedded control to be enabled for editing (or clicking in the case of a button). Setting IsEnabled = "True" in the XAML doesn't do the trick either. What should I be doing Is this currently supported e.g the embedded button with the "Click Me!" caption in the XAML sample below is not click-able: <Window x:Class="WindowsApplication1.Window1" xmlns="http://schemas.mi ...Show All
Windows Forms Extreme Menu Generation
anyone have any article links or advice on creating menu's on the fly from xml I want to be able to add menu's for an app that uses snap-ins, and include a definition file that adds snap in menus to the application menu. I want to be able to 1. create top level menus if they don't already exist 2. add to top level menus if they do ...Show All