Russ McDaniel's Q&A profile

• Visual Studio Team System update some files

  Hello, I would wish to update some files between two branche with API TFS Thank you Is BRANCH2 a branch of BRANCH1 or vice-versa If I'm understanding you correctly, you want to merge the changes from branch2 to branch1 - from the command-line, that would be "tf merge branch2 branch1 /r" and from the OM it will be the call to workspace.Merge. If they don't have a direct branch relationship, you'll need to either merge the changes to their common branch first and check them in there *or* do a baseless merge to get the changes over. ...Show All

• Gadgets ActiveX help

  I originally posted this on MicrosoftGadgets.com but I don't think I can reply there anymore. Basically, I want to create a gadget that uses my online web service, but I don't want the location (or password) visible in the source code for my Gadget.  What I really want to do is create an ActiveX component that will make the call and return the XML (or even better, parse the XML to HTML) to the gadget. Problem is, I have no idea where to start when it comes to ActiveX programming, can anyone help Andy   Tom, I'm not really great with any 'hardcore' programming languages like C++ or VB. I did a lot of VB when I was younger, but I'll be damned if I can remember any of it. I'm more of a web coder than anything ...Show All

• SQL Server summing a column, using a pivot table, accounting for NULL

  hello, i'm using sql200 and i am attempting to create a table that has an hourly-incrementing 'Date_Time' column, with a corresponding 'Total' column (which keeps a running total of values off of another table) . The code I am using right now is... declare @date as smalldatetime set @date = dateadd ( yy , - 1 , cast ( convert ( char ( 11 ), current_timestamp , 101 ) + '00:00:00' as smalldatetime )) select dateadd ( hh , i , @date ) as Date_Time , sum (Subtotal ) as Total into #POGtable from Pivot , OrderGroup where i between 0 and 24 and CreationDate between @date and dateadd ( hh , i , @date ) group by i select dateadd ( hh , i , @dat ...Show All

• Visual Studio Express Editions SetWindowsHookEx

  Is there a SetWindowsHookEx ,CallNextHook , and GetASyncKeyState for VB2005 Those are Win32 API functions and yes they can be used in VBEE05...You just need to make the correct declaration for each function... Serach the MSDN Library for more information on the functions ...Show All

• .NET Development How to copy a file to a folder shared on the network

  I am generating a zip file then I have to move it to a folder shared on one of the system in the network. How Can I to move a folder into shared folder on one of the system in the network in C# .net 2.0 Additional info: http://articles.techrepublic.com.com/5100-10877_11-6152061.html Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• SQL Server Auto Updates for SQL Server?

  Our IT guy insists that he must be present anytime the SQL Server automatic updates from Microsoft are installed on the server or the server will crash. What has he been tinkering with to cause this to happen or is he just giving us a line Well, I wouldn’t apply all patches to SQL Server without any notice ot testing. Normally the updates or patches don’t break the functionality of SQL Server. To be sure, I would test the patch on a testing server. If you have a WUS, you can setup the server to confirm the patch first before applying the patch on the SQL Server. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Audio and Video Development Text to Display Rending

  Here's the issue in the simplest terms I can explain it. This all started with subtitles. It is obviously easier to have a markup file with all the subtitle text in it instead of having to make individual graphics for each. Far as I know, this should be possible. Unfortunately, it's not going so well. After many attempts at subtitles, I decided to just add a very basic text output from the main markup file. It still did not work! I've checked the fonts, tried a few, and they are all Open Type. It's a very simple piece of code that just sets the position, font, and color. I left out all the timings and animations to be safe. Is there a bug in the Toshiba Players that won't do this or I am just overlooking something right in front of my face ...Show All

• .NET Development Remote Event's handler in client application

  I am using C# with Singleton. on .NET framework 1.1 I want to call an event using delegate on remote object and want to handle it into client application. After building remote object 's project(Class library) I have copied that .DLL in client and added reference to it in client project. In server config file I have set typeFilterLevel to full . But I am not able todo that. It is showing Security exception. Do I need to write cusomized sink to do that or without that also It can be done. I need the simplest way to do that. If Source code of my apllication is required let me know... I will post that too... Thanks. An unhandled exception of type 'System.Runtime.Serialization.Serial ...Show All

