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 Mike Lewis 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: *

  1. richardmorrison

    Receiving error with UNION query - Unexpected EOF in SQL

    EOF - is end of file. Sounds like you have run out of space somewhere. Could be a software error as the link to database library has been broken. general network error seems like a software/hardware error?????
  2. richardmorrison

    Automation of BCP

    Dear All, My intention is to provide my colleagues with information on a daily basis, in as many forms as possible. I was wondering if automation of BCP is possible to the extent of producing graphs/charts etc, or would the production of such charts and graphs have to be produced manually from...
  3. richardmorrison

    BCP HELP PLEASE - RAJEEVNANDANMISHRA

    I WAS WONDERINING IF YOU COULD GIVE ME AN EXAMPLE OF BCP STATEMENT BECAUSE I CAN'T FIND ONE THAT MAKES ANY SENSE. aLL i WANT TO DO IS SIMPLY PUT THE RESULTS OF A SQL STATEMENT INTO A TEXT FILE OR GRID OF SOME SORT.
  4. richardmorrison

    Output results

    I was wondering if anybody could clarify how to (if there is that is!) output SQL results into excel so that I can produce graphs, or any other spreadsheet package.
  5. richardmorrison

    Output SQL results

    I was wondering if anybody could clarify how to (if there is that is!) output SQL results into excel so that I can produce graphs, or any other spreadsheet package.
  6. richardmorrison

    SQL Date functions!!!!

    I'm still having problems with the date function, so I'm going to tell you a little more about what I'm doing. I'm interrogating a remote database(UNIX network) using DTS in SQL 7 server. Initially I imported the database locally in order to test and verify my SQL statements more efficiently...
  7. richardmorrison

    SQL Date functions!!!!

    I'm still having problems with the date function, so I'm going to tell you a little more about what I'm doing. I'm interrogating a remote database(UNIX network) using DTS in SQL 7 server. Initially I imported the database locally in order to test and verify my SQL statements more efficiently...
  8. richardmorrison

    query for yesterdays data ?

    select movement_date from st_history where movement_date < date() AND movement_date > date()-2 and warehouse = 'C1' Try using WHERE myDate < date() AND myDate > date()-2. the top one is what i have just tried - do i have to define &quot;mydate&quot; ?? - I'm fairly new to SQL so be gentle !
  9. richardmorrison

    query for yesterdays data ?

    I need to be able to have SQL query a database for all yesterdays data - the date () -1 doesn't do it and the getdate () -1 either ? I have seen some of the posts on here and know somebody must have come across this before ?

Part and Inventory Search

Back
Top