jzfredricks's Q&A profile

• SQL Server Trying to get daily totals from cumulative totals in a pivot

  I have been providing sales data for a few months now from a table that is set up like this: Date WorkDay GasSales EquipmentSales 9/1/2006 1 100.00 200.00 9/4/2006 2 50.00 45.00 etc. As can be seen, the data is daily, i.e., on the first workday of September we sold one hundred dollars in gas and two hundred dollars in equipment. On the second workday of September we sold fifty dollars in gas and forty-five dollars in equipment. Now, however, the data I have to pull from is cumulative. So, using the last table as an example it would look like this: Date_WorkDay_GasSales_EquipmentSales 9/1/2006 1 100.00 200.00 9/4/2006 2 150.00 245.00 etc. To make things more complicated, the powers that be wanted this data p ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Multiple Assemblies on the 360

  It seems like from what I've read that the 360 will support running an XNA game with multiple assemblies created with C# (in fact the Game Library Project that comes with Game Studio Express creates a DLL). My question is, can any of these assemblies be created with other managed languages such as Managed C++ and still run on the 360 I know it will work on the PC, but I don't know if it will work on the 360. Thanks. If the languages create pure IL code, this might work but is not officially supported. If they use any native interop, or features such as Reflection.Emit that are not supported on the Xbox CLR, it won't work. Specifically, Visual Basic and Managed C++ code will not ...Show All

• Smart Device Development No sqlserverce.dll file with Windows Mobile 5.0 Smart Device SDK

  Hi all, I have installed Windows Mobile 5.0 SDK for Smart Devices and Pocket PC but still don't have the SQLserverce.dll on my PC. Should this have come down with the install If not, then how am I suppsed to get hold of it Thanks It's not supposed to be in GAC on your desktop, it would be in GAC on device after SQL Mobile CAB is installed. SQL Mobile is not part of NETCF so this DLL can not be found in NETFC location you've mentioned. By default it should be here: "%ProgramFiles\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\" If you don't see it, try system wide file search. If that fails as well, you probably don't have SQL Mobile MSI installed - either it was removed or installation initi ...Show All

• SQL Server Max Timeout for a package

  How can I set a maximum time of executing for a package. I want my SSIS package to only run for 15 minutes. Where can I add this setting to ...Show All

• Visual Studio 2008 (Pre-release) ServiceContractGenerator.NamespaceMappings bug ?

  Hello, I am using the last June CTP. I have a simple service (generated by default from VS.NET for a WinFx web site) and I defined two namespace fot the data contract and service contract. On the client side I am generating the code for the contract: CodeCompileUnit ccu = new CodeCompileUnit (); ServiceContractGenerator gen = new ServiceContractGenerator (ccu); gen.Options = ServiceContractGenerationOptions .None; gen.NamespaceMappings.Add( "*" , "MyClrNamespace"); // Generate all types Collection < ContractDescription > contractDescriptions = this .ContractDescriptions; foreach ( ContractDescription contractDescription in contractDescriptions) gen.GenerateServiceContractType(contractDe ...Show All

• SQL Server Dynamically pick the source and destination tables

  I want to write a SSIS which picks up the source and destination tables at runtime is it possible. As we have a SSIS which is used to pull data from oracle but the source and destination table name changes. If the metadata changes (that is the column names change and/or data types) then you cannot do this without manually accounting for the differences. If the structures are the same, then you can build SQL statements to select against the appropriate table name. You can build the SQL in a variable expression. ...Show All

• .NET Development DllImport Issue

  I am currently trying to make use of a .dll file that was written in C++ in one of my vb.net 2005 applications. Initially I thought I could simply add the file as a Reference to my project, however, I found this didn't work because the .dll was not written with managed code. After a little research I found I could accomplish this task by using DllImport. I wrote the following code to test this: Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim InputRecords As New ArrayList Dim CmpltCheckFlag As Char Dim OutputRecords As New ArrayList Dim MessageRecords As New ArrayList Dim ReleaseList As New ArrayList CmpltCheckFlag = &q ...Show All

• Visual C++ bug in wingdi.h ?

  Hello, could someone verify this is bug : #define GetGValue(rgb) (LOBYTE(((WORD)(rgb)) >> 8)) Atleast for me it throws runtime-check-error when used. """ Run-Time Check Failure #1 - A cast to a smaller data type has caused a loss of data. If this was intentional, you should mask the source of the cast with the appropriate bitmask. For example: char c = (i & 0xFF); Changing the code in this way will not affect the quality of the resulting optimized code. """ Change to #define C_GetGValue(rgb) (LOBYTE(((WORD)(rgb&0xFFFF)) >> 8)) helps, so it seems like a small bug in headers to me. I wouldn't like to spam the Microsoft Connect with this th ough... Regards, Mar ...Show All

