stswordman's Q&A profile

• SQL Server Case statement

  Hi I am having a few problem with a case statement. I have a table with customer data in and I need to bring back all the rows which have data missing from 2 different columns. customer table CustomerID Name SoftwareVersion 1001 TEST1 V5 1002 TEST2 V5 3 TEST3 V5 004 TEST4 V6 ect.. CustomerID Table ID 1001 1002 1003 1004 ect... I have a need customerid table and I need to list all the customers who are not in this table or whos id does not match the new listings, alos there is a softwareVersion Table list all the newest software so the same will need to be done for this. Thanks Rich I assume you mean that the CustomerID table ...Show All

• Windows Forms ToolStrips moving between Forms

  Basically I have a MDI application. Number of different MDI children each with different toolstrip's and layout on each (loaded in programatically via a custom XML layout system). The problem I'm having is that ToolStrip's can travel between ToolStripPanel's and ToolStripContainer's of other MDI forms. I want ToolStrip's only to be able to be moved between other ToolStripPanel's inside the current Form, and not to ToolStripPanel's in outside forms. A possible solution if the above is not possible, is just to allow reordering of the ToolStrip in the current ToolStripPanel only. Thanks ...Show All

• SQL Server Need advice on how to optimize table.

  I have a ledger table that will have many entries for a given invoice, I need a good way to identify the most recent entry for the invoice. I've thought about putting an IsMostRecent flag in the column, but it would still require a table scan to identify the most recent records for invoices. I thought I could build a view over that table that had the invoiceID and max(tableID) and build an index on it, but you can't use the max() function in this instance. The only other thing I can think of us to build another lookup table, with the invoiceID and the tableID, but I don't think that is the best solution. Any tips would be greatly appreciated. Could you post your table definition and any indexes you current ...Show All

• Visual Studio 2008 (Pre-release) Making NavigationUI frame specific

  Hi, I would like to have my NavigationUI sensitive to the different frames i have in my page. In other words I would like to keep a journal of each frame and change the journal of the NavigationUI when the specific frame becomes visible. But I can't find a way to change the journal of the NavigationUI. So I want to change the journal of the NavigationUI each time the TabItem changes. <Page x:Class="TabJournal.MainPage" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="TabJournal"> <StackPanel> <TabControl> <TabItem Header="{Binding ElementName=frame1, Path=Content.Title}"> ...Show All

• SQL Server Source Script Component using a flat file connection - System.ArgumentException: Empty pathname is not legal.

  I am using a Foreach loop container to go thru all the files downloaded from the ftp site and I am assigning the file name of each file to a variable at the foreach loop level called filename.  In the dataflow task inside the foreach loop container, I have a source script component that uses a flat file connection.  The connection string of the flat file connection is set to the filename variable declared at the foreach loop level.  However the script component has a error System.ArgumentException: Empty pathname is not legal. Please let me know how to correct this   The connectionString property of the flat file connection is set to the complete filename including the path.  Does a script component need to have ...Show All

• .NET Development How can I specify a daily start time for a windows service?

  A windows service's StartTime can be set to automatic or manual. But how can I configure the service to start at a specified time every day Thank you. A service does not have a "start time" it has a start type . This specifies whether a service starts when Windows boots or not. If you want to perform an action at a given time of day then starting a service is not the correct way of doing it. ...Show All

• Software Development for Windows Vista Error while running Install Certificate Script

  Dear all, I have encountered a problem while running the VB script for installing certificate. I does not have this problem when I try to install it on a laptop. However, this problem comes when I try to create the cardspace environment in a virtual machine using VMware. The error message  is "The security ID structure is invalid." The error code is 80070539.   When i try zoom in into the script. It was found that the error is triggered by a line the VB-Script-Library.vbs 'Adds a READ ACL for a user on a file sub AddReadACL( resource, user )     dim oADsSecurityUtility, oSD, oDacl, oAce     set oADsSecurityUtility = CreateObject("ADsSecurityUtility")     set oSD ...Show All

