Mark Marquis's Q&A profile

• SQL Server Derived Table Alternative

  I have an application that has two different database backends, one is SQL Server Compact Edition and the other is SQL Server. The reason is because the application may run at home on one of our sales agent's computers or here in the office. I have a query that uses a derived table and works just fine in SQL Server, however when I run it in the compact edtion (having the exact same table structures) it will not run. My question is...does the Compact Edtion or the Mobile Edition allow derived tables. If not is there a way to work around this I will happily give an example if it will help. Thank you, Adam Hi, Erik, After a more careful reading of the docs for 3.5 Beta 2, it states that nest ...Show All

• SQL Server Sql 2000 the query run 1/Seg and Sql 2005 the query run two minute

  Query to follow wheel in less of one minute in the same bank that I have in Sql 2000 and delays almost 2 minutes in the 2005 query: select 'REAL' , 'CP AVULSO' , CP . NUMLANCAMENTO , CP . CODECLI , CP . OBS , isnull ( CPC . VALOR , 0 ), CP . DTVENCIMENTO , CPC . CENTROCUSTO_ID from CP , CP_CENTROCUSTO CPC where CP . NUMLANCAMENTO = CPC . NUMLANCAMENTO and CP . CODECLI = CPC . CODECLI and year ( CP . DTVENCIMENTO ) = 2007 and month ( CP . DTVENCIMENTO ) = 01 and CP . NF + ' ' + cast ( CP . CODECLI as varchar ( 20 )) not in ( select NF + ' ' + cast ( CODECLI as varchar ( 20 )) from NFC_CAB ) and CP . ISTRUE_FALSE = 1 and CP . VALORPARCELA ...Show All

• SQL Server Incremental updates into a new partition

  My requirement is to enable full reporting on the current days data and allow ad hoc analysis on all historical data, with the most recent being in smaller partitions because this is the data most likely to be queried. I get a daily feed of the data which I want to import. To do this I am thinking of various partitioning strategies. I am thinking along the lines of the following 1 partition for the current day 1 partition for the current year to date. 1 partition for archived data for 10 years All these partitions would be rolling partitions so that at the beginning of the day, the previous days partition would be merged into the current year partition and at the end of the year, the current year partition would be merged ...Show All

• Windows Forms datagrid columns

  hi i have been working on a program that you enter the date, timestarted and timeended for a day of work then add that info to a datagrid and to have another grid on a seprate form that you will have to enter(datestarted to dateended) which will represent the payperiod i have figured out the first grid which just adds the totalhours worked and total money made for one day so my question is how do you calculate the totalhours worked for the whole payperiod which the user enters then display that on a second datagrid on a diffrent form thank you ...Show All

• Windows Forms Automatically Wrap Text in Label

  I have the following scenario: I have a TableLayoutPanel in my form. In one of the cells I want to place a Label control to display some text. The label might have just a few words. It might have a paragraph. I would like the label text to automatically wrap inside the cell in the TableLayoutPanel. If the row in the TLP is not large enough, it should automatically grow so that it can display all of the text. 1) I have tried setting Dock:Fill and AutoSize:False on the label. This will cause the text in the label to wrap, but it will not grow past the size of the cell in the TLP. If I set the row in the TLP to be AutoSize, the whole row becomes hidden. 2) If I set it to Dock:Top, AutoSize:False, and set the TLP row to AutoSize, this works, ...Show All

• Silverlight (formerly WPF/E) Add the WPF/E browser enhancement as part of the Windows Update as soon as possible

  I apologize in advance – I am sure this question has been answered somewhere. One of the strong advantages of Flash is that it is installed on so many machines. I think WPF/E is great (I just don’t know why it took Microsoft so long to get to this point); however, the WPF/E browser enhancement is installed on very few machines which means that if I use WPF/E my customers are going to be reluctant to download the WPF/E enhancement which is a real problem. The solution is to make WPF/E a Windows Update item which means it will get installed on a large number of machines and I can be competitive with Flash. I realize that Microsoft is at CTP; however, I feel that it is urgent that Microsoft start adding the WPF ...Show All

• Windows Forms autoscroll in datagrid when selecting a not visible row

  Hi, I've got I datagrid with more than 100 rows. There are only 10 visible. If you want to view the other 90 you have to scroll. It is possible to scan in my program and when the code is found in de db, the wright product is selected in the datagrid. Is it possible to autoscroll to the selected product Now the product is selected but you still have to search for the blue selected line :) Grtz Annihil8 With the default settings it is possible to select multiple rows. Selecting a row, the DataGridView will not automatically scroll to that selected row. There is however a possibility to let the DataGridView scroll to a certain row: set the CurrentCell property. (Please make sure you check the row an ...Show All

