osamaT's Q&A profile

• SQL Server Help with Join Compatibility

  I was hoping someone could help me or put me on the right path to re-writing the join portion of this sql query in ANSI form for compatibility level 90. Im just not sure how to handle the three join statements and if they should go at the top in the FROM statement (dont know if that would mess up the rows produced). The query exists inside a stored proc. SELECT S.TYPE, S.LOCATION_TYPE, S.LOCATION_ID, S.PLANNED_ARRIVAL, S.PROJECTED_ARRIVAL, S.ACTUAL_ARRIVAL, S.PLANNED_DEPARTURE, S.PROJECTED_DEPARTURE, S.ACTUAL_DEPARTURE FROM TAB1 S, TAB2 RL, TAB LS WHERE S.LOAD_ID = @V_CURRENTLOADID AND (RL.REGION_ID = @REGION_ID AND RL.ROUTE_DATE = @ROUTE_DATE AND RL.ROUTE_ID = @ROUTE_ID) AND (S.REGION_ID = RL.REGI ...Show All

• Smart Device Development Deploy Application.CAB file and Compact Framework 2.0

  Hi Everybody, This is Chandra from New Zealand. I am currently developing .NET CF 2.0 application on visual studio 2005 for windows mobile 5.0 platform. I want to distribute my application along with .NET compact Framework 2.0 to the customer in Canada. I created .CAB file for my application.But the problem is how can I include .NET compact framework 2.0 as well so that when the user runs my application.CAB file it also installs .NET compact Framework 2.0 along with the application. I will be sending only my application.CAB file to my customer in canada and he will be installing the .CAB file on his device. I want to deploy both my Application and CF2.0 to the device at one install. I wont be having physical mobile ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. HLSL's tex2Dlod (Vertex Shader texture fetch) difference between PC and XBOX360?

  I'm am trying to read height data from a texture to my vertex shader in XNA with tex2Dlod and I have come across a difference in setting between PC and XBOX360 and I was wondering if anyone could clarify. On my PC I can fetch data without any problems using floating point texture using SurfaceFormat.Vector4. Now just from compiler errors I know the 360 does not support Vector4 textures but Single or Vector2 are supported except that when reading from the texture I get garbage unless I use SurfaceFormat.Color. My initialization for my texture is now: #if XBOX360 planetHeightMap = new RenderTarget2D(graphicsService.GraphicsDevice, 1024, 1024, 1, SurfaceFormat.Color); #else planetHeigh ...Show All

• SQL Server Reporting Services, Sharepoint Services and SQL 2000

  Hi I m have installed on a win 2003 server, SQL 2000, Reporting Services, sharepoint services and Business Scorecard Manager. After i installed Rpt Services, the url would not work After much ferreting around i made the adjustments as suggested on msdn to make Sarepoint Services and Reporting Services exist side-by-side. After i applies these changes, the url <servername>/Reports works but the <servername>/Reportserver doesnt just comes up in a blank page with the url in font 20. On sharepoint the controls are now rendering from the scorecard manager. Can anyone help please Thanks ...Show All

• Visual Basic How can i make e-mail mask

  How can i make e-mail mask Please help me I need a mask or some one tell me how to make one thanks you could use a maskedtextbox: http://msdn2.microsoft.com/en-us/library/system.windows.forms.maskedtextbox.aspx http://msdn2.microsoft.com/en-us/library/kkx4h3az.aspx to create your email address style/field/column data input you could also use this regex (regular expression) to validate the inputs and check to see if it is a valid email address, if not, then prompt them to enter a correct email address (there are many variations, im no regex guru but this one works reasonably well): private function ValidateEmail(byval emailAddress as String) as Boolean Dim theRegexValidator as new Regex("^([a-zA-Z0 ...Show All

• SQL Server Accessing the Current Transaction in BOL (April 05')

  Here is the text I do not believe is correct or at the least misleading... "If you want to terminate the external transaction from within your stored procedure or function. In this case, you call the Transaction.Current.Rollback method. " You cannot terminate transactions declared in TSQL in SQLCLR routines. Derek- Thank you for pointing out this. We will work to update this BOL article! It is possible to terminate transactions declared within TSQL within SQLCLR routines, but it is recommended to manipulate them through the use of System.Transactions.TransactionScope. For example, this would rollback the current transaction: using(TransactionScope transactionScope = new Transacti ...Show All

• SQL Server Install SP2 for Sql 2005 in Active\Passive Cluster

  Do I have install sp2 on each node in the cluster or do I just need to install it on the active node and reboot Do I need to pause the active node I was looking for some documentation for this and didn't mention anything regarding pausing the active node in the cluster in order to apply the sp2 for sql 2005. The readme mentions to install it on the primary node and not to stop any services. I just completed a cluster upgrade (RTM to SP2). Just had to run it on the primary node and everything just worked (apart from BackupExec breaking the Database Engine install :)). Rebooted, and everything looks good. (Of course I'm not saying it'll work for you, but it did work for me just fine.) ...Show All

• .NET Development Version 2.0 is not a compatible version

  I seemed to have a basic misunderstanding about the compatibility of .NET releases. I was under the impression that one could develop .NET dlls under any version, and they would be compatible with all .NET versions. In particular, if you only used classes, members, etc that were included in that .NET dll, you would be safe. I guess this is not true. .NET dlls are not like the Win32Api dlls! I tried to use a .NET dll that was developed under .NET V2.0.50727. I was trying to use this dll with the Lahey V7.1 compiler which is stuck at V1.1.4322. This is not restricted to the Lahey V7.1 compiler though. C# also shows the same problem. You cannot use a V2.0 dll with a V1.1.4322 C# development. Is this true Can you shed some light on why this is ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Textured Quads - No Need?

  Hello everyone... In my '2D in 3D' engine using MDX, I went the "Textured Quad" route. But after looking at the XNA Framework, I am wondering if there is any reason to go that way Should I use the built in SpriteBatch class Thanks! -Nick Probably yes.... It really depends on if you want to do anything that the sprite batch doesn't let you do. But under the covers spritebatchis doing exactly the same as you are and the code is likely simpler. ...Show All

• SQL Server Where to install SRSS DB?

  We're planning to use one instance of SSRS installed for all of our clients. What performance differences could we get when deploying SQL Server DB for SSRS according to the following 2 scenarios 1. On the same server box 2. On another server box Unless you have complex queries, the database is rarely a bottleneck. I will suggest you conduct a peformance study (see http://www.microsoft.com/technet/prodtechnol/sql/2005/pspsqlrs.mspx ) before you decide. ...Show All

• Visual Studio Express Editions What are requirement to run application console on a computer?

  I want to know, what kinds of computers can run any programs that visual express C ++2005 made This is not a rigorous statement, but I trust it gives you the general idea. Basically, Windows Win32 is required: If you mean command-line applications, you can make applications that run under the console shell of any 32-bit Intel-compatible PC running Microsoft Windows and accepting Win32 applications. You can make them using C Language or Standard C++ Language and libraries. You cannot make 64-bit applications, but you can make 32-bit applications that run on 64-bit processors that provide 32-bit compatibility. The Express Edition programs and libraries depend on the presence of Microsoft WIndows and ...Show All

• Software Development for Windows Vista recommend way to do IPC between app and service

  Hi guys, until now I've used (unnamed) Pipes to communicate between apps and services. For that to work I used OpenProcess(serviceProcessHandle, PROCESS_DUP_HANDLE), so that I can duplicate the pipe handle from the service to the app. This still works in Vista with UAP turned off - even from a guest account. But as soon as I turn UAP on, OpenProcess fails with "access denied" - even in elevated mode. I guess that's intended So since my old IPC method doesn't work now, anymore, I'd like to know which IPC method Microsoft now recommends to be used for communication between apps and services. Thanks! Thanks, I'll look into this. Last time I checked out named pipes I didn't like them at all for wha ...Show All

• Visual Studio Team System Validate Console.Write Console.WriteLine

  Hello, I need to develop a rule to identify Console.Write and Console.WriteLine calls. It is because sometimes developers use this instructions to help trace some execution, but forget to delete it, and it goes to production. Please give any ideas to develop this rule for FxCop 1.32 Thanks in advance. Carlos Figueroa See a sample rule available for download which does exactly what you want (you only have to change the methods that should be detected). ...Show All

• Smart Device Development .Net compact framework is not working on my O2 mini.

  .Net compact framework is not working on my O2 mini. I had tried installing .net compact framework version 2. and 2sp1 but both were having error on my phone. It shows "installation error. Stop all applications and process bla bla bla.to maximize storage space." Hey,but i had 20 Mb of free space left out to install the framework. somebody please help me.I just bought a software for my O2mini which requires .net compact framework. thank you for your help. I think i have to do a hard reset because i have Downloaded so many version of .Net compact. Once again,thank you! ...Show All

• Visual Studio Tools for Office Working with submenus in Outlook 2003

  how to Create Command Meun with two childs there is what i need Send By: -email -SMS msdn was not clear for me and it was creating menu bar . and what i need is a command menu. t You need to add a CommandBarPopup control to the COmmandBar and then populate the CommandBarPopup.Controls collection with CommandBarButton items. ...Show All