Igor Antunes's Q&A profile
SQL Server Removing null values from a result set
Hi, I have following query which is returing null values along with other values. Could you please tell me how I can restrict to not to return null values SELECT [Measures].[Total Hours] ON 0, [Employee].[Hierarchy].[Employee Key]ON 1 FROM[Labor Metrics] Thanks, Prudhvi Prud, I'm assuming that you want to filter out TotalHours SELECT [Measures].[Total Hours] ON 0, [Employee].[Hierarchy].[Employee Key]ON 1 FROM[Labor Metrics] Where [Measures].[Total Hours] is not null Ham ...Show All
SQL Server DTS
I need to get a list of tables from a tabl, then loop through the table list and execute a stored proc feeding it the table name as a parameter... How could this best be done in DTS Jim JimDi wrote: I need to get a list of tables from a tabl, then loop through the table list and execute a stored proc feeding it the table name as a parameter... How could this best be done in DTS Jim I think this will help: Execute SQL Task into an object variable - Shred it with a Foreach loop ( http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx ) -Jamie ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Could we translate this soft to chinese？
The beta will be released tomorrow,it's a exciting moment!We wait this moment for a long time.... I am a member of "XNA Union Of China" ,and it's the first group of the XNA technology in china.It's no-commercial group,We have the same hobby,most of us are students. In order to extend the xna technology in china,Could we translate the XNA GSE( beta )to chinese？ we just want translate the tools of the xna,not the c#, we also don't publish it,we just share them to other chinese XNA fans. I wait your reply........ thanks EMAIL:yc_dc@126.com MSN: yc_dc@hotmail.com Anything you want to do with Microsoft Products, you must have the license from Microsoft. Or, you will be s ...Show All
Visual Studio Express Editions Is there a way to generate VSEE project from a make file based one?
Hi there! I am trying to move from my make file based project to the one in VC++ Express, but so far I was not able to do so. Is there a way to import it into the Studio and avoid manual addition of all files to the project Thanks! Fedja ...Show All
Windows Forms in a form i need to all the featurs of ms outlook
in my vb.net windows application on a windows form i need to keep all the featurs of the ms outlook can any one help me how to solve this problem can you explain further please You can't just implement the outlook features into your application, to do so you would probably have to create it yourself from scratch. It would help if you can explain more :-) ...Show All
Smart Device Development Combobox Value member foreach loop
How to build a combobox with a combobox ValueMember in a foreach loop I'm not entirely sure I understand what you're asking, but it seems like you want to add items to a comboBox using a foreach loop ( ). Was there a particular reason why you wanted to add them manually instead of using the DataSource property Anyways, if that is indeed what you're asking, it's pretty simple. Assuming a class called MyColor like this: public class MyColor { private string shortName; private string fullName; public MyColor(string strFullName, string strShortName) { this.shortName = strShortName; this.fullName = strFullName; } public string ShortName { get { ret ...Show All
Windows Live Developer Forums Windows Live Seach SOAP API & a search like:www.mysite.com
Hello, I'm using the SOAP API version, but instead of searching on the web, I need to only limit the scope to 1 site. Can you show me which paramater I have to use to make a search like site:www.microsoft.com by exemple. I can not find it in the documentation... I found it :) It's more simple that I thought. SearchRequest.Query = "site:www.mysite.com" & " " & strMySearchText So simple :) Nicolas ...Show All
.NET Development tcplistener and winxp service
i have a windows service that creates a tcplistener socket and waits for incoming connections. this service should allow connections before and after a user logs in and out, but it seems to not be working correctly. i keep getting this message, any ideas No connection could be made because the target machine actively refused it The windows service will be keep working in this case. The main thing is make sure that TcpListener keeps listening for incoming connections. You must accept connection after receiving some connection from client and after it disconnects. Many times we forget to call again accept method after some operation. The exception message you wrote says that your TcpListener is not ac ...Show All
SQL Server Email format for Reporting Services
Hi, this question is related to Reporting Services on SQL Server 2000. When creating a report and setting it to send via email as an attached excel spreadsheet, the email is in the format HTML. Does anyone know if it possible to default this format to something else like Rich Text. I have a feeling that this might involve a change to the RSEmailDPConfiguration within the RSReportServer.config file but am not sure which tag needs changing or adding. Any help/suggestions greatfully received. According to documentation: rsreportserver.config EmbeddedRenderFormats Specifies the rendering format used to encapsulate a report within the body of an e-mail message. Images within the report are subsequently embed ...Show All
Visual C++ Can you please help me
Hi I am trying to pass a object by reference with pointer into a function and using a method in that object. By seem to me it doesn't work. The object i want to pass is Game and in Game have a function vector <char> getPuzzle (); I pass game into the function bool guess (Game* game){ //do something here vector <char> p = game->getPuzzle(); //do something here too } it will compile but when i run it it come back with the error message This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. Can you please tell me is that the correct way of using it What should i do to avoid this kind ...Show All
Community Chat IT guru for Java.
James Gosling,and his project is now known as Java Originally called Oak by creator James Gosling, from the tree that stood outside his window, the programming team had to look for a substitute as there was no other language with the same name. Java was selected from a list of suggestions. It came from the name of the coffee that the programmers drank. ...Show All
SQL Server Getting rid of #temp tables without restarting SQL Service
If you create a #temp table on stored procedure #1 and then call another stored procedure #2 from #1; if stored procedure #2 has an error in it, the #temp table will not release even though stored procedure #1 has a drop table statement in it. Hi Steve, Can you elaborate on what you mean by "release" The temporary table should exist for the context of Procedure #1 until Procedure #1 is finished executing. The only time you might see the temp table is if you accidentally created it before executing procedure 1. You could include code in procedure #1 to drop the temporary table if it exists at the beginning of the procedure: IF OBJECT_ID('TEMPDB..#Test') IS NOT NULL BEGIN PRINT ' ...Show All
Visual Studio Tools for Office Get worksheet names from excel
Hi, On some excel file I get by schema the worksheet but on some I don't have this information. How can I access to this files Thank's Alexei Hi Alexei I don't undertsand your question, I'm afraid. But since you didn't originally post here, I'm assuming it's not directly VSTO related, so I'm going to pass you on to a group that specializes in EXCEL programming questions. When you post there (I can't move the message, you have to post again), you need to provide more information: - Version of Excel - A more descriptive explanation of the result you want to obtain, and what you're actually getting. Ask here: http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.excel.programming&lang=en&cr ...Show All
SQL Server Tutorial cube error:
Hi I am using SQL 2000 Analysis Services and going through the tutorial. Got to last stage of the 'Quick start' section where I want to browse my cube data I just get the error "Unable to browse the cube 'Sales'" Unspecified error. If I close AM and go back in and try then a seond error 'Unable to locate cube 'Sales' is also displayed. Everything in tutorial before that point went fine. Just can't get past this issue now. I only have one instance of SQL installed. Any help much appreciated. Rich Open SQL Server management studio connect to your Analysis Server and delete all databases you have. Re-deploy your AdventureWorks database and you should be able to continue with tuto ...Show All
.NET Development FtpWebResponse.getResponse SQUID PROXY TROUBLE
HI All! I'm going crazy. I've a simple application that needs to be connected to an FTP server. It works fine. My problem is this: System.ApplicationException: Unable to parse line: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " http://www.w3.org/TR/html4/loose.dtd "><!-- HTML listing generated by Squid 2.5.STABLE6 --><!-- Wed, 21 Feb 2007 08:09:10 GMT --><HTML><HEAD><TITLE>FTP Directory: ftp://myuser@myhosting.it@ftpdomain/ftpfolder /</TITLE><STYLE type="text/css"><!--BODY{background-color:#ffffff;font-family:verdana,sans-serif}--></STYLE><BASE HREF=" ftp://myuser%40myhosting.it:mypww@ftpdomain.it/area "&g ...Show All