Anudeep_Chappa_2dc7df's Q&A profile

• SQL Server Measure Dimension

  Hi What's the difference between the two following queries as the returne value of the second one is "#Error" . My aim is to count the number of customers that purchased the mountain product through Internet. I've used the Adventure Works sample database. WITH MEMBER [Measures].[Number Of Mountain Internet Sale] AS DISTINCTCOUNT(EXISTS([Customer].[Customer].MEMBERS, [Product].[Product Line].Mountain, "Internet Sales" )) SELECT [Measures].[Number Of Mountain Internet Sale] ON COLUMNS FROM [Adventure Works] WITH MEMBER [Measures].[Number Of Mountain Internet Sale] AS DISTINCTCOUNT(EXISTS([Customer].[Customer].MEMBERS, [Product].[Product Line].Mountain, [Measures].[Internet Sales Amount] )) SELECT ...Show All

• Visual C# Unhandled exception only when running in release without debugger attached.

  I am beyond baffled by this. My application throws a System.AccessViolationException only when it is run in Release mode without the debugger attached (as in, I run the exe directly, outside of Visual Studio or I do "Start Without Debugging" in the Debug menu). Debug mode - everything works great; Release mode with debugger attached - everything works great. The very nature of how this error is thrown makes it impossible to debug, so I have no idea where to look into correcting it. Has anyone else ever come across such an error Does anyone have an idea how to hunt down such an error The application is not just a few hundred lines, it is easily on the upper end of tens of thousands of lines. I cannot seek it out with a debugger be ...Show All

• Visual C++ Incremental status error for DLL

  Hello, In trying to convert a dll from VC++ version 6.0 I encounter the following errors in trying to build it: 1) warning LNK4076: invalid incremental status file 2) fatal error LNK1181: cannot open input file "odbc32.lib" Can anyone explain this. Thanks. 1) Search for any *.ilk file in your build directory and deleted it. 2) This is a PSDK library. Are you using the Express Edition - if so have you installed the PSDK ...Show All

• Visual C# How to use a Progress Bar in my browser.

  Hi I am looking for codes for my progress bar that would be shown below my browser while loading the page. I would also like to know how to do the progress bar while downloading a certain file from the internet to the local machine. Thanks. AFAIK you need AJAX progress bar. MS MVP Sahil Malik has article about this here http://blah.winsmarts.com/2007-1-AJAX_Progress_Bar.aspx Hope this helps ...Show All

• Internet Explorer Development IE 6/7, restart computer on plugin update

  Hello. I noticed that after some Windows Update, IE6 (also 7), XP, asks to restart the computer after some plugin was sucessfully updated. The plugin is not in use at the moment when the webpage (that requires the plugin) is loaded. Do you know why And, most important, does anybody know a way how to avoid the restart Thank you. Cosmin There is no install program running. There is only one instance of iexplore.exe running. The sequence is the following: I update the plugin on the webserver and the javascript code that specifies the version. The client downloads the page and IE gets the latest version of the .cab file. And then it asks to restart the computer. One little thing is annoyin ...Show All

• Visual Studio Express Editions Failed to open connection dialog

  Hi, I installed SQL express on a computer yesterday, and when I try to open it today, I get an error that says Failed to open connection dialog - Could not load filer or assembly 'Microsoft.SqlServer.Express.ConnectionDlg' version 9.0.242.0 blbalbalba Strong nam validation failed. Hresult 0x8013141a. Can anyone help me with this I too have been having the same problem. Am using SSE ver. 9.0.3042.0, SSMSE ver 9.00.3042.00, and .NET framework 2.0.50727.42 running on Windows XP Pro 2002 Service Pack 2. Have tried numerous times uninstalling, wiping out the directories for SSE and .NET and reinstalling. ...Show All

• SQL Server How "WHERE" clause can be used in MDX query?

  Hi, I am writing MDX query to retrive a set of data based on selected range of date. I have written a MDX query but it is not filtering . My code: SELECT NON EMPTY { [Measures].[Fact Table Count] } ON COLUMNS, NON EMPTY topcount({ ([Date Time1].[Date Time1].[Date Time1].ALLMEMBERS ) } ,1000)DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( [Date Time1].[Date Time1].&[ 2006-01-25T05:53:07 ] : [Date Time1].[Date Time1].&[ 2006-02-25T15:53:56 ] ) ON COLUMNS FROM [Cube Analysis]) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS This code should display only data with selected range of date but it displaying all data. Can a ...Show All

• .NET Development Output Parameters - What am I doing wrong!!!!????

  Aaargh, I'm trying to run some simple code to call a stored proc and access the value of an output parameter. What am I doing wrong Thanks. Heres the code SqlConnection conn = new SqlConnection("connectionString"); conn.Open(); SqlCommand command = new SqlCommand("dbo.OutputParameter", conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@ID", SqlDbType.NVarChar); command.Parameters[0].Value = ""; command.Parameters[0].Direction = ParameterDirection.Output; command.ExecuteNonQuery(); Console.WriteLine(command.Parameters[0].Value.ToString()); Console.ReadLine(); HERE is the Stored Proc: CREATE PROCEDURE dbo.Ou ...Show All

