AK_00's Q&A profile

• SQL Server Need to Subtract the result of two stored procedures

  I am trying to take the results from two stored procedure and subtract them to get credit from two columns. The stored procedures look like create PROCEDURE mw AS select * FROM pla p where p.st in ('ds', 'sd') and (iPlayerID = '5345') compute sum(p.amount) RETURN both procedure have the same syntax. I am not able to use AS in to insert the values into a variable. Is there a wizard to use Please check under the "CREATE FUNCTION" article in books online. It should be something like this: -- Table Function create function dbo.fmw ( @pm_iPlayerID varchar(10) -- Guessing at size ) -- You will need to make it right returns @outputTable table ( col_01 ty ...Show All

• Software Development for Windows Vista sdk sample - boot image problems

  Using the sdk sample app: "C:\Program Files\Microsoft SDKs\Windows\v1.0\samples\winbase\storage\optical\imapi2sample" I tried taking the image from a boot cd (known to work). Then extracting the boot image. Then burning the data from the disc (temporarily copied to the hard drive) along with the boot image to create a new boot cdr. It does burn the disc (in separate attempts, I used both bbie and ultraiso to create the boot images) - but the disc will not boot a computer :-| The computer complains with: "CDBOOT: Couldn't find NTloader" Shouldn't this work I already know the boot image is fine. (I can use it in other ways to make boot CDs and I have also used v ...Show All

• Visual C# Application with Input files..

  i want to create application that support input of Files i dont mean Drug and Drop (not sure anyway) i want to create the program which u can do Application.exe Test.text which returns the info about the Test.text file which Classes needs to be used the program is using Registry Key so it can be using by press a file or directory. For Example of Registry Value Application.exe "%1" Thank U in Adavnace.. :D well you need to look at the arguments passed into your app either via the main method or via Environment.GetCommandLineArgs() method, which returns you a string[] array of parameters passed to your application. a small example... static void Main( string [] args) { if ...Show All

• Microsoft ISV Community Center Forums How to delete files ina directory with a certain pattern

  Hi, I am littel bit of knowledge on WMI and VB Scripts and i am looking to accomplish the following task on a Windows 2003 Server. - I need to scan a directory for files with a certain pattern, once i get the list, i need to delete all the files except the last iteration. Example:- Say the Dir is D:\Logs ; under that directory there will be files with the following pattern. D:\Logs\Trace.trs, D:\Logs\Trace_1.trs D:\Logs\Trace_2.trs D:\Logs\Trace_3.trs D:\Logs\Trace_4.trs D:\Logs\Trace_5.trs I want to delete all the files except [D:\Logs\Trace_5.trs]. - Srini. blackmamba wrote: hey, you could use dir to browse through files in d:\Logs directory and kill if a c ...Show All

• Visual C# How to save a project in .NET2005 to be opened in .NET2003?

  How do you create/save a C# project in VS.NET2005 to be opened by another developer using VS.NET2003 Thanks for any help. AFAIK, That is not possible. Once you create/convert project into VS.NET 2005, it will not opened by VS.NET 2003. If you use only .NET 1.1 APIs in your project then you can open project in both of the visual studio but what if the project has .NET 2.0 APIs used Also, it will be difficult to manage that way, So, IMHO, its recommended that you use VS.NET 2003 if its compulsion to use by some of your developers and if some of ppl uses VS.Net 2005 then make a diff copy of solutions/projects for VS.NET 2005. And if VS.NET 2003 guys are implementing new things then you can ju ...Show All

• Software Development for Windows Vista Roles and next activities help needed?

  Hi Let’s say I have 2 custom activities, VerifyIDActivity and VerifyOccupationActivity. They both have a ListenActivity with two HandleExternalEventActivities (eg OccupationVerified and OccupationUnverified) . I want the user user to select one or the other. Now I add my activities to a sequential workflow that workflows a new customer. I am using SqlWorkflowPersistenceService and the SqlTrackingService in my workflow runtime. I know that I can use the instance.GetWorkflowQueueData() to see which activity is blocking and then enable or disable buttons on the screen. The problem is that I that the user needs to open the customer first to see that it is waiting for a OccupationVerified or OccupationUnverified event. ...Show All

• SQL Server TOP count in mdx

  I have this mdx query. I want to add a top count to . Lets say top 100. This is my code: SELECT NON EMPTY { [Measures].[Crash Count] } ON COLUMNS , NON EMPTY { ([Crash].[County].[County]. ALLMEMBERS * [Crash].[City].[City]. ALLMEMBERS * [Roads].[Key Rte Nbr].[Key Rte Nbr]. ALLMEMBERS * [Crash].[At Intersection With].[At Intersection With]. ALLMEMBERS * [Crash].[Street Name].[Street Name]. ALLMEMBERS * [Crash].[TS Crash Mile Station].[TS Crash Mile Station]. ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION , MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Reportability].[Is Reportable].&[Yes] } ) ON COLUMNS FROM ( SELECT ( STRTOSET (@CrashCity, CONSTRAINED ) ) ON COLUMNS FROM ( SE ...Show All

• Visual Studio Not even format solve my error :( Please Help!!!

  I’m trying to use Visual Studio 2005 to connect trough VSS, with SSL (https) enable. I’m using Windows Vista Final Version. My certificate for SSL was created in the windows 2003 server where the Virtual Source Safe Database is installed. I have two identical notebooks, with the same software, in one of them everything is working fine. So the Windows Vista doesn’t seems to be a problem. In the notebook with problem the certificate is already installed, and trough Internet Explorer everything works perfect. The Internet Explorer Security Report says everything is ok. Accessing the web service I’m asked about the Server account and everything is ok. https ://myserver.com/sourcesafe/vssservice.asmx ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Animation - Final Question

  I have a model with multiple animations in one x file, I really want to animate the bleeding thing. Now, I will hold my hands up and say that I am not a good enough game developer to produce my own animation classes ... is there going to be an example of how to do this in the near future from the XNA team Cant wait for the final xna release ... I have a working skinned animator, and am in the process of creating the tutorial (have been for a while). I tried as best I could to make skinned animation work using the built in .X importer, but simply could not. I had a working animator in beta 1, but for some reason, the ability to make it work with the normal importer has eluded me. When the tutorial is fi ...Show All

• Visual Studio 2008 (Pre-release) January Orcas CTP

  Hi! I have download and installed January Orcas CTP on virtuell server and now I can start Visual Studio Orcas 9.0, but can not find any Linq project to start playing. I am a first timer about Linq. I checked and there is a version 3.5 Net framefork installed under Windows. Regards Hello, I blogged about this when it got released, and done a few pointers on how to get started http://blog.benhall.me.uk/2007/01/orcas-january-ctp-lack-of-linq.html However, Linq To SQL (like SQLMetal) is released in a Feb CTP, but Linq to Objects and Linq to XML is useable. Hope it helps. Ben ...Show All

• Visual C++ Deleted my thread...

  <removed the inital comments> Hi RITZ, Please advise me on the exact threads you meant and I will be more than happy to follow up personally specially regarding any bugs you have posted or reported. Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual Studio Express Editions Installation Trouble

  I have a few problems while installing Visual Basic Express Normal Download I click download on the page, save it to my desktop, I run it but then it all disappears. It is still running but it isnt doing anything Manual Download I use Isohunter I download the IMG file and all is going well untill after I extract it; there is no setup.exe icon Does anybody know the source of these problems thanks I don'tn know why that happens but id rather you burn the IMG or ISO onto a CD and once you slot the CD in, it should auto start the VB Express Setup and its smooth sailing from there. It may also be an issue with isohunter try using another ISO extracter. hope this helped kasmatt ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. ... TRIDEX VB.NET dimistified Can it be done YES YES YES YES .............

  ok guys and girls a lot of people think you cannot use vb.net with XA, well either I am crazy or I am a wizard, it can be done the same way you do with c#, I have code for all the vb.net users who wold like to try it on my website, http://www.tridexconsultants.co.uk/pages/DirectxClasses.htm I am just waiting for the conetent pipe line stuff to get some animation into the models!!!! Every thing can be done including creating game components e.t.c, No secret to refrence an Assembly!!!! ... Tridex... found that post : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=685676&SiteID=1 Basically: Things you wo ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Reflection - Assembly.Load generates error

  I seem to be experiencing some trouble with Reflection, specifically I am trying to load an assembly and call foo.EntryPoint.Invoke on it, but when I call Assembly.Load, I get: System.BadImageFormatException was unhandled Message="Could not load file or assembly '90112 bytes loaded from TestReflection, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format." Source="mscorlib" FileName="90112 bytes loaded from TestReflection, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" FusionLog="" StackTrace: at System.Reflection.Assembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlM ...Show All

• Software Development for Windows Vista Directx AudioVideoPlayback bugs

  .Net 2.0 C# VS2005 SQL Server 2005 I am developing a Windows Forms training application using numerous avi files and AudioVideoPlayback.Video to play them. The file names are stored in a SS2K5 database and the files themselves are encrypted using System.Security.Cryptology. I decrypt the file into a temporary file and play that file. The problem I have is that I cannot delete the file until the application exits. I have tried Video.Dispose() and it doesn't release the file lock. The player is an MDI child form. Any suggestions David Weller: Why was my post marked as an answer The question of WHY AudioVideoPlayBack does not release the file to be delet ...Show All