• Software Development for Windows Vista Error when saving the workflow in MS Office Sharepoint designer 12

  Hi, I am trying to design a simple workflow in MS Office SharePoint Designer(frontpage) 12 that will send a mail to user B on completion of the task by user A. But I am getting an error saying " Errors were found when compiling the workflow.The workflow files were saved but cannot be run ." In the detailed description of the error it says " Unexpected error on server associating the workflow" . I am not able to find where the workflow is getting saved also. Please let me know if anyone has faced such problems and the fix for it.I need to find an solution fast for this problem Thanks in advance. Mubeen The problem is probably related to a bad reference in the “ ...Show All

• Visual Studio Express Editions install published project C#

  visual C# 2005 express edition Everything works fine but when I publish the application I set the publisher as my name but when I click to install the application after publishing it the error window still pops up publisher unknown this does not stop the application from installing but is not very professional. Any ideas Thank You. In order for the "Unknown publisher" to go away, you will have to sign your application with a certificate. You can find some information about signing here: http://msdn2.microsoft.com/en-us/library/ms247066.aspx ...Show All

• Software Development for Windows Vista Setting Default Sound Device programmatically in Vista

  Hi, In my application I need to set programmatically the default sound device (playback device), on XP there is a way changing the HKEY_CURRENT_USER\Software\Microsoft\Multimedia\Sound Mapper\Playback value, but on Vista this isn't working. Using the new Core Audio API there is no way to change the default sound device, only to get it with GetDefaultAudioEndpoint() method from IMMDeviceEnumerator interface. I tried to fiigure out which keys/values are changed in the registry when I manually change the default device. Actually there are 3 binary values changed "Role:0", "Role:1" and "Role:2" under the following key: "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\MMDevices\A ...Show All

• SharePoint Products and Technologies Is there some particular if I set IsVolatile to ture Value?

  I don't know the different... [UdfMethod(IsVolatile = true)] public double MyDouble(double d) { return d * 9; } [UdfMethod] public double MyDouble(double d) { return d * 9; } any suggestion IsVolatile=true tells Excel Services that calling the method with the same parameters may yield different results. This in turn makes it possible for you to have methods that (usually) rely on external events or information and have Excel recalculate them. I will give you an example. Say you have a method that does currency conversions. It returns how many Israeli Shequels a Dollar is worth. Now, if the method was not marked as volatile, Excel Services would never bother to recalcul ...Show All

• SQL Server Cannot connect to localhost using Windows Security Group as login

  I have a test environment set up at home with a small windows server 2003 Active Directory domain. I created a windows security group on the dc and added myself and another user to the group. I then use this group as a login for SQL Server and add the login to the sysadmin server role. This works exactly as I would expect on the Windows Server computer (which is also the Domain Controller) regardless of which computer I use to connect to this Windows Server computer. However, when I set up the exact same login on the local sql server instance of my client laptop running windows xp pro, the I get an error message (Login failed for user MYDOMAIN\dgolds...) when I attempt to connect to the local instance of SQL server, even though I am able t ...Show All

• Visual Studio MSDN Download

  I downloaded the May 2006 MSDN (all three ISO's) a couple of weeks ago, and it seemed to install OK, I was under the impression that I would see a difference in VSE help/documentation, like the plethora of broken links etc would go away, and it wouldn't crash when I just down VSE - but alas nothing seemed to changed. Yesterday I installed another IDE to see if it handled nested partial classes better than VSE (or VS anything as I understand) it, imagine my suprise when I asked me which documentation set I wanted it to use, and one of the options was MSDN May 2006. There is was, no broken links, Interface definitions etc. How can I get VSE to integrate with MSDN May 2006 FYI the other IDE didn't handle nested partial classes very ...Show All

• Visual Studio 2008 (Pre-release) Expression Blend : API for component developers

  Hi all. I am developing components for WPF and want to make them compatible with Expression Blend. Where to get info about designer API's, debugging, etc WPF is already released, but it seems that no information available about custom component design-time support architecture. Thanks, Eugene. Yes WPF is RTM. But the designer APIs are still in beta, and documentation is still being developed for it. I ran across a blog posting that gives a series of links to resources for custom control development here ...Show All