• 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:
  • Server 2003 memory performance configuration

    We have a SQL application running in an n-tier environment. Some of the users are complaining about application performance. I am going through the environment looking at all of the elements involved in processing this application. The information below shows all of the server systems involved in...

    Labnuke9932,960 pointsBadges:
  • PL/SQL

    Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and strange it...

    Inprise610 pointsBadges:
  • Inserting 50000 rows using FORALL statement

    How can we insert 50000 rows by using FORALL,please give me entire code?

    Ramesh5530 pointsBadges:
  • How do I populate an SQL table created on the fly in RPGLE?

    I am writing a report program where I create a table that is then converted to an Excel spreadsheet using SQL2JXL. I am able to dynamically create a table with Execute Immediate but I have been unable to populate it. The problem is the table name is stored in a variable within the program and I...

    SteveFletcher80 pointsBadges:
  • How to get started in a SQL Environment

    I have been in an AS/400 world up until now. We are moving to SQL for a JDE EnterpriseOne implementation. What would be the best way for me to get up to speed on a SQL Server Database? Thank you for any and all insight.

    Kacerc65 pointsBadges:
  • ORA-03113: end-of-file on communication channel

    I am running a database health report which consists of many SQLs against the data dictionary. Every SQL returns fine except one querying for chained/ migrated rows which takes a little more time, and I get the following: ERROR at line 1: ORA-03113: end-of-file on communication channel I am running...

    OracleATE190 pointsBadges:
  • To retrieve records from SQL Server database

    Hello All, I have a requirement with sql server. Please find below the same. In database say we have a column named "Name" in a table. The records that are available in the table are say like Column_Name = Names Lean Metric Sequence Lean Operation Metric Lean Cleaning and so on.... Now, through...

    Pichha5 pointsBadges:
  • SQL+ running time error

    Can anyone let me know I have a problem to run SQL that after runing sql_build_tables.sql why c:\sql_build_tables.txt is empty (0 byt)- this use Win XP to run However, when I use Vista to run the SQL show Cannot create SPOOL file "c:\sql_build_tables.txt" as show below OBJECT_TYPE COUNT(*)...

    Kchang7474005 pointsBadges:
  • Limit number of rows in a table

    Dear all, I'd just like to ask if anyone can help me find a solution to the following problem: I want to limit the number of records in a table. So when all the available rows are used, the customer can purchase additional ones. Say for example that the customer is allowed to enter 100 sites. When...

    ElArZ15 pointsBadges:
  • SQL Server Query Help Needed

    I have a table with Inventory transacation records. The table contains both Shipment (outgoing) and Receiving (incoming) transactions. I'm trying to write a report that lists both Sales Orders that result in Shipment records and Purchase Orders that result in Receiving records. If I link the...

    Arlin70 pointsBadges:
  • How to find a string in all columns of a table

    I want to search for a string for example "POLARIS" in all the columns of a table ? How to find the string using sql query ?

    Dhumane5 pointsBadges:
  • Help on SQL Query

    Hi, I have a table which has customer order and date in the below format. customer order Date 1 1a 02/10/2008 19:48 1 1b 02/10/2008 18:48 1 1c 02/10/2008 17:48 1 1d 03/10/2008 19:48 2 2a 01/11/2008 01:30 2 2b 02/11/2008 01:30 2 2c 03/11/2008 03:45 2 2d 03/11/2008 03:50 3 3a 06/11/2008 03:50 3 3b...

    GIG240 pointsBadges:
  • Pulling multiple values in the same line in SQL

    Sorry if the title is a bit vague but its almost what am I trying to solve. The best way to explain my issue is this. If I have a table which takes the format.. user_id, error_code. (and other values also). The problem is that the same user_id is listed multiple times for each error_code the user...

    Boardpig90 pointsBadges:
  • Address segregation in SQL 2005

    I am working in SQL 2005 and would like to parse an address filed such as "1234 N CLARK ST APT 111 " into seperate fileds like House Number/Street Name/Street Type ie LN ,ST, or Cir/Apartment Number

    Dkrueger40 pointsBadges:
  • Embedded SQL over multiple physical file members

    Hi, I'm writing a program to process all the members in a physical file. I've done this using embedded SQL because the selection criteria is quite complex. The physical file belongs to an application which I can't change, so I will always have to deal with multiple members. I also don't have the...

    Gilly40023,730 pointsBadges:
  • error in connection between oracle8i&developer2000

    I'm installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I'm installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i...

    POWERINIT0 pointsBadges:
  • sqldumper

    is sqldumper caused by low memory in computer if not what is it caused by and how do i get rid of it

    Shortfuse455 pointsBadges:
  • SQL View- Adding a table from a different server.

    Can I add a table from another MSSQL Server on the network to an SQL view and how?

    DUmlaut5 pointsBadges:
  • SQL on SAN, 16 or 1

    A client has 16 databases, one per teritory, all running the same application and all on the same server and all the files on a SAN. The data in the 16 databases could all run in just one database. Will running all the activity through one database be faster than running it through 16? All the...

    Mjhessler0 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