• Updating a table with sub query

    Hi, I need to update a table with a sub query. Here are the steps I'm following but I'm struggling to successfully update the table. the performance of this update has to be good because of the number of rows I'll be updating in production. any ideas? thanks in advance. drop table dummy_test create...

    Fitzdp0 pointsBadges:
  • Deleting files on remote servers

    Good day, I currently have a web farm and and trying to use a vb script to delete file from remote servers. I have tried the following scripts. Shell ("del \server1C$dir*.* /F /S /Q") This gives the error message, ensure files exist. then I tried this newProc =...

    OpelikaTJ0 pointsBadges:
  • CA Express download from iSeries to excel

    I really really need help finding a solution to this problem. We have users that download files from the iSeries using Client Access Express into excel. The problem is that when the report comes up in excel the negative numbers have the minus sign to the right of the number instead of the left....

    2839005 pointsBadges:
  • How to unsubscribe

    I am getting ready to Retire from my current employer. I will not be working in this field as I have started a very different and unique business. have looked all around to find out how to unsubscribe but can not easily find out how. If anyone knows how, please let me know.

    CasNowak0 pointsBadges:
  • picture on desktop that cannot be removed

    Don't know if this is the right place, but cannot find an answer elsewhere. Using Windows XP media centre edition with SP2. belongs to a Lao woman in the office. Displays a picture of a naked woman on the desktop which can not be moved. causes great embarrassment. Found it in screensavers, named...

    Kees19480 pointsBadges:
  • Regression testing of security products

    How to perform regression testing when security patches are integrated into the COTS components? I also want to know the procedure for minimizing the selection of test cases for these patches. Even if patch management tools are available, it does not focus much on regression testing, it seems.

    Gprakas740 pointsBadges:
  • packagin and deployment

    i have just finished a robust application to process payment of investment. i used crytal report to display those to be paid at a time set up by the company. i compile the project and it is working perfectly. however when i used the VB packaging and Deployment wizard for distribution it generated...

    Xr8dcoder0 pointsBadges:
  • Subquery as a table reference

    I use Showcase Strategy to develop queries and reports on the AS400. Showcase is telling me that I can't use a subquery to create a table reference to join with in the FROM clause. The Showcase Tech says subqueries are only allowed in WHERE clause. Non-AS400 SQL texts I have read suggest subquery...

    JohnDonnelly0 pointsBadges:
  • Would like visual Basic app to control a javascript app by passing command line commands

    Hi, I have a javascript application that I use to debug hardware at my job, and its user interface is a command line in a (WindowsXP) dos window. This is kind of crude (e.g. to read a memory location you have to type something like "gfcb.readx(0xcf001234)") so I would very much like to design a...

    Rennysoncemann0 pointsBadges:
  • visual basic

    plz,give me the coding of connection string to connect VB as front end with SQL as back end.

    Poojamittal0 pointsBadges:
  • Expected Results: How to persuade developers to document them

    What is the value proposition I can offer our developers and customers when persuading them to do a better job at documenting expected and actual results in their test cases? We exist in an environment where developers perform the tests up to UAT, developers and customers are domain experts, there...

    PMOdoff0 pointsBadges:
  • URGENT!!! file field decoder generated on AS/400

    REALLY URGENT!!!!!!!!!!!!!!!!!!!!! How can i view the contents of a packaged field? I send an example of the chain. I need to visualize the contents of the little squares: 5 1 91010 491997 9801011L 980101 1 1021023 102 103 100 DTO CARULLA DTO CARULLA DTO CARULLA 0 1 0 11 K 1TQ 15% Q TQ NAL T TQ NAL...

    Onasis0 pointsBadges:
  • Using Local Variable as FILENAME in CREATE DATABASE Statement

    I am trying to use this statement in SQL Server 2000 :- CREATE DATABASE [Maintenance] ON (NAME = N'Maintenance', FILENAME = @TableName , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Maintenance_log', FILENAME = @LogFileName , SIZE = 1, FILEGROWTH = 10%) COLLATE Latin1_General_CI_AS GO The...

    TheHutt0 pointsBadges:
  • Turning Report Output into XML

    We have a report subroutine that most all programs PERFORM to write data to our electronic report distribution system. Looking for suggestions on how to define these reports so we can store them in some form of XML that would then maybe be applied against a style sheet perhaps? I'm still a novice...

    Rbeethe10 pointsBadges:
  • Dialing out to a paging service

    Has anyone ever written a program that runs in batch and dials a paging service? I would like the program to navigate the service's prompts and and leave a message. The message can simply be a string of a few digits. Please respond if you know how to 1- dial the service or 2- simulate a human...

    JeffcoITDEv0 pointsBadges:
  • computer protection with revert

    I am looking for a solution wich will allow me to revert computers setting back to original each time computer reboots. Basically on reboot computer will earse all files and configurations made in previous session.

    Dimchik0 pointsBadges:
  • how toconfigure ipadress through run

    plz tell me how to configure ipadress through cmd prompt or through run??????

    Jaanjaan0 pointsBadges:
  • SQL behaves differently in two identical Oracle 10g db’s

    I have a SQL statement that is behaving differently in two "equal" databases (equal in schema, but size differs by about 50%). Here's the statement: select distinct 99, 31, b.school_id, a.provider_id, a.student_id, '2007', lpad('01',2,'0'), '0' from studprovider a, student b, school c where...

    Sprevost5 pointsBadges:
  • Postfix not communicating with Mail server

    Dear All, Please I need help urgently. My postfix mail server has stopped sending out mails. users on the network cannot send mails to other users on the same domain and even to other domain. I use postfix and fetchmail services on my mandrake linux. I have never experienced this before. When I do...

    TosinO0 pointsBadges:
  • WPA with EAP-TLS not working with IAS

    Using win2003 domain controller with IAS to authenticate wireless users. Certificate server configured to hand out workstation and user certificates automatically. AP is cisco 1200. Got nowhere until I manually added a certificate under current user/personal/certificates. Then got this error from...

    Astronomer15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following