• SQL Server Update slow(5 Hrs, 14mil rows) on perm tables, however as part of SP using temp tables fast(45 mins 14mil rows)

  Greetings All ITEM1: Here is the statement :(Perm Tables) update jkk_AllLogic_Allocation1_Work set ExpAllocValue = a.ExpFinValue * (a.SalesFinValue / s.TotSalesValue) from jkk_AllLogic_Allocation1_Work a, jkk_SumOfSales2 s where a.ID = s.ID ITEM2 Here is the similar Statement(excerpt) from SP: /* Adjust Expense amount depending on sales ratio */ update #AllLogic_Allocation1 set ExpAllocValue = a.ExpFinValue * (a.SalesFinValue / s.TotSalesValue) from #AllLogic_Allocation1 a, #SumOfSales2 s where a.ID = s.ID The SP does a lot of things Update being the longest. QUESTION Why is ITEM1 taking 6 times longer to run than ITEM2. I am totally confus ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. PIX crash when attempting to set shader variable

  I've got some code that works fine when not running via pix, how ever when i run it through pix it crashes. I've found that the crash is caused when i call either: SetResource or SetMatrix here is my code: void DX10Effect::SetTexture(EffectParamHandle handle, Texture* texture) { HRESULT hr = ((ID3D10EffectShaderResourceVariable*)handle)->SetResource( static_cast <DX10Texture*>(texture)->GetTextureRV()); int nothing = 0; } void DX10Effect::SetMatrix4(EffectParamHandle handle, const Matrix4& matrix) { HRESULT hr = ((ID3D10EffectMatrixVariable*)handle)->SetMatrix(( float *)&matrix); int nothing = 0; } EffectParamHandle is typdef'ed as a void* so hr = S_OK when ...Show All

• SQL Server Send the RDL Report to Printer without preview in preview window?

  i don't want to first preview the report and then click the printer toolbar button on preview button. i want to send the RDL Report to printer with out preview the report, 1- Is It possible if yes can any one tell me what should i do in vb.net 2005. Waiting........... ...Show All

• Visual Studio 2008 (Pre-release) How to ignore subsequent mouse clicks without using code

  My brain cells must have all evaporated because I can't think of an easy to do this in XAML without resorting to code: I want a text block to move from upper left corner to the center of the page when the page loads and when the user clicks on text block it moves back to upper left of page. Subsequent user clicks should not do anything. But if I animate the mouse down event to do a translate transform, the text block briefly goes back to the center then moves to upper left. I want it to stay in UL if it is already there. I don't know whether the following code meets your need: <Page xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.micros ...Show All

• SQL Server "Intellisense"......

  According to the link: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx under Programmability Features, Transact-SQL IntelliSense is supported for Sql 2005 Workgroup edition on up. I have never seen Intellisense in the Query Editor. Can anyone comment on what the URl is referring to TIA, Barkingdog ...Show All

• Visual Studio Adding fields to report at runtime

  Im setting the datasource of my report to a datatable, which is fine. The problem i am having is that i dont know how many columns there is in the datatable until runtime. I need to be able to add database fields to the report at runtime. In addition i need to be able to format the field based upon its value and the state of the previous field. This report show the availability of a room over a given period. Many thanks Jay Using the standard .NET SDK you do not have the ability to add fields at runtime, you need to use the RAS SDK which is only available if you have Crystal Enterprise, Crystal Reports Server, or Business Objects Enterprise. As for formatting fields based upon thei ...Show All

• SQL Server How do I Transfer an updated procedure to a live site?

  Hi, Whilst not new to online database and web design I'm relatively new to ASP.NET and SQL Server. Can you guide me in this final hair tearing problem. If I have a development system on my local machine and a live system on the web how do I achieve the following:- If I make a change to a local Stored Procedure (or add a new one) after testing how do I transfer the changes to the Live Site Similarly if I add/amend a field to the database how do incorporate that change on the live site I can't find any tutorials on this on the net (probably because I don't know which terms to use in my search) Thanks in advance Thank you for the information. Having now searched to a ...Show All