• query conversion alpha to numeric

    I have split a field into two new fields by using SUBSTR, but want to define those as numeric fields. How can this be done

    leifsperre5 pointsBadges:
  • Like query code

    I want to use a filter that would be the equivalent of the "like" command in SQL. so it could read column name NOT LIKE 'pos%' as and example.

    JPNebraska15 pointsBadges:
  • Slow query response time in SQL Server 2005

    Why is their a slow query response time in my SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Writing a specific query in SQL Server 2005

    I have a table called "ticketing" and I want to bring from that table the record with the most current date. What kind of query should I write in SQL Server 2005 to bring up that result?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is there a query to search text of all SQL Server database objects that reference a specific table/instance?

    We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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:
  • Query

    I have a training database; one table lists employees by titles and training required; the other lists employees by name and training completed. I would like to do a query finding out which training that is required but the employee had not received, how would I create that query?

    catalina3x10 pointsBadges:
  • SQL Group by Query with aggregate function as well as detail information

    Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, ... I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the...

    idontknowthis20 pointsBadges:
  • Need urgent help

    What is query to map data by combining multiple columns in different table I have two tables named table 1 and table 2 respt.. In table 1 is as shown below User Role AP.A AP.B AP.C AP.D High Low Medium Sanket Admin AP.A AP.B AP.D Abhi Man AP.B AP.C Sank Emp AP.A AP.C AP.D And I have one more table...

    sanketkolge1010 pointsBadges:
  • Difficult SQL query, is this possible?

    Two tables, First Table --FN---LN----Reasons John | Doe | 6 | Jane | Doe | 2 | ----------------- That's the end of the first table. Second Table ---Reason----Reason Detail----- 2 | Invalid SSN 4 | Invalid Date Of Birth -------------------------------------- That's the end of the second table....

    David Phillips35 pointsBadges:
  • SQL 2008 query: return results where row not in another table

    hi, running sql2008.  i have the following two temp tables.  the first is just all web service errors for a date range.  the second is simply 20 rows that contain values of types of web service errors. --temp tbl #1 select [date],[err],[srv],[e1],[e2] into #tblExcept from netlog where [err] like...

    RdS1995 pointsBadges:
  • i5 Query Security

    Are there any commercial security programs that will secure the query function on the as400? We have user menus that keep users from viewing and changing critical files. However, we also have users who go into query and save the results of the query anywhere on the system.  I'm concerned that...

    Amauer5 pointsBadges:
  • Limit the number of record in a table

    I want to limit the number of records that a user can input in a specific table. for instance, users should be able to subscribe to a race which are limited to 10 tracks.   I would i to have a clause or something that might help my to prevent users from exceeding the number of tracks available...

    Astre88m5 pointsBadges:
  • MS SQL query to update a table with the last entry in another table.

    Hi, Could anyone please assist. I'm trying to update a Reporting Table with the last entry in another table. I've tried to arrange the table according to the ID row. This works great. Then the query to get the last entry woks as well, but to get the two to work together and update the table is a...

    GPNel200675 pointsBadges:
  • Query Many Tables

    I want to run a query on many tables. The answer I am asking is "How many 1s, 2s, and 3s are in all the tables together?" Each semester we get information on standards. How well a student completed a standard - a 1 is the lowest 3 is high proficiency.  The problem is this when I set up the query I...

    ManyJobs5 pointsBadges:
  • Even/Odd Numbers

    Can you query for even or odd numbers only?

    RollTide5 pointsBadges:
  • Using Query on 4 different files

    Hi i have four different files each containing a Customer name ,number and sales amounts ,each file is for a different quarter of the year ,i would like to join the four files so that i can produce a report which lists across the page by quarter the sales for each customer,however not all the...

    ZETA5 pointsBadges:
  • AS/400 BPCS Query Training Manual

    I am looking for a complete (digital) training manual to make queries in BPCS. Can someone provide me with this? Thank you very much! Rgds, D    

    David4045 pointsBadges:
  • Julian to Gregorian Date Conv. in DB2 Web Query

    I have a julian dates stored in the format YYDDD numeric, 5 positions, zero decimal. How do I convert to a true Gregorian date in DB2 Web Query for iSeries?

    Screechtx0 pointsBadges:
  • Difference between QM Query and traditional query

    When both a QM Query and a traditional Query are run against a database file with IDENTICAL record selection, the traditional query returns more records. I can only guess that it has to do with a difference in the way each utility handles uncommitted data. It almost looks as if traditional Query...

    slateken230 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