• Visual Studio 2008 (Pre-release) Broadcast message

  Hi Let us say that I am a service on a local network... Someone called me... I would like to send the response to anyone listening on the local network !!! As I know WCF is great in the P2P scenario. It handles request-response ,duplex and one-way scenarios wery well, but they are All P2P scenarios. How can I use WCF in the broadcast / multicast scenarios I know I can implement a Pub/Sub but this is not a good solution. In a true broadcast scenario I do not have to know my customers (they do not need to subscribe) Anyone has some ideas manu You can use the UDP transport as the transport in your binding - there is a sample in the WCF Windows SDK which shows how to write a UDP t ...Show All

• Gadgets Testing in Spaces and preview?

  How does one test a gadget in Spaces or in preview mode from a local machine I don't see a place to add the manifest URL. Thanks, Ty Hi Guys, I'm new to gagdet development (very very new...like, I started two hours ago!), and I was after some help testing on Spaces. I've written a very simple gadget. It just displays some document properties (I'm trying to understand what I can and can't access from the gadget): p_elSource.innerText = "document.location.href: " + document.location.href + "<br><br>document.cookie: " + document.cookie + "<br><br>document.referrer: + document.referrer It works fine in Live.com, but if I try to add it to my Spaces p ...Show All

• Visual Studio The project factory Library is not registered

  I'm trying to make the most simple GAT project. When I try to register the project, I get the following exception: Microsoft.Practices.RecipeFramework.RecipeFrameworkException: The project factory Library is not registered, template C:\Documents and Settings\MYeager\My Documents\Visual Studio 2005\Projects\MilosTestGuidancePackage\MilosTestGuidancePackage\bin\Debug\Templates\Solutions\Projects\_ExternalReferences\_ExternalReferences.vstemplate cannot be installed. at Microsoft.Practices.RecipeFramework.VisualStudio.Templates.TemplateMetaData..ctor(String templateFileName, CommandID command, String packageName) at Microsoft.Practices.RecipeFramework.VisualStudio.Templates.VSTemplatesService.Microsoft.Practices.RecipeFramework.Visua ...Show All

• Software Development for Windows Vista Examples of workflows using Office 2007?

  I am looking for examples of workflows that are integrated with Office 2007. This is mentioned in chapter 4 of the "Presenting Windows Workflow Foundation" book but without much detail. The Office 2007 web site talks a bit about some workflow things (document routing) that will be included 'out of the box'. What I am really looking for is sample code with activities specific to handling (say) a Word document: sending it for approval by several reviewers, gathering comments back - anything along those lines. There are samples in the sdk - http://www.microsoft.com/downloads/details.aspx familyid=38CA6B32-44BE-4489-8526-F09C57CD13A5&displaylang=en ...Show All

• Visual Studio Express Editions Changing The state of a Row or Column or Cell Programmatically in a DataGridView

  Hi I Want to change the state of the a Cell or row or Column. For example i want to set the state to frozen to 2 or three columns ( the first columns) . The State property is readOnly. In the documentation I found the following description in the remarks section of DataGridViewElementStates Enumeration: "Although these different states, like Frozen, are enforced by the UI, they can be programmatically overruled." The question is How I checked the documentation previously. And i Tried to change the state using simple statements like this: this.grid.Columns[0].State = DataGridViewElementStates.Frozen & DataGridViewElementStates.Visible; but I get a compiler error like this: Error 1 Property or index ...Show All

• SQL Server cannot execute xp_cmdshell. Access is denied while copying data over the network

  Hi, I am having some trouble copying data over my workgroup network from my Windows 2003 Server Machine (machineA with SQL SERVER 2005) to one of my network Machine's drive(MachineB). Here is the T-SQL code that I am trying to execute: EXEC xp_cmdshell 'copy D:\Data\file.txt \\MachineB\Documents' Whenever I tried to execute the above piece of code, I get the error message "Access is denied", but if I try to copy the file from the Command Prompt (cmd.exe) with the copy command, the file copies fine over the network. I have already searched over the internet and I found out that loads of people have the same issue, and they were suggested something like this: "Check in Services and make sure that the MSSQLServer service is run ...Show All

• Visual Basic Locking Form Size (simple Question)

  Hi, How do i stop the user re-sizing a form (for example an option screen) and remove the minimize and maximize buttons on the top of the form Andy Me . FormBorderStyle = Windows . Forms . FormBorderStyle . None 'or Me . FormBorderStyle = Windows . Forms . FormBorderStyle . FixedSingle 'fixed3d Me . ControlBox = False Me . MinimizeBox = False Me . MaximizeBox = False ...Show All

• Visual Studio Team System Compare and Sync functions from SSMS

  Is there a proposal to integrate the Comparison and Synchronization functionalities in the SQL Server Management Studio This will help the DBAs work with a single interface. If yes, when can we expect the same When it comes, will there be a price attached to it Appreciate your response. I don't think so. If Schema and Data Compare are included in SSMS and the project accessibility into all versions of VS (even just VS Team Editions) as has been heavily requested and has much more reason to be done, then what is left for Data Dude The original premise of Data Dude was to move database development out of SSMS into a developing environment with project and source control. The original premise of all Team ...Show All