debraj dhar's Q&A profile

• SQL Server KPI Trend depending on last 4 months

  Hi! I've created a KPI. My problem is on the creation of the MDX trend expression. I'd like trend to depend on last 4 months. I wrote this query which works fine in SQL Server Management Studio : WITH MEMBER [APPEL].[Hierarchy].[My4Months] AS Aggregate( lastperiods(4,[APPEL].[Hierarchy].[ANNEE APPEL].&[2006].&[02]) ) SELECT [APPEL].[Hierarchy].[My4Months] ON COLUMNS, KPIValue("Pourcentage de respect") ON ROWS FROM [Amon] I'd like to obtain the same result in SSAS. So i created a calaculation nammed My4Months with the expression : Aggregate(lastperiods(4,[APPEL].[Hierarchy].CurrentMember)) ...and I entered as trend expression : CASE WHEN (KPIValue("Pourcentage de respect"),[APPEL].[H ...Show All

• Visual C++ How to rebuild the C++ STL library for Visual Studio 2005?

  I have made some changes to (to solve C2248 basic_ios problem) the VC8 STL library. How do I rebuild the C++ STL for Visual Studio 2005 Hi Einaros, I am currently in Cape Town South Africa . I will contact Microsoft tomorrow, but my guess is that it will take a while to get it (things are a little slower in Africa …). Would it be possible for you to email ( devilspeak2004@yahoo.com ) the patch to me I would greatly appreciate it. ...Show All

• SQL Server Group By, Max(date) query problem

  Hello all: I have an invoice header and detail tables and a customer table using sqlserver 2005. The Detail invoice table has price and product id. The header has the date and customerID. I need to create a list of the most recent invoice date (and the product price) for each product for each customer. I can't use the group by because when I select both the max(date) and the price (as well as the productID and customerID which all have to be included in the group by) , I get more than one date per product per customer. I can only get the most recent date when I leave out the price and headerdetailID from the field selection. Any help would be appreciated. Here is sample data & results. invoiceHeadertable invheaderID ...Show All

• SQL Server How to output data to a new table

  Hi I run a SQL query to select a few colums of data using a select statement, I want the output to be stored in the new table which can be defined in the SQL statement how can I do it Your helpwill bw highly appreciated. Hi, SELECT * INTO NewTable FROM SomeSourceTable HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Saving Carriage Return in a nvarchar field (SQL Server 2005)

  Hi, As you can see, I'm totally new at Sql Server. I have a problem, I store text into a nvarchar field (could be a 200 or 20,000 characters long string), inside the text there are several carriage returns which I would like to preserve to later presentation, but when retreiving the data from sql server I got the "cr" as " ", also I opened the database from Sql Managment and all cr's were saved as " ". What can I do to preserve the cr inside each field Thanks in advance. Hi George, Sorry for the delay in responding - I've been off. If you're using vb, they where you would normally insert your VBCRLF (or is it Environment.Newline in vb too now ) you woul ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Debugging Content Pipeline

  I'm trying to debug the content pipeline. I don't have VS Professional, only the express edition. I searched the forum an found a link to a blog that tell to try this: System.Diagnostics.Debugger.Launch(); I put this line in my content processor code, but when I compile VS output an error saying: "No JIT debugger registered on the current machine" Surfing the web i noticed that VS Express does not support JIT debugging. So, am I wrong or I can't debug the content pipeline Also... i found in some source code of a custom processor this line of code: context.Logger.LogImportantMessage("Message"); What's the need of this declaration How could I use it waruwaru, he's talking about content pipeline stuff. I' ...Show All

• .NET Development Confirm dialog box on dropdownlist selected value changed

  Hi, I am using asp.net2.0. My problem is I need to display a dialogbox whenever the dropdownlist selected value changes. If user clicks ok then i need to display new value as selected value otherwise i need to display oldvalue. I am able to add attribute the dropdownlist onchange event with confirm javascript function, but i am not able to change the selected value depending on OK or Cancel button. Another problem is this dialog box is appearing if dropdownlist value changes bcos of some code(i.e if i select a checkbox, this dropdownlist value automatically goes to default value. Then this dialogbox is not appearing). Is there any i can solve these two problems Thanks for your help. H ...Show All

• Visual C# webclient and http status

  Is there any access to the http status ( 200, 404, etc) and the text (OK, notfound, etc) in the webclient.uploadstring() method if there is a webexception caught then all the failure information you need would be here. Forutnately this method does throw just that - the webexception. http://msdn2.microsoft.com/en-us/library/system.net.webexception.aspx http://msdn2.microsoft.com/en-us/library/system.net.webexception.status.aspx you would look at the status of the exception which has enum values of the webexception (WebExceptionStatus) does this help ...Show All

