• SQL query – Unique item with latest date of entry

    Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are multiples which show multiple entries for single itemN, for example. item 1 has three...

    SmurkyIS15 pointsBadges:
  • Bulk Collect vs Cursor in Oracle

    Hi, I have to process some records in some work table. The no. of records in work table may vary from 100,000 to 4,000,000. To process records in this work table i have to loop through it 1 by 1. So please tell me which is the better option out of these two: 1. Create Cursor for this work table and...

    Nikhildhar35 pointsBadges:
  • Oracle SQL and compare date

    Hello! I need help. I want to compare two dates and count how many days its between them. Example: 2006-09-22 and 2006-10-06 results: 14 days Hope for help. Thanks!

    MissNew0 pointsBadges:
  • SQL creating an unwanted duplicate of file

    The other day a colleague ran an SQL statement to update a field in a file to a constant where 2 other fields were equal to constants (so no joining was needed, etc.) When finished, there was a duplicate copy of the file in the first library in the library list. (Which is higher than the library of...

    BigKat7,935 pointsBadges:
  • How to select 1 record in DB2

    As usual, I often use: select top 1 * from table but in DB2, I can't. I use the Toad tool to input SQL statement. Does anyone have a solution? Please share it with me. Tkanks a lot!

    Linhntk5 pointsBadges:
  • Get all table names by SQL

    Hi, How can I get all the table names of a bib by a SQL-query? Thank you.

    Oli0015 pointsBadges:
  • Access 2007 query with null values

    I am currently creating an Access 2007 database for calculating salesperson commissions. I have a table with 5 fields I'm working with: SalesRep, SOWRep, TerritoryRep, Period and Commission. I am trying to build a query that will calculate commission for a salesperson for each record where their...

    stlawr45 pointsBadges:
  • MS Access 2007 functions

    Can someone please help me with the expression for the IFF function?

    TonnieSpartacas15 pointsBadges:
  • Database audit trail

    If database audit trail is not enabled or DBA is having write access on it, then how we can make sure of the integrity of the data in the database?

    Mohra5 pointsBadges:
  • Object-Relational database

    I find it always challenging to drop types and tables in object-relational DB Schema. Almost invariably, ORA 02303 exception is thrown. Is there some hidden facts about this?

    DatabaseStudent10 pointsBadges:
  • Access 2007 – All Access Object Forms Section – Collecting data using email

    In the forms section under the All Access Objects section, I am trying to collect data by using e-mail messages. I am trying to send this form out to a group of individuals and then I would want them to return that information to my email. From there I want to export that information from the form...

    JOrtiz895 pointsBadges:
  • Can in-memory computing handle big data demands?

    Big data may have met its match as in-memory computing has become one of the top 10 strategic technology trends of 2013, according to Gartner. Used by Google and Twitter, this approach allows easier access to data and provides better analysis. Do you think in-memory computing can handle big data...

    Michael Tidmarsh28,675 pointsBadges:
  • Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database?

    Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database? I need to access data in an Intersystems Cachè Database from an SQL Server database. Can I do a select in SQL Server from a table in another DBMS system? How can I do it? Data is in a Cachè Database. I was...

    FernandaAraujo45 pointsBadges:
  • webservice and iDB2 connections slow on startup

    We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the initial connection?...

    ToddN20008,335 pointsBadges:
  • How do you create an order form where you can enter multiple product line items?

    I am trying to make an order form in the data base for product.  I want this form to have customer ID and Company name once on the form then numerous qty, item name, and item number lines to be able to type more then one product ordered on the same order form.  I am having quite a bit of...

    PorcelainConfections10 pointsBadges:
  • Need help writing query-I’m stumped!

    I have a table that looks like this: ID EEID DR CR 1 333 30 2 333 50 3 333 30 4 333 30 5 444 60 6 444 60 7 444 70 ID is my primary key column and it auto numbers the records. EEID is a person, and there are many records per one person. DR is a debit entry for that person, CR is a credit entry for...

    kmanette45 pointsBadges:
  • Make a table

    How do you make a table?

    smurfkelley5 pointsBadges:
  • MS Access 2008 calculation in query

    How can I produce total marks for only last three column where is my fields and result will be:- ID 2004 2005 2006 2007 2008 2009 2010 2011 2012 Total Marks 1 6 6 6 8 0 0 0 0 0 20 2 10 10 0 10 0 8 0 8 8 24 3 6 6 6 10 10 0 0 10 0 30 4 0 0 6 10 10 10 0 10 8 28 5 0 0 2 6 6 8 0 0 0 20 6 0 0 0 8 10 8 0...

    78678678678635 pointsBadges:
  • SharePoint 2010 Capabilities

    Using SharePoint 2010 can I create a page with a template of fields that users can fill out (system change requests) and submit generating an email to a dist list? I also want the page to store the request information, so those can check back on status of their system request changes. I have read...

    SarahBeth5 pointsBadges:
  • E-voting website

    I intend to develop an internet voting website for my department to help with the departmental elections. How do I go about the programming aspect and the core part of database?

    sojiadvanced20 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