Ehab EL_Gendy's Q&A profile

• SQL Server SELECT How to... - another crazy join?

  Hi All... Consider the following tables: TroubleTicketLog Date Event New Value 1/1 chg status 1 1/2 chn admin 1 1/3 chg status 2 Status Id Text 1 Submitted 2 In Progress 3 Closed Administrators Id Text 1 Bob 2 Bill I want to populate a dot net grid view and need to get the appropriate text for the New Value column, but which table I use is dependent on the value of Event. I've wrestled with inner joins till i'm blue in the face... Any thoughts Much thanks! -- Curt select t.date, t.Event, coalesce(s.[text],a.[text]) as [text] from TroubleTicketLog t left outer join Status s on s.id=t.[new value] and t.event ...Show All

• Commerce Server Trouble verifying services

  I have followed all of the steps in the online installation guide, and restarted IIS. I have also verified that a folder was created for each web service (\Intepub\wwwroot\siteCatalogWebService; Intepub\wwwroot\siteMarketingWebService; Intepub\wwwroot\siteOrdersWebService; Intepub\wwwroot\siteProfilesWebService). Then the guide says to visit the web page for each service (point browser to http://localhost/siteCatalogWebService/CatalogWebService.asmx ). I get a web page showing the methods of the service for the Catalog and Profile services, but when I point to the Marketing or Orders page I get an error saying: Configuration Error Description: An error occurred during the processing of a configuration file required to service ...Show All

• Windows Live Developer Forums Plot Multiple Trips on one map

  Hi there, Furthering my saga, I need to offer driving instructions starting at A, going to B, then, going to C, then, going to D... GetRoute seems to only offer point A to B, and will delete the instructions from A to B when I request B to C, Right Any ideas on how I could accomplish this Thanks, se ...Show All

• SQL Server SQL Server Setup Unicode

  I have data feeds from multiple geographic locations including Switzerland, Germany and US. I would like to store the data in SQL Server 2005 but am confused whether I should store data in columns of type NCHAR, NVARCHAR, NTEXT. If I choose Unicode data types, should I also setup a different collation setting for SQL Server. Our Windows default langauge is US English. Thanks The only way to store unicode data is in nchar, nvarchar(max). -(Do not use ntext -ntext is on the 'official' deprecation list.) Collation effects sorting. You can set different collations at the column level where necessary. ...Show All

• Visual C++ Which One(Managed C++ or Native C++)

  Hi everybody i am starting a new project and i ma in doubt about my programming language, should i use native c++ managed c++. i should use following thing in my project: wlan communication. direct input. direct show ( previewing) direct sound (capture wave) using usb. so know please tell me which one give me more freedom to do my project. I agree with alex, if at all possible use C# for gui, ect. using any form of C++ to make a GUI when you have C# avalable is like walking up a mountain when you could just take a bus, CLI is a great bridge between native C++ and C# ...Show All

• SQL Server Excel as Frontend to SSAS 2005 Cube

  Hi, there, I am working on Excel as a front-end to a SSAS2005 cube. I intended to create a simple add-in that allows users to write back to the cube. Users will first retrieve data from the cube to pivot table and write back to the cube from the pivot table. I can find some sample source based on adodb and AS2000 but not adomd .net and SSAS2005. For the time being, information on SSAS2005 write-back from Excel seems very little. Not much references that I can refer to. Anyone can shed some light on this I would appreciate it if you can provide me some sample source in VBA using adomd .net or others that can demonstrate the write-back to a SSAS2005 cube. It would be great if the sample will be based on the AdventureWorksDW cube. Th ...Show All

• Community Chat IE 6 problem

  I have installed IE 6 ( xpsp_sp2_gdr.050301-1519 ) and do not obtain to load paginas that need flash to player. I have the flash to player 9 installed. Also I can not install IE 7. Any help, I am thankful This is not the right place for IE support, start looking there : http://support.microsoft.com/ph/2073 ...Show All

• SQL Server Copy data in Sql Server table A to B on same server - Identical schemas

  Greetings, I have two SQL Server tables on the same server and in the same database. I'll call them table A and table B. They have identical schemas. I need to insert all rows in table A into table B. (Don't laugh - this is just for testing and long run the tables will reside on different servers.) Can someone please tell me the correct task to use for this and the connection type I need for both the source and destination Thanks, Black Cat Bone Create an OLE DB Source and perform your data select within that. Then simply attach it to an OLE DB Destination, where you select your destination table. Easy and it will allow you to change your destination later when you move TABLE B to another ser ...Show All

