• 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:
  • Need help with SQL commands

    hye there i need some guidance on sql command. i accidently update all data in 1 table to be as one data only. may i know how i want to revert back to the previous data. or at least what is the sql command to use to make the data in that table updated according to their own data by referring to...

    Calezz5 pointsBadges:
  • SQL Statement to update a table with set conditions on another table

    Hi, Can anyone help me? I am trying to update a second table with criteria in its own and another table being set. This is what I have come up with and various others. It should give an idea of what I am trying to do. UPDATE Clientextradetails LEFT JOIN Clients ON Clients.ClientRef =...

    Eddata5 pointsBadges:
  • Define array in Oracle

    i have coulumb stn varchar2(100) , i want to split it to 4 columbs n1 varcha2(20)...n4 varchar2(20) ,depend on space eg: stn : John Adms Smith Zac n1 : John n2 : Adms n3 : Smith n4 : Zac i use oracle8.0.5 developer6

    Tota10 pointsBadges:
  • SQL divisions

    Hi All, I'm trying to make a calculation through SQL code but this is resulting in a 0. Example: declare @activities as integer declare @days as integer declare @media as float --my queries that extracts data and sets values to @days, @activities; in this case they return @activities=51 and...

    alessandro.panzetta9,725 pointsBadges:
  • Unable to use delete statement in SQLRPG

    Hi I want to use this query delete from abc a where rrn(a) between 1 and 10 in an sqlrpg prog.I was getting error messages saying rrn keyword not allowed.Am not sure how to execute this in an embeddd sql program.

    0 pointsBadges:
  • can you help on this query?

    I am new to sql and cannot work out the query for this: >>>List the films in which 'Harrison Ford' has appeared <<< movie(id, title, yr, score, votes, director) actor(id, name) casting(movieid, actorid, ord) The whole exercises can be found on http://sqlzoo.net/3.htm thanks in...

    Cateye5 pointsBadges:
  • MS Access 2003 write in SQL query to convert string to numeric

    How do I write in SQL code in MS Access 2003 to create a query that converts a string into a numeric? Thanks

    SacramentoSil25 pointsBadges:
  • Need SQL query

    I have two tables DETAIL and USER. Detail table have two columns (projectid and projectdetail). Projectid is a primary key in DETAIL table. USER table have two columns (projectid and Userid). User table is like more than one userid can be under each projectid, one user can access more than one...

    Minuvinu35 pointsBadges:
  • Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

    I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as...

    Warykat20 pointsBadges:
  • COPY data between to files with SQL in iSeries

    hi, i need help with this: i have two files in Iseries one of them is new and other have old records and i pretend with sql copy some records. But file 1(new) and file 2(old) they don't have same collums file1 file2 fielda fielda fieldb fieldb fieldc filedd fieldd how can i make the correspond...

    BUG68235 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