Ritesh305's Q&A profile

• SQL Server Help with SQL

  I have a table named "policy_details" having four columns called policy_details(varchar),effectdate(datetime),Historyid(int) and policy_status(varchar). I want to keep only the maximum historyid records in "policy_details" where policy_details and effectdate should be equal and policy_status should be '30240084' . I want to delete the remaining records where policy_details and effectdate should be equal and policy_status should be '30240084'. Cheers Praveen Can you explain what the query is trying to do in english rather than trying to decode your criteria. The potential query may differ depending the nature of the data in your table e.g. uniqueness and nullability of t ...Show All

• .NET Development Profiling and inlining

  Does anyone know of a profiler which will allow me to analyze the performance of jit'ed assemblies taking into account optimization like inlining I've tried the profiler built in to Visual Studio 2005 and I've tried IBM Rational's Quantify. Both of them seem to somehow cause the JIT not to do inlining (it probably doesn't do any optimizations). Consequently when I look over the results and try to identify bottlenecks (in a rather complex and long-running algorithm), the results from both tools are completely skewed by the fact that a few small accessor functions, which are called very frequently are not inlined. Right now I'm left with temporarily manually inlining these functions just for the sake of running the profiler, and th ...Show All

• Software Development for Windows Vista 2 or 3 Monitors in Vista Ultimate/AERO: follow up quest for Mr. Vinny Pasceri please, thx!

  "Unfortunately we were unable to deliver this experience for Vista. The DPI value is per-system, not per-monitor or per-user. We hope to improve this experience in a future release. Thanks, Vinny Pasceri Aero program manager" Dear Mr. Pasceri, thank you for your response to another forum member. my situation is somewhat different. currently i have 2 monitors (24" Dell 16:10 2405 and 21.3" Samsung 4:3 Model 213T) with XP and it's been working fine for several years. i'm in the process of purchasing a new PC with Vista Ultimate and a new 30" Dell 16:10 monitor, to be used in addition to my existing 2 monitors for a total of 3 monitors. My goal is to use all 3 monitors, but at the very least, use the 30" ...Show All

• Visual Studio 2008 (Pre-release) Using ResourceDictionary and DyanmicResource (Newbie)

  Hi, Having a problem getting a Basic Style to loaded using a DyanmicResource . This is a snip of my code Login.xaml < Window x:Class = " PGBuilder.Login " xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x = " http://schemas.microsoft.com/winfx/2006/xaml " Title = " Please Login to " Height = " 220 " Width = " 400 " Initialized = " Init " > < Viewbox Stretch = " Uniform " > < Grid > < Grid.ColumnDefinitions > < ColumnDefinition Width = " 20 " /> < ColumnDefinition Width = " Auto " /> < ColumnDefin ...Show All

• Software Development for Windows Vista Task Scheduler

  I have a problem using the task scheduler from an application in Vista(RC1). I'm able to get the task scheduler object but when I try to activate the specific task I get 0x80070005 (access violation) the code to where the application fails is included below. Does anyone have any idea why this doesn't work in Vista (Works just fine on 2000/XP) Also note! This application is complied ti a Control Panel applet (cpl-file) Code extract:       HRESULT hr        = ERROR_SUCCESS;    bool bReturn      = false ;    HRESULT phrStatus;    ITask *pITask;    LPCWSTR lpcwszTaskName;      // Initiali ...Show All

• Visual Studio 2008 (Pre-release) Flattening hierarchical data

  Hello, I'm trying to work with some hierarchical data, but I can't find a way to bind to it in a flattened way. For example, using the HierarchicalDataTemplate example project, it shows how to do a Menu, and a Treeview, but how about just a plain ListBox I would like to be able to display a list of all the teams (in all the divisions of all the leagues) in a list box. Of course I could just create a flattened list in code by traversing over the data myself, but then this would not be bound, so would not update when a team, division, or league were added or removed). I was hoping for something like Path=Divisions/Teams, but that only seems to take teams from the first division. Thanks in advance, Alex Did ...Show All

• Visual C# Enum in generic class

  Assume the following code: Public class A<T> { public enum B { Alpha, Beta, } } A.B MyEnum1 = A.B.Alpha; //Won’t work A<int>.B MyEnum2 = A<int>.B.Alpha; //Works, but the enum shouldn’t depend on the type, right Why is it that, when accessing the enum, I have to specify the class's type The enum should, IMO, not depend on class A's type argument. To extend the question, is there (like in Java) some static subclass concept in .NET In Java if you declare a subclass static it has no dependencies on its parent class (it's still instance-able, not like static outer classes). ...Show All

