Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: noddy
  • Content: Threads
  • Order by date
  1. noddy

    How do I log new records to another SQL table

    I need to manage changes to several SQL tables, they can all go into a single or many log files. Is there a way to do this within the SQL environment? We are using an accounting system and the new reporting requirements are to report any changes to key tables. There is nothing in the software to...
    • noddy
    • Thread
    • Replies: 5
    • Forum: SQL
  2. noddy

    UNION not giving expected result

    I need to create a .csv file grouped by Account, Ccentre with 14 columns, OBAL, JAN, FEB, etc to CBAL. I have existing views to get the data into the individual parts, the following is for JAN: SELECT SUBSTRING(GL06001, 1, 4) AS Account, SUBSTRING(GL06001, 5, 4) AS Ccentre, GL06004 AS JAN...
    • noddy
    • Thread
    • Replies: 1
    • Forum: SQL
  3. noddy

    SQL View Syntax list web address

    Anyone know a web address where you can find the complete list of commands used in a MS SQL View?
    • noddy
    • Thread
    • Replies: 0
    • Forum: SQL
  4. noddy

    is there equiv of UNION_ALL in a View

    I need to add data from 2 tables, Country1 and Country2, the layout is exactly the same in both tables. In Access you can use the UNION_ALL (or UNION for a non-dup)but UNION is not supported in a View. The end result is using Crystal Reports to do the summation on a single table/view. Is...
    • noddy
    • Thread
    • Replies: 1
    • Forum: SQL

Part and Inventory Search

Back
Top Bottom