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!

  • Congratulations TouchToneTommy 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: edwardb15
  • Content: Threads
  • Order by date
  1. edwardb15

    SQL query using ? and *

    can anybody explain the below where clause: ORA-O*(600?|7445|4[0-9][0-9][0-9])[^0-9] i get the general idea of it but dont understand the ? after the 600 and the reason for the last [^0-9] outside of () . i know ^ means end of line. thanks.
  2. edwardb15

    using unix date command parameters on a variable

    i am trying to use the "date" options on a user defined date variable. is this possible? $ user_date=`date` $ echo $user_date Monday January 10 15:01:25 EST 2005 $ C_DATE=`$user_date +"%a %b %e "`
  3. edwardb15

    using variables and sed to find double spaced dates

    hi, i am trying to use sed to replace a single space in a date variable with a double space and then use that value to find all entries in a log file: num_day="8" C_HOUR="13" C_DATE='Wed Dec 8' C_DATE="`echo $C_DATE | /bin/sed -e 's/'${num_day}'/ '${num_day}'/'`" # replaces day number with...
  4. edwardb15

    error adding new job from sql server agent

    receiving the below error when trying to add a new job from sql server agent: SQL-DMO ODBC Sqlstate: 42S22 error 207: invalid column name 'category_id' invalid column name 'netsend_address' invalid column name 'last_netsend_date' invalid column name 'last_netsend_time'. the version is...
  5. edwardb15

    Problem Loading xml file into 2 tables within sql 2000 server

    i have 2 tables: Cust( CustomerID int, CompanyName varchar(20), City varchar(20)) CustOrder (OrderID, CustomerID foreign key references Cust(CustomerID)) i am getting error when trying to load xml file: "no data was provided for column 'OrderId' on table 'CustOrder'." the xdr schema is...
  6. edwardb15

    loading an xml file with sp_xml_preparedocument

    i'm trying to use openxml to insert xml data to a table. is it possible to load an xml file with sp_xml_preparedocument, i.e. specify a path and filename c:\tmp\new_xml.txt that contains xml data.
  7. edwardb15

    inserting a carriage return to a text file from a unix shell script

    i am writing a bourne shell script to append to each line in a text file a return character (new line) then followed by 'go' using: #!/bin/sh cat ${format_file_name}.out | /bin/sed -e 's/$/^Mgo/g' > junk.lst example of row in file ${format_file_name}.out: table1 table2 table3 using <ctrl...

Part and Inventory Search

Back
Top