• Visual Basic at least some form criteria is specified check

  I have a form created in Access that I have the user enter criteria into. I'm wondering if there's some simple VB code to check if the entire form is null, or do I have to keep using And operators to check if each field is null Thanks for any help. Hi, Is this Val Kipling from Teesside university Regards, S_DS ( P.S. If so this is one of your students, guess who ) ...Show All

• Visual Studio Express Editions SQL Query Not Re-Running And Updating It's Data

  Hello, I have a login form where you enter the username and password then the form runs a query which is as follows: User = UsernameTextBox.Text Pass = PasswordTextBox.Text Dim Booking As New System.Data.SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\Alex\My Documents\Visual Studio 2005\Projects\Ground Zero Booking System (TEST)\Ground Zero Booking System (TEST)\Booking.mdf;Integrated Security=True;User Instance=True") Dim cmd As New System.Data.SqlClient.SqlCommand Dim rowsAffected As Integer Booking.Open() cmd.CommandText = "SELECT Count(*) FROM AdminAccess WHERE [Username] = '" & User & "' AND [Password] = '" _ & Pass ...Show All

• SQL Server Check the SSIS FTP Connection String

  Hi, i have a table like No FileLocation UserName Password 1 ftp://sarvi3/test/ xyz xyz 2 ftp://pandit3/test/test1 abc abc 3 ftp://katta1/test/test2 klm klm i want to check the filelocation is valid (exist) or not,  Before transfering the file from the location. can anyone help me out to resolve thanks Sun ...Show All

• Visual Studio Team System Removing Project Alerts

  Hi, I have a question regarding project alerts. I have subscribed to events by using the UI in Visual Studio. Since then, my old computer has been reformatted and I have a new computer. When I try to look at my project alerts in the UI (Team->Project Alerts), the Send To fields are empty. I would like to remove the project alerts I have subscribed to. Is there any way to do this Regards What can you do if bissubscribe /unsubscribe does not work I have a couple of subscriptions that I am trying to remove, but am receiving an object reference error when I try to unsubscribe. Any suggestions ...Show All

• SQL Server Use Partial or No_Cache mode in Lookup task

  Hello, Can anyone explain to me (or show me where to get info) in what scenario should I use Full Cache, Partial, or No_Cache mode in the Lookup task I got below warning message during execute my package. I understand that my lookup data have duplicate reference keys. I want to change the mode to partial or no cache to see how it works, but don't know what to change for the parameter map. Warning : 0x802090E4 at Data Flow Task , Lookup [37] : The Lookup transformation encountered duplicate reference key values when caching reference data . The Lookup transformation found duplicate key values when caching metadata in PreExecute . This error occurs in Full Cache mode only . Either remove the duplicate key va ...Show All

• SQL Server Is it possible to install msde 2005 express on windows xp limited account?

  Hi, I would like to know is it possible to installing sql 2005 express edition on windows xp with limited account. I tried to install it. After installing, the service can not start. Is there any thing that I misconfigured Thanks for reading and answering my post. it depends what you mean by limited account. If you tried to install SQL Server 2005 Express on a guest account, im surprised it installed as guest accounts deny permission to install software what errors do you get when you try to run the service ...Show All

• Smart Device Development MessageBox loses focus on Smartphone and reboot is needed

  Hi everybody, I use ATL and Visual Studio 2005. I create an EDIT BOX like this: Along with all the other attributes like MB_YESNO, etc, add MB_SETFOREGROUND and/or MB_TOPMOST.   if (MessageBox(hWnd, _T("Do you want to exit the program "), _T("Exit the program "), MB_ICONWARNING | MB_YESNO | MB_APPLMODAL | MB_SETFOREGROUND) == IDYES) { //exit the game } ...Show All

• Software Development for Windows Vista SqlWorkflowPersistenceService putting wrong datainto InstanceState table

  Hi, If my system time is 2/1/2007 1.00 PM its putting 2/1/2007 5:30:09 PM into "modified" column. So whenever I try to reload this workflow instance it gives me error that this instance is owned by some one else Please suggest me the solution.... what could be the reason Thanks, Rahul Jain The time values stored in the database are UTC. If you get an ownership exception it generally means that either the workflow is currently loaded by a different workflow runtime or the lock that the current workflow runtime owns has timed out. Typically what we see when there are problems in this area is that the lock value is set very short (less than a minute). If this is the case try setting the value to 5-10 minutes ...Show All