• SQL Server 2005 query to get the average

    Hi, I'm using MSSql 2005 on Windows 2003 Server. I need some assistance to write a query to get the average of two columns and write the value to a third coulmn. All the transactions is in one table. Basically it is column 1 + column 2 devide by two = column 3 Thank you, George

    GPNel200675 pointsBadges:
  • How to update data using Microsoft Excel VBA?

    I HAVE A CELL "A1=NUMERIC VALUE" & "A2=NAME OF PARTY" WHICH IS UPDATED EVERY MONTH AND I WANT TO SAVE IT WITH "DATA" SHEET WITH EACH PARTY NAME(CELL A2) AND ITS MONTHWISE VALUE(CELL A2).HOW CREATE DATA SHEET WITH MONTHLY COLOUM NAME I.E : DATA SHEET: NAME OF PARTY APRIL08 MAY08 SURENDRA KUMAR...

    Sa2915340 pointsBadges:
  • How can I compare fields on two databases

    I want to list all fields on a database and use a forall loop to check list of fields on two forms in two seperate databases...can this be done

    Star0810 pointsBadges:
  • QMQRY not a valid Query Management variable.

    Hi there, I am trying to pass parameters to QMQRY but get the following error. CALL PGM(JCCSTREP2) PARM(C165) 'C165' is not a valid Query Management variable. Error found on STRQMQRY command. CPF0001 received by JCCSTREP2 at 2800. (C D I R) the CL pgm that call the query is as follows: PGM...

    NormFeile25 pointsBadges:
  • VBScript that logs in a user to remote server

    Hello, I'm working in server 2003, remotely. I have a few schedule tasks, each running a business program i'm working with and a vbscript which checks that the program ran successfully and suppose to send an e-mail report. All of this happens during the night, when i'm logged off from the server....

    Razz5 pointsBadges:
  • Finding the number of rows of all tables of a user/schema in Oracle

    how can i know all the table names along with the no. of rows they contain for a user/scema in oracle 9i through sql? plz answer ......

    Chrishram15 pointsBadges:
  • SQL query and Oracle database design help needed

    Sorry for all the confusion with the questions.So let me clear myself,i am doing this not as assignment or homework,but something which interests me and trying to leran.Earlier as I stated that its a part of my school(** well frnakly speaking, it was my plan if i could put this as an item of the...

    Rohit331225 pointsBadges:
  • How to use button created by Crystal Button in VB forms

    how to use export external button creaTED by s/w in vb forms

    Viral5 pointsBadges:
  • .NET System.IO.Stream

    System.IO.Stream stream = GetType().Assembly.GetManifestResourceStream("logo.ICO"); gives me an error like "Value of 'null' is not valid for 'stream'"

    Minal45 pointsBadges:
  • IT Automation

    How do you think is JMX and WMI is useful in IT Automation (RBA) ?

    Jkumbhani5 pointsBadges:
  • .NET DataTable

    how to pass datable from one form to the other in desktop application?

    Minal45 pointsBadges:
  • Does anybody knows any API, which will extend the size of Display File in AS/400 (making bigger than 132), like Excel ..

    Does anybody knows any API, which will extend the size of Display File in AS/400 (making bigger than 132), like Excel ..

    Alukats10 pointsBadges:
  • Need guidance in starting my career in SAP

    I am Bachelor of Technology from Mumbai (India). I have had a short stint at a S/W development company where I developed a software using Java-J2EE. For this I needed to understand the business problem in the REAL WORLD and then go to the ABSTRACT WORLD to code a solution for it. I soon realized...

    SAPbeginner840 pointsBadges:
  • Conditional Formatting Excel 2003

    I have three columns, Column 1 = Start Date Column 2 = End Date Column 3 = Close Date I need to place a conditional format or and "IF" statement on columns 2 and 3. Stating if column 2 is after or 1 month from today's date highlight in RED. And column 3 should state if column 3 is less than 3...

    Reyes335 pointsBadges:
  • Toggle text between red and black

    How do I write a program on VB 2008 that allows the user to use a button to toggle the color of the text between black and red?

    Lauren65 pointsBadges:
  • Remote RSOP gives RPC server unavailable

    Windows Small Business Server 2003. When I run Rsop from the Server against any client pc(all XP SP3) I get RPC Server Unavailable. Firewall is disabled, exceptions are allowed, all releated services are started. If I run rsop from a client machine against another client machine it works fine....

    NetSupport460 pointsBadges:
  • How can I select unique records from Access based on two criteria

    I need to do the following: SQL = "select amount, count(amount) from table1 group by amount having count(*) =1" This returns all unique records, but I need to add another criteria to that statement ie: I need to select all unique records only if a second value is met as well! This is what I had in...

    Grantp40 pointsBadges:
  • Visual Basic 6 – Changing font style, font color and font size?

    how to change font style,font size and font color using command button in visual basic 6.0? the input text will be change if you click the appropriate button.Please help me.Thank you and god bless. I will be waiting your answer as soon as possible.Thank you very much.

    G12185 pointsBadges:
  • Update one database from another database with ASP.NET

    I want to update my database from another database when it change.Thank for your answers

    Ingineer5 pointsBadges:
  • .NET – Document Management System

    I am working on .net windows application (Document Management System). In this application i am working with files and folders. and i want to use Encrypted file structure,Encrypted folder structure and Facility to store documents anywhere. Any Idea?

    Minal45 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.

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

Following