Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

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

Search results for query: *

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

    Need help with date related query

    Hi, I have a query like: SELECT H.DocumentNumber, H.AssignedUser, L.AuthCode FROM AP.DocumentHeader H, AP.DocumentLine L WHERE H.UpdDate > current_date - 2 i.e. I need to return rows where UpdDate within last 2 days but getting error: SQL0401N The data types of the operands for the operation...
  2. ThisLad

    trying to copy data into a spreadsheet

    Hi, I'm trying to copy results of a SELECT statement from SQL Advantage into a spreadsheet but it's just pasting each row into a single cell. I know it'll work if I put tabs between the fields but there's over 20,000 rows. Is there any way I can put in tabs with the SELECT statement? Failing...

Part and Inventory Search

Back
Top