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 dencom 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: mkw77
  • Content: Threads
  • Order by date
  1. mkw77

    How to find files that are older than 90 days

    Can anyone help please. I am trying to find files that are older than 90days in a directory and subsequent directory within. Anyone have any ideas how I might do this. I think I may need to use the find command along with touching a file which current date in some kind of ls loop. e.g...
  2. mkw77

    NESTED CASE Statement Question

    Hi, Can anyone help with my query. I have the following case statement. I am trying to set one variable, once I have set the first variable with the value, based on this value I want to set another variable. A kind of nested case I guess but not sure!! My query is:- SELECT placeref, mgearea...
  3. mkw77

    How to concatenate two character values in a table into one string

    I am using SQLSERVER 2005 Can anyone help to concatenate character values into one string where the Field1 has the same reference. Output from one of my tmp tables looks like this:- Field1 field2 32061350 Gas Works 32071470 Boiler Room 36010060 Boiler Room 36031890 Support Agency...

Part and Inventory Search

Back
Top