• SQL Server dynamic archiving

  I need to set up a stored procedure or DTS that can export data to a text file - based on parametres passed when it's called. We have a scheduling server, where all our logging is stored and procedures are called. The data I need to export can be on diffierent servers in different databases. I started with the following: DECLARE -- @TableName varchar(128), -- @Filename varchar(200), -- @date_field varchar(20), @SQL varchar(2000) -- SET @TableName = SET @SQL = ''''+ 'bcp "SELECT * FROM '+@TableName + ' WHERE ' + @Date_Field+ ' > GETDATE()"'+ ' queryout "c:\test.txt" -c -q -U"sa" -P"" '+ '''' print @SQL -- set @SQL = 'EXEC master.dbo.xp_cmdshell ' + @SQL -- EXEC (@SQL) However, I'm ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. fx problem ?

  Hi all, I has few fx effect problem. Hope somebody help. Q1. How to move texture uv with fx Q2. How to create smooth effect Please give to some suggestion about create smooth effect with fx. Best Regards, Q1. How to move texture uv with fx If you're using a vertex or pixel shader then the UV texture coordinate is just a numerical input - you can manipulate it (move/scale/distort..) as you see fit. The only potential complication is you can run into dependent reads. Q2. How to create smooth effect Please give to some suggestion about create smooth effect with fx. You'll need to provide a lot more information about what you want. A smooth effect could be various forms of shading (D3D will gi ...Show All

• .NET Development Connecting with MS Access.

  it is very easy to work with data for ASP.Net when using SQL server. Probably Ms Access is not ideal for Web environment. Howerver we must know how to make connection & different other operations with data using ms Access. how to display it, how to access different columns & rows & cels. its pretty much the same way as in SQL Server. Connection string is different (check out www.connectionstrings.com for the connection strings available to you for MS Access) and a different namespace of classes. You would use OleDb classes (OleDbCommand, OleDbConnection, OleDbDataReader etc....) to perform your operations on MS Access select/insert/update statements are the same, but if using parameterized statements, wherever gene ...Show All

• SQL Server column alias as variable

  Is there a way to select a column as an alias using a variable for the alias something like this: SELECT Column1 as @myVariable FROM Table1 The user enters a period length such as 30 days and the report displays the period date ranges as the coulmn name of a pivot. like this: Location 1-30 31-60 61-90 Texas 10 3 2 Florida 5 8 7 ...Show All

• Visual Studio 2008 (Pre-release) Is it possible to run a WPF application that requires full trust in a browser?

  Our app is a xaml browser application, and is set to 'requires full trust' option. It can run in debugging mode, but does not run in the browser. The following error is shown: Trust not granted. The application cannot be deployed because it is not trusted and possibly unsafe. Detail: PLATFORM VERSION INFO Windows : 5.2.3790.65536 (Win32NT) Common Language Runtime : 2.0.50727.42 System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200) mscorwks.dll : 2.0.50727.42 (RTM.050727-4200) dfshim.dll : 2.0.50727.42 (RTM.050727-4200) SOURCES Deployment url : http://localhost/DataAnalysis/DataAnalysis4.xbap Application url : http://localhost/DataAnalysis/DataAnalysis4_1_0_0_1/DataAnalysis4.exe.manifest IDENTITIES Deployment Ident ...Show All

• Visual C++ about timestamp

  Hello everyone, I need to record a set of data items. For each data item, users may modify to some new content. So, I plan to use a timestamp field for each data item to record the time when user modifies data item last time. I am not sure whether I should use a simple integer value (like version information, which increase 1 each time when user modifies data item) Which approach is better What are the advantages and disadvantages of each approach thanks in advance, George Thank you Chris, Chris Hird wrote: I tried to use the time stamp but found it did not work in my case. the problem I had was the process ran so quickly that retrieving the current date and time resulted in a lot o ...Show All

• Visual Studio Problem with the office 2003 addin

  Hi, I have created an office 2003 addin with teh code given in the site http://msdn2.microsoft.com/en-gb/library/aa218648(office.11).aspx but the addin is being created and i was not able to get the addin with the frontpage. When i tried to manually add the addin to the front page it is giving an error saying invalid office addin. please help me i have no time...... Thanks, phani In advance Try this: FIX: Add-ins, smart documents, or smart tags that you create by using Microsoft Visual Studio 2005 do not run in Office http://support.microsoft.com/kb/908002 ...Show All

• Smart Device Development Button Changing to Picture - C#

  I am programming a game in C# using Visual Studios 2003 .Net Compact Framework. I would like to be able to either change a button to another color when clicked or if that is not possible change it to a picture and have the button disapear. Advice appreciated- Just create a custom button that shows images: http://msdn.microsoft.com/library/ url=/library/en-us/dnnetcomp/html/ImageButton.asp frame=true ...Show All