Rasmus Helwigh's Q&A profile

• SQL Server WHERE Clause overwriting SubQuery restrictions

  Hi, I've been experimenting with subqueries in Analysis Services 2005 and have discovered some strange interactions between subqueries and the WHERE clause for an outer query. To start with, it seems that if the subquery SELECT just picks a single member from a hierarchy, and I also choose a different member from the same level in the outer WHERE, then the member from the outer WHERE sort of "overwrites" the restriction. This query: select from [Adventure Works] where [Sales Territory].[Sales Territory].[Sales Territory Group].&[North America] returns the same value as this query: select from ( select {[Sales Territory].[Sales Territory].[Sales Territory Group].&[Europe]} on 0 from [Adventure Works] ) whe ...Show All

• SQL Server SSIS & Temporary Tables

  Hi - I have been trying to work with a data flow task that uses temporary tables on the remote DB. I have seen Jamie Thompson's SSIS Temporary table guide, available here: http://blogs.conchango.com/jamiethomson/archive/2006/11/19/SSIS_3A00_-Using-temporary-tables.aspx, and successuflly got his download package working against my AdventureWorksDB. I cannot get a temporary table implementation working in my SSIS package despite following JT instructions. Current status: Marked the OLEDB connection as retainsameconnection = true Created a seperate execute sql task in control flow that creates the temporary table '#BUSessions' A data flow task follows the execute sql task, the ole db source is marked a delayvalidation ...Show All

• Gadgets Problems with two transparent background-images

  I am currently trying to get a new gadget working but there is still one problem left. In my gadget I am using a transparent png-file as the gadget's background. In the content area I placed a <div> also using a png-file with transparency. In those parts of the gadget where the two transparent areas are overlapping, I get a pink border. Is there any solution for this issue Thanks for your help! I am having the same problem and although changing the dimension of the gadget might help you would still see some pink/purple pixels if you have rounded cornes on you background image. In my case I have 3 images for background a top image, a middle image and a bottom image. Top and bottom are fix ...Show All

• .NET Development execute stored procedure on only selected rows

  using inventorytableadapter.updateQuery1("itemno") I'm able to subtract Invoicedetails "Qty" from Inventory "Instock" but I need to add a where clause to this query so that only the selected rows are updated here's my query UPDATE Inventory SET InStock = Inventory.InStock - InvoiceDetails.QTY FROM Inventory INNER JOIN InvoiceDetails ON Inventory.ItemNo = InvoiceDetails.ItemNumber; where ( Itemno=@Itemno ) SELECT ItemNo, ItemDescription, InStock, Units, Cost, ItemID FROM Inventory WHERE (Itemno = @Itemno) Any Ideas Hi, The letter “x” is were you have put the column index of the column you want. Dim Ite ...Show All

• Windows Forms Setting the DataGridView columns

  Hi friends, I have many datagrids in my application. So wat i want to do is to have a common grid which takes care of setting all the styles and the required columns and their widths,dynamically. I have taken a separate class which takes care of the styles,but i want to have a generic method in that class that sets the column names and their widths respetively.How do i approach this problem . Any links would be of great help. Thanx in advance, subhanet Its not clear to me what you are aiming for. I suppose that you can create your own class of data grid inheriting from the DataGrid class (unless the class is sealed), and then set the properties you want in the class's contructor. But that wi ...Show All

• Visual Studio 2008 (Pre-release) Getting an error for setting UserNamePassword Token setting for WCF Service on IIS usin basicHTTPBinding.

  I am getting the following error when I browse the Service.SVC file: Could not find a base address that matches scheme https for the endpoint with binding BasicHttpBinding. Registered base address schemes are [http]. I have done following step, can you please tell me what am I missing 1. I created a seperate website on IIS with port 90. 2. I ran the following command to install the SSL certificate. C:\Program Files\Support Tools>httpcfg set ssl -I 0.0.0.0:90 -h a586fc83bd30d288 d2c08067c03ca51258c94e32 HttpSetServiceConfiguration completed with 0. C:\Program Files\Support Tools>httpcfg query ssl localhost:80 IP : 0.0.0.0:90 Hash : a586fc83bd30d288d2c08067c03ca51258c94e32 ...Show All

• SQL Server Install path SQL Enterprise Manager

  Hi, We want to install SQL Enterprise Manager on a seperate server. Our provider for this server requires us to install SQL EM on a non-default drive/path, d:\programs. How can I achieve this TIA, Wim Looks like this works for 2005. However we want to use 2000. My mistake, should have mentioned this. We already looked quite extensively on the CD but could not find any clues for resolving this. Does anyone have an idea It could be that Enterprise Manager 2000 is not meant to be installed seperately from SQL Server 2000. Can anyone say anything about this TIA, Wim. ...Show All

