Will5's Q&A profile

• SQL Server Division Problem

  Hi there, I need some help on a query I'm trying to build. I have two columns, one has the current months value and the other has the previous months value. I only want to select the rows where the previous and current values differ by more than 10%.  The problem I have is that some of the rows have values of 0. Any help is appreciated oh. . . and my query has a mistake -    select cur.Tas ...Show All

• Visual C++ VS and side-by-side installations of PSDK?

  Hello all, I'm currently evaluating VS 2005 C++ (Express Edition) and I'm planning to install the new Platform SDK Windows Server 2003 SP1. However, I'm still running VS 6.0 on my computer which is still needed to build a number of old projects. On the PSDK download page however it says that side-by-side installations of the new and older PSDKs are not supported, which doesn't sound nice at all meaning, as I understand it,&nb ...Show All

• Visual C# calender in datagridview cloumn

    i want to display calender in each cell click for one column in dataGridView.                                                             ...Show All

• SQL Server Simulate ROW_NUMBER () in SQL 2000

  I would like to generate an incrementing column value to each row found in a query in SQL Server 2000.  My understanding of SQL Server 2005 is that you can accomplish this approximately along these lines:    insert into MyList (myNo, lName)    select ROW_NUMBER() myNo, lName    from Employee    select * from MyList    order by myNo    myNo   &nbs ...Show All

• Visual Studio Tools for Office Dynamically attach an assembly to an Excel File

  Hello I have the follwing problem. I have a VSTO 2005 smart document for Excel that will be deployed on a web share. This assembly should be accessed by excel files. As far as I understood I should use clickonce to do that, and dynamically load my dependent assemblies when the application starts, to make them present in the IE cache for offline working. But I have a complication: the Excel file does not exists, nor does a template for this file. ...Show All

• Visual Basic client - server communication

  hi friendz, i am creating a application using visual basic 2005. In that application Client (many) sends data (integer type ) continuosly (for every 5 minutes ) to server. i am new to visual studio 2005. so i need help from u all. my doubts are.. 1) how to create a communication medium.. ( using which control ) ( any sample coding ) 2) how to control the clients from the server. please send any code snippets. and tell how to implement ...Show All

• Visual Basic How long a computer is on, and writing after some text

  Well this is a two Q topic. First i want to know if there is any code for getting the time for how long the computer has been on Comptime.. Second how can i input text after some text in textbox For instance button1.click inputs the text "you" into textbox1.text But if the textbox1.text already has some text like "how are" then when button1 is clicked text should be input after "how are" and the text should be "how are you"   ...Show All

• SQL Server AES (128 bit block) : Can I use it?

  If I've got a 64-bit OS such as Windows XP Professional x64 Edition running and I have the SQL Server 2005 Express Edition, is AES permittable or does TRIPLEDES still need to be used SQL Server 2005 does not support AES encryption on Windows XP. You can visit http://msdn2.microsoft.com/en-us/library/ms345262.aspx for more details. -Raul Garcia SDE/T SQL Server Engine ...Show All

• Software Development for Windows Vista Working with parameters in workflow

  Hi, I am new to WWF and trying to understand in creating workflows. I was trying to build a custom workflow with Beta 2 but I cannot find the parameters attribute in the Workflow class. I believed that it was in the older beta releases - and I am using VB with WWF for now in VS2005. Thus if someone can kindly let me know how to add in the parameters in Beta 2 these days it would be extremely helpful. Many thanks, Mark Hi Pa ...Show All

• SQL Server send email

  I have a table with email addresses of the customers. How could I send them emails from my tsql script. TIA.. Hi   If i want to do a HTML email like below what should i do exec sp_send_cdontsmail 'someone@example.com','someone2@example.com','Test of CDONTS','It <b>works</b>'   ...Show All

• SQL Server SQL Mobile performance/size problems with WM5 device

  I just upgraded our application from SSCE 2.0 to SQL Mobile. Our app is written in C++, and we use OLE DB for most of our queries, including the routine the downloads and inserts our lookup table data. This application is running on a Dell Axim X51. Using SSCE 2.0, this routine takes 236 seconds, with most time spent inserting data into various tables (using OLE DB). The resultant database size is 15.1 MB. Using SQL Mobile, this routine now take ...Show All

• SQL Server Views not working

  Hi everyone, i'm currently programming an application for service engineers. In this application I use replication. The problem is that when I add a view to the publication, I still receive all the data. Does anyone know what I'm doing wrong Thanks in advance. Even though Views show up in the publication wizard as articles that can be added to a publication, they cannot be replicated to a SQL Mobil ...Show All

• Visual Studio Team System Rosetta.Populate Reports

  Hi all, After 2 days I successfully passed 32000 trouble at Team System Beta 2 installation. Now, another error occured: While setting up a team project the task Rosetta.Populate Reports failed. The following error log was created: 05.11.2005 01:36:03.230 | Module: Rosetta | Thread: 9 | Creating report : Bug List ---begin Exception entry--- Time: 05.11.2005 01:36:14.176 Module: Engine Event Description: Task "Rosetta.Populate Reports" failed Ex ...Show All

• Visual C++ Set VC++ Directories in Options dialog (Visual C++ Express)

  Details :  The VC++ Directories page on the Options dialog does not have a list box for viewing and modifying the directories used during a build. Consequently, it is not possible to modify the build directories using the IDE UI. Workaround : C++ Directories can be added, removed or changed by modifying the VCProjectEngine.dll.express.config file located in the .\vc\vcpackages subdirectory of the Visual C++ Express Edition install locati ...Show All

• SQL Server Install Client Management Tool in WinXP Professional with SQL2005 CTP

  SQL server 2005 was installed successfully with SQL2005 CTP CD(Enterprise edition).  However, I tried to install Client Management Tool in my WinXP Professional desktop, it stated that incompatibility of OS.  Does it mean that I can only install client management tool in WinXP profession with CTP for other editions except enterprise one   Thanks in advance. ...Show All