• SQL Query to get the difference from average for every row with grouping

    Hi there, i was wondering if anyone would be kind enough to help with something i am struggling with... I have a table something like this: Region ID Cost s1 1 v1  s1 2 v2  s1 3 v3 s2 4 v4 s2 5 v5 s2 6 v6 What I am trying to achieve is to get a result set that looks like this using a single query...

    Baatch20 pointsBadges:
  • How do I duplicate or clone a dying SATA drive?

    If a sata drive is dying what is the best method to duplicate or clone it without risking the data? Is this the same for ide or scsi drives? If not please list the best methods for these as well across any platform.

    ITKE345,300 pointsBadges:
  • What is the procedure for Deployment in VB6.0

    Dear Friends, I have developed a small project using Visual Basic 6.0 as front End, MsAccess for database & VB reports for reports on OS Windows XP SP2.  It was completed successfully and working on my system but how to transfer or make it work on other system where VB is not available. Please...

    SailajaConsultancy5 pointsBadges:
  • Standby Database Server

    I am using oracle 10g and I want to use a standby database for high availability of my database. I did almost everything; but I don't know how a user can connect to the standby server when the primary has failed. This is my connection string "Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =...

    Girma30 pointsBadges:
  • CONNECTION VB WITH ACCESS

    how to connect visual basic 6 and msaccess 2003 by using connection string

    Yusuphsngoroge5 pointsBadges:
  • How to enter a field with number increments in Access 2007

    How to increment a number field adding 3 with the number from the same field of the previous record. (like entering next invoice number)

    SatbirBlog15 pointsBadges:
  • Combine (concatenate?) in Access~special circumstances

    Hi, I need to be able to combine (concatenate?) fields in Access so that each item in Field 1 is joined to each item in Fields 2 thru 5. I have tried to illustrate this in the samples below... In the samples below, Account code is in Field 1... String(s) to be added are in Field 2. Then in Field 3...

    Matchmole5 pointsBadges:
  • odbc question

    what odbc driver you use to go from system-i to sql2005 i sue IBMDA400 but does not handle pack fields very well any suggestions?

    Colo20055 pointsBadges:
  • Access 2007: Create a form for both display and data entry purposes

    How can I create a form that is autofilled with data from a query (such as a client's ID and balance), and will also be used for data entry for another field from a table not part of the query (the amount paid by the client and the current date)? I tried to use a subform for the data entry but (a)...

    Deej185 pointsBadges:
  • Dummying a dataset with a concatenated list of datasets

    I have an input of 6 contactenated files and I wish to process with just the 4th file in the list. Will dummying the first 3 and last two still pull in the 4th dataset or by dummying the first in the list in effect dummy all of the inputs in the list? Does the dataset you wish to process need to be...

    Jaharvis15 pointsBadges:
  • How to remove Microsoft Foxpro Title bar

    How to remove Microsoft Foxpro Title bar from the main screen in FPW2.6

    Tanvirac5 pointsBadges:
  • What is wrong with this database search query?

    searchStr =|FIELD Form =Form1  & FIELD CallsBeginDate >= | &  Trim(Cdat(doc.DeleteStartDate(0))) &  |  &  FIELD CallsEndDate <= | &  Trim(Cdat(doc.DeleteEndDate(0))) & | & FIELD Team =| & Trim(doc.OnCallTeam(0))&|| I have used with NotesDocumentCollection. Thanks for any feedback  

    ALK125 pointsBadges:
  • What is the code that links vb 6.0 to Ms Access and how to go about it?

    What is the code that links vb 6.0 to Ms Access and how to go about it?

    nyaga135 pointsBadges:
  • iSeries Update Values in a Table Based on Values in Two Tables.

    I want to update a Client Category Code in the Client_Table where the Client has a specific Country Code AND and the Clients VAT No is Blank, Which is in The Client_Account Table in another Library. The Matched Records are [LIBRARY1]FILE1.CLLDRS and [LIBRARY2]FILE2.ADLDRS So Update...

    Sconna2325 pointsBadges:
  • Javascript code

    Hi, I'm looking for an IF function code,,, My condition is IF I TYPE THE WORD "MOD" in a CHAT BOX THEN I want this MOD WORD TO APPEAR IN GREEN COLOR. I would like to know the code which I can embed for this to happen? thanks!

    SaraKhan5 pointsBadges:
  • Change the size of a column and then reorganize the rows in SQL tables

    I think this one will be tricky. What I have is a table like: CREATE TABLE PHOTO_DETAIL   (     "PHOTO"        VARCHAR2(25 BYTE) NOT NULL ENABLE,     "NUM_LINE"   NUMBER(20,0) NOT NULL ENABLE,     "PHOTO_LINE"  VARCHAR2(180 BYTE)   )   what I am going to have is: CREATE TABLE...

    Hispi25 pointsBadges:
  • ODBC and AS/400 trigggers

    Will a AS/400 physical file trigger work when the file is updated by ODBC?

    Jjjlake40 pointsBadges:
  • Create a view in DB2/400

    I need an example to create a view in DB2/400. I Need to create a view where the table name is greather than 8 characters and collumns names greather than 6 characters. please somebody can help me??

    ITKE345,300 pointsBadges:
  • Can’t change Navigation Button Caption for subform

    I'm following the instructions in the New Perspectives Comprehensive Access 2007 and can't seem to get the Navigation Button caption to appear in the window when I use the Form selector and select the subform. Any ideas?

    Bets5 pointsBadges:
  • Database Update database

    I will whole database all tables, procedures, triggers, functions defination in one file. i want to use that file to upgrade another database. is it possible ?

    Shrirama25 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