• .NET Development Visual Studio 2005 installation issue

  I uninstalled VS 2003 and VS 2005 due to framework conflicts and settings issues. Now, I am trying to install VS 2005 and getting this error - 'A trial edition is already installed on this computer. You must uninstall the previous trial before installing another trial'. I have uninstalled every bit related to Visual Studio and deleted all the related registry keys. Still unable to get through this issue ! Darn ! Any clue hi sathya, have u got resolution of the problem i also have got same problem and unable to install VS 2005 again... help me if u got some clue............. ...Show All

• Visual C++ Can I use POSIX threads in a atl STA project

  I have a library which uses pthreads inside of it. Can I use this library safely in a single threaded apartment project. If I can't what are my options . I want to use this library for building a com component. Thanks I think authors of pthread do not call CoInitialize(Ex) that means that you can call this fonction to make an appartment. For COM, it doesn't metter wich class wrapper works with thread. All of them direct or inderect call Win32 API CreateThread. Neveretheless, the pthread can use fibbers (it type of multitasking native for *nix). It means there is one thread realy all other fibbers works in the same thread. Like this: Thread 1 Fiber 1 Fiber 2 Fiber 2 In this case you c ...Show All

• SQL Server help with query syntax

  Hi all, I have been fighting with this query and would like some advice. Please consider the following tables; prod_table widget_number shift date production_time (in minutes) down_table rec_id (ident key) down_shift down_date down_minutes Prod_table (data) widget_number shift date production_time 0001 1 08/02/06 5.00 0002 1 08/02/06 10.00 0003 1 08/02/06 7.00 0004 2 08/02/06 5.00 0005 2 07/31/06 3.00 Down_table (data) rec_id down_shift down_date down_minutes 1 1 08/02/06 3.00 2 1 08/02/06 20.00 3 2 07/31/06 10.00 I would like to combine ...Show All

• Visual Studio Team System Connect 2 Team foundation server?

  HI, Is it possible to connect two Team foundation server together The scenario: Customer 1: Has a TFS on location A. This server is uses as backup server and sometimes to work. Customer 2: This is the main TFS. This server is daily used as the working server. This server is daily synchronized with the TFS from customer 1. The servers are in different domains. Is this scenario possible with the Team Foundation Server When yes, where I can find some informations about how to connect both server and synchronized it. Regards, Wojtek ...Show All

• SQL Server VS 2005 standard prevents using free SQL Express functionality?

  Hi, *relative newbie warning* I use Visual Studio Standard edition with the built-in version of SQL Server. Now I chose a new image catalogueing app, IDImager, that uses SQL Server Express to store photo info. The idea is that I can use the database also with my own code, or transfer the data to another app/database in the future if necessary. IDImager needs SQL Express with the 'connectivity components' installed using 'mixed mode'. This is their instruction page: http://www.idfoxx.com/support/idipro/install/ However, that option is not available in VS 2005 Standard and when I try to install these components with SQL Express I get the message that's not possible because VS 2005 restricts the install options. So far I gat ...Show All

• Visual C++ BuildAction Property in C++?

  I can not find the Build Action Property seen in C# on an XML file, in my C++/CLI project. I am converting a large C# control to C++/CLI. The author of the control seems to have embedded an xml file into the assembly. I need help in figuring out how to do this in C++/CLI. The property list of the file under C# is considerably different than the propery list uder C++. Among the missing is: "Build Action: Embedded Resource". Please refer me to documentation where I can learn how to embed an xml file as a C++ project resource. I'm guessing a bit because I haven't tried it but it looks like the Assembly Linker can embed a arbitrary file into an assembly. Run Al.exe with the /embed command line option as a postbuild step ...Show All

• Visual Studio DocumentEvents.DocumentOpened

  I opened the MyMacros project in the Macros IDE, opened the EnvironmentEvents module and looked at the code. The line... <System.ContextStaticAttribute()> Public WithEvents DocumentEvents As EnvDTE.DocumentEvents ...was not present so I added it just after the Module declaration as I had seen in the Sample macros. Next I used the dropdowns at the top to select the DocumentOpened event and just put the code... MsgBox("test") ... into the sub. Saved, closed the macros IDE then tried opening documents in Visual Studio. Nothing happens - the documents just open as usual and no message box is seen. Putting a breakpoint on the line in the macros IDE it never gets hit. Also even if I pick out the Window ...Show All