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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by OMJ

  1. OMJ

    SQL*PLUS - no rows returned on one laptop, 67k+ rows returned on anoth

    How / where do I check those 4 variables? Where would the values be stored?
  2. OMJ

    SQL*PLUS - no rows returned on one laptop, 67k+ rows returned on anoth

    Hi, I'm having an issue where a user has been using SQL*PLUS to query a SID on an Oracle Database Server 11g Release 1. They have a read-only SQL account to run the query, which returns 67,000+ rows when they run it on their old laptop, but 0 rows when they run it on their current laptop...
  3. OMJ

    WSS 3

    Hi, I'm trying to find out how to determine whether a server has a MOSS 2007 WFE installation on it based off the running processes or services. It seems relatively simple to run PsTools query on a server's processes/services to find out whether any WSS 3.0 services are running, but given...
  4. OMJ

    Command Prompt query (Extracting Day Number, Month Number etc)

    Hi, I've got a command prompt batch script which extracts the day of week, day number, month number, year, hour and seconds. Unfortunately, whilst it does work, it gets the day number and month number confused when ran with US regional settings - and it needs to work in both UK and US settings...
  5. OMJ

    Moving folders/directories using a *.bat batch script file...

    I've made some progress with this, in terms of automating the process which works out which folders are needing to be moved and which don't (not written in a batch script). I'm now at a point where I've got a CSV file which has all the folders which need moving in. But I'm unsure how to...
  6. OMJ

    Moving folders/directories using a *.bat batch script file...

    I'm unsure if this is the right forum so please let me know where to post this if this is the wrong place. My problem is this: I have about 2500+ folders located in a directory "C:\Projects", in a folder structure of "C:\Projects\0", "C:\Projects\100", "C:\Projects\200" and so on up to...
  7. OMJ

    Importing external data into Excel using VBA

    Just wanted to say thanks guys! Have managed to, thanks to your help, solve this one the other day! :-D
  8. OMJ

    Importing external data into Excel using VBA

    I wasn't able to record it manually as macro. By the way I forgot to mention in my first post that the DB I'm connecting to is an Oracle DB if that makes any difference (sorry if that sounds stupid, am really new to all this).
  9. OMJ

    Importing external data into Excel using VBA

    Hi, I have successfully managed to connect to a database on a server, and NOT using the wizard I executed the below query in Microsoft Query then return the data to Excel. select * from projects where team = 'TEAM1' and startdate > to_date( '01-apr-2007 00:00:00', 'dd-mon-yyyy hh24:mi:ss' )...
See more

Part and Inventory Search

Back
Top