• SQL Server SQL Server 2000 Query slowing down in SQL Server 2005

  Hi everybody, I have a query slower in SQL Server 2005 than in SQL Server 2000. I have a database in SQL 2000, I put it on the same server, but with SQL 2005 and the query take 5 seconds instead of 0 seconds. The DB compatibility is SQL Server 2000 (I tried with 2005 and result is the same). Execution plan seems right and I tried to change some DB options without results. It is weird, when I remove left join on MandatsEx, it take 2 seconds. The view currentEmployeeLevelHistoric returns 45 000 rows and mandatsex has 0 rows. Here is the sample: Select ls.EmployeNiveau.pk_EmployeNiveauID as NoNiveau, IsNull(nullif(ls.Traduction.Description, ''), ls.TraductionDefaut.Description) + ' (' + ls.currentLevelHIstoric.NoN ...Show All

• SQL Server SQL 2005 Server Agent won't start

  When I attempt to start the Server Agent Service, it tells me it started, but stopped immediately. When I check the log files for the agent, I get the following two entries: 2007-01-03 15:07:11 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2007-01-03 15:07:13 - [098] SQLServerAgent terminated (normally) This same error was posted inanother forum and I was directed here. The EventLog is running (I did an SC command) so I am lost. Help There is no service listed on the sevices page called eventlog.  There is an Error Reporting service, but not an evetlog.  I do see an event log running when I do an "SC Query Eventlog" ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DrawableGameComponent.GraphicsDevice

  I added a class I called Quad, that I hope to use as a rectangle. I butchered the code used to draw the cube and I inherited from DrawableGameComponent in order to make use of the GraphicsDevice property to do the drawing. Any reference to the property throws an "Object reference not set" exception. Any help just a guess, but I think Initialize is not the right place to add your object to the Components list. I'm not at work so I can't be sure, but my guess is that your Initialize is never being called.  You can put a breakpoint in there to check. A better place to add an object to the Components list is in the game's constructor. ...Show All

• Visual Studio Team System Explanation of branching and normal workflow

  Can someone describe more about how branching works from a developers perspective Or is there already information about this somewhere that I haven't found This would be very useful for us coming from ClearCase / Subversion / some other version control system. What I really would like to see is an article or blogpost about how two developers working with a project/solution would do to create a branch, let one developer use this branch for a few days while the other is continuing on the normal main branch. After a few days a merge should be done. I would like to see the steps necessary together with an explanation why this is the best way to do it if there is more than one way. Suggested outline: - Assume both developers has thei ...Show All

• Windows Forms Setup file deployment question.

  Hi, I have created a setup package for my VB.Net application which runs fine, however what I would like to do is: - As part of the setup package I would also like it to copy the Setup and MSI file (itself basically) to the application folder where-ever it is installed. Can anybody tell me how to do it and what I need to do to the setup package to achieve this. Best Regards Russ Thanks - yes your right about it not being able to add the files to the project output because it is busy compiling them. I did as you suggested and it works fine. I have to build the setup project then copy the setup files into my application folder - add those files to the setup application and then re-compile ...Show All

• .NET Development Regular Expression: Help on creating appropriate expression needed...

  Hi there! I'm now trying since hours to construct an appropriate regex that will fit my needs. Here is the starting situation: I've got a string like "abc F123[F456[F789]] 123" In this string I want to find the following expressions: - F123[F456[F789]] - F456[F789] - F789 An expression is defined as follows: - starting with an 'F' - followed by min. one digit - optional followed by an expression enclosed in brackets '[...]' which also may (recursively) include this kind of expressions I'm searching for. I tried this by using the following regex: [F][0-9]+[\[]{1,}.* [\]]{1,}|[F][0-9]+ But the expression only finds the first needed match ( F123[F456[F789]] ). What do I have to do to find also the other needed matches (recursicely) G ...Show All

• Visual Studio Express Editions Runtime error "Abnomral program termination"

  Last night I put my laptop (Windows XP Pro) into hibernation. This morning it loaded up just fine, but I can not print from Internet Explorer. If I try to print, I get a Runtime Error noted "Abnormal program termination" which shuts Explorer down, returning me to the desktop. I can load Explorer up again and it seems to run fine, until I try to print anything, when it happens again. This is a real problem, as research on the internet is a major part of my job. I tried downloading and upgrading to IE 7, but it did no good. Any ideas Dave This isn't a problem for programmers, this shows that there is a bug or another problem of that kind in internet explorer. You could try a repair install for windows but other than tha ...Show All