• SQL Server How to get nextcounter for each row via a stored procedure and use it in insert into clause for each row

  Insert into TestJobTable (BookNumber,BookCode,IsActive,SourceId,ContactNumber) select [exec getnextBooknumber 'Book'],BookCode,'1', @SourceId ,[exec getnextBooknumber 'contact'] from TestBookTableTemp where SourceId = @SourceId and BookCode not in ( select BookCode from TestBookTable where SourceId = @SourceId ) Here i have to select records from the temprory table and insert it into actual table. During insertion I have to execute stored procedure for two columns and get counter for that coumlumn for each row. What can i do Can any body please give me a solution of my problem even by using cursor you have to change your SP getnextBooknumber logic into User Defined Function.. after you changed the logic into ...Show All

• Audio and Video Development How can i get overlay surface?

  now i want to write a driver that can save a playing video frame to a bmp file, i konw the video use the overlay surface to play ,but i don't kown how to find the overlay surface in display memory, i supposed if i find the address and lenght of the playing video overlay surface,that i can copy it to a alloced memory and finally save it,is this right what the driver should do does mirror driver can do it i hope someone can help me,thanks!!!!!!! wating on-line! Two questions before we start trying to answer your question: Is this really a Media Foundation question Media Foundation is the new multimedia platform for Windows Vista. If you need your code to run on pre-Vista OSes, then you'll want to use DirectShow i ...Show All

• SQL Server How to change default installation path for SQLCE

  Hello, My WinCE device loads the \Windows folder from NAND falsh on start-up and therefore I cannot install SQL into Windows\Program files. I would like to deploy SQLCE apps and dlls (from VS2005 or CAB file) into my NAND_Flash directory but I don't know how to do it. Thx, Uri To expand on what Laxmi has stated - the second option for deployment of SQL CE is simply to include the runtime dlls with your application. In fact VS2005 supports creating deployment CABs so you can just include the dlls with your application CAB file. The dlls are located at C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\bin\<winceversion>\<processor>. ...Show All

• Visual Basic UserControl in StatusStrip

  Hoping someone can help me figure out how to add a Usercontrol into StatusStrip. There seems no obvious way in which to add any controls other than the default ones allowed through the Items Collection Editor. Hi, the key here is to use the ToolStripHost class , which would host your user control. This MSDN's How To article will guide you through the process of generating a wrapper around your control, allowing you to put in on your status strip. Andrej ...Show All

• .NET Development Third Party Unsigned Dlls

  Hi all, I created an application with shared assemblies. Now,I need to make the application to integrate with a third party device.The dlls provided with the device by the vendor are unsigned. Hence,when I refer those dlls in my application, my application fails in compile time. I tried so many ways , but yet to get through it. Please provide your suggestions. Thanks.. Hi, As the previous post says you shouldn't release it but at the end is the vendor's responsability. If you need to compile your project for commercial reasons you can alter the assembly.cs file, adding the following line: using System.Security; [assembly:AllowPartiallyTrustedCallers] This will allow you to sign your component with unsigned ...Show All

• SQL Server rsCredentialsNotSpecified

  Hello guys, I have a report using a drilldown to expand/collapse some information: Region + SE State On preview mode, the report works right, appearing this: Region - SE State SP Campinas When I call this report from a asp.net page, the report works fine, but when I expand this drilldown, the report shows an error: One or more datasource credentials required to run the report have not been specified. (rsCredentialsNotSpecified). I use a shared dataSet using prompt Credentials as its credentials. Pedro ...Show All

• Visual C# how do we implment multiple inheritence in c# pls

  Thanks C# does not support multiple inheritance. Using multiple interfaces is only a way to mimick multiple inheritance. So actually you can't at this time. The trick is to split your code allowing it to be more object oriented. One class inherits the base and the naext inherits it. Hope this well helpful. Craig Maslowski MCT ...Show All

• Windows Forms Maximum number of controls on a form

  Is there a maximum as to the number of controls that can be on a form I have a tab control on a form with seven tabs and at least 50 textboxes on each tab and the IDE seems to have trouble handling it. Thanks, cj Well, although it is discussed before, I'd like to make some summary since the thread looks out of order. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=770632&SiteID=1 I think there IS a limit on the maximum number of the controls because the system has the a limit number for GDI handlers. This value is stored in registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\Current Version\Windows\GDIProcessHandleQuota DONT change this registry value greater than 16, ...Show All