• Visual C++ different number of errors after building and rebuilding

  hello, i have just started using vc8 and have migrated a bunch of code from vc6. i am new to vc++ in general. i was wondering if anyone could explain what exactly happens with my code when i build as opposed to when i rebuild the code bcos i get a different number of errors each time i build then rebuild and vice versa. thanks in advance. I'm a bit prone to novels - but I'll try and keep this brief, sorry! Firstly, it depends on whether you've got minimal rebuild on. Fire up VS2005 MSDN and filter by Visual C++, then type minimal rebuild into the index box. With it switched off, there's pratically no difference, except the rebuild option will clean your output directory for the project before ...Show All

• Visual Studio Team System Accessing test results

  Hi, all. This is probably a pretty basic question. I've looked for answers to it on this forum but can't find exactly what I need. How can I access the results of my load test run after I've closed and reopened my VS solution In other words, let's say I run a load test. When it's done I can see the results of this test. However, once I close the solution and reopen it I don't see any way to get that result window back. From what I've read, it sounds like the results get saved into the test repository (I might be wrong) and I believe there should be a way to access them. I just can't find how. Thank you. Never mind my question. If anybody is interested the answer is at http://msdn2.microsoft.c ...Show All

• SQL Server Can I setup a Global Public View in SQL Server ?

  I need a master view that gets data from different DBs located on the same SQL Server (similar with Oracle feature that allows to get data from different schemas). Is it possible to create such a view Thanks Yes you can do it: Create view my_view as select * from database1.schema3.table3 join database2.schema5.table6 on .... union database3.schema5.table8 Keep in mind that if you are going to grant select privileges on this view to a specific user/role, you must grant same privileges on all underlyeing tables. To make things simpler you can also create synonyms to that tables, like in Oracle, but you have to qualify whem with database names. ...Show All

• Visual Studio Express Editions 'min' or 'max' function

  Hello all of you, I use the min() and max() functions. If I compile the program, no compilation error (as expected), but if I right click on the 'min' or 'max' and then ask 'Go To Declaration' or 'Go To Definition', I get the error "The symbol 'min; is not defined". Why is this All the best, Victor Hello Intuition, If I compile a program is the program then not fully build I would think yes. But to be honest, I tried do build and compile and after that (while debugging) still getting the same effect. All thebest, Victor ...Show All

• .NET Development How to get a file stored in an Access database?

  I am building a small application in Access 2003. What I want to do is to send mail automatically. What I not know how to do (and I haven’t found any examples) is how to attach a word file that I have stored in the database With line below am I able to attach a file stored on disk: myAttachments.Add "E:\Documents and Settings\Kaj\Mina dokument\CV Kaj En.doc" How do I attach a file stored in the table “E-post”, column “Fil” (The format of the column is “ActiveX-object”.) Thanks, Kaj Example: Public Sub ListNames() Dim rst As ADODB.Recordset Dim objOLApp As Outlook.Application Dim NewMail As Outlook.MailItem Set rst = New ADODB.Recordset S ...Show All

• Visual Studio Team System So much technology for so little results

  The Team Foundation server is simply a source control database with simply check in and checks out, and a set of windows forms or bug tracking, all connected to a share point database. But to install that thing, you need a dedicated server (yes, share point cannot be shared, only the mighty Team Foundation server is allowed to configure it and use it), then the SQL Server 2005 with its full options, then ……. So, an entire computer is required, just to get a set of simple functions, that cannot be even used from the web directly (yes the business analyst must have visual studio 2005 installed in order for him to file a bug), or download a third party tool. So the question is, do you have any future plans to allow th ...Show All

• SQL Server Organizing graph lines with Series group

  I have a report that has to show historical values from 1990 to present. I need to show a line for each year but have them grouped as Current Year, Previous Year and 1990 to 2004. I have my data organized so that it shows Group, Year, TimeStamp, Value. My problem is that the lines show up on the graph properly but I want my lines to be the same within the groups. So for 2006 I would have a thick blue line, 2005 I would have a thick red line and for years 1990-2004 I would have thin black lines. Right now it gives me a different colored line for each year. When I add my series to the series group, I get a value for each year in my legend when I only want the Group names. Does anybody know where I can find a re ...Show All