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!

Search results for query: *

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

    Help with Perl script - parse file - rcp results

    I would like to parse the contents of a text file. This text file is built from a sql query. /text_file.txt Contents of text_file.txt would be: 0123456789YYYYMMDDHHMMSS 0123456789YYYYMMDDHHMMSS 0123456789YYYYMMDDHHMMSS each line will have a unique 'YYYYMMDDHHMMSS' I will need to append...
  2. limester

    Feeding input using a text file - reposted from Sun Solaris Forum

    Hi, I orginally posted in Sun Solaris (apologies, now reposting in UNIX Scripting) Would like to use /bin/sh *nix version FreeBSD I would like to parse the contents of a text file. This text file is built from a sql query. /text_file.txt Contents of text_file.txt would be...
  3. limester

    Feeding input using a text file

    Hello! I command in a script that I would like to run against the contents of a text file by adding to the script. This text file just one entry for each line, so the script would parse this: line1 line2 line3 .....etc Any help would be greatly apprecited!
  4. limester

    Help creating a shell script

    Hello, I am new to scripting on Solaris. I need to create and run a shell script that will take some input and then perform the commands in the shell script, for example: #./shellscript.sh input contents of the script: rcp -p input user@host1:input rsh -l user host1 "chmod 755 input" So...
  5. limester

    Query to compare results from a sql server 7 from a sql server 2005

    I am trying to do a query comparison between a sql server v7 and a sql server 2005 and output the results in sql analyser. The db schema is the same between both servers, they reside on different machines, but are on the same physical network and subnet. I am not sure that sql server 7...
  6. limester

    SELECT SUM causes error

    Hi There, When trying to run a query: select sum(col1) from table I get the following error: Server: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type int. Is there anyway to avoid this to get the results I need? Thanks!
  7. limester

    very newbie question ls -l output

    Hi, If I have output from ls -l: drwxr-xr-x 2 root system 512 Sep 12 09:55 12sept drwxr-xr-x 2 root system 512 Sep 14 13:39 14sept what does the 2 mean in second column? there are different numbers that are possible as well, tried the man page but no luck. Thanks!
  8. limester

    SQLDMO vbscript question

    Hi, I have a vbscript that uses SQLDMO and an input file to perform a query on the sql database and return the results to a msgbox. To create the connection I use: Set objServer = ("SQLDMO.SQLServer2") and login with the current user account: objServer.LoginSecure = True objServer.Connect...
  9. limester

    Stripping unwanted characters from a sql select query

    Hi, I have searched this forum, but I am finding it difficult to locate exactly what I am trying to do. I have a select statement, I would like to strip some of the output of the query, for example, if I get the result 'something' but I only want to show 'some' in the query result. How can...
  10. limester

    Straight copy of one record to another same table and column

    Hi, Can someone tell me the way to do a straight copy of a record as an update without using a select statement ? I tried update table set column.field where field2 = 'value1' and field2 = 'value2' Thanks!
  11. limester

    Help with a query

    I am trying to query a database where I have tbl1 I would like to count tbl1 and then return the distinct rows of clm1 tbl1. For example, I have 10,000 entries in tbl1. clm1 represents a state so the output I am looking for is: 2,000 OH 4,000 CA 4,000 FL Thanks!
  12. limester

    VBscript to restart multiple processes

    Hi, I have a script that will successfully restart a single process but I need to restart 3 and strService3 is the parent so this one has to be stopped last. Option Explicit Dim objWMIService, objItem, objService Dim colListOfServices, strComputer, strService1, strService2, strService3...
  13. limester

    Need help obtaining a date in a query

    Hi, I have a date column and I am trying to build a query that will give me the dates > 48 hours ago (in the past). For example using todays date 2006.10.05 and time 23:00 I would be looking for the dates prior to 2006.10.03 and time 23:00. Your help is greatly appreciated! Thanks!
  14. limester

    would like to avoid cursor, please help

    Hi, I need to query a database for a recordset and insert this into another database row-by-row. For each record I want to provide a time of insert, but for each insert this time has to be incremented by 1, the time format is HH:MM:SS.0000 so for each inserted record the last decimal point...
  15. limester

    Error when trying to copy columns using stored procedure

    Hi, I am using Sybase v11.x. I am trying to copy from one column to another column in a stored procedure as follows: UPDATE tbl1 SET column1 = (select column2 from tbl2 where @variable = variable) WHERE @parameter = parameter Everything is declared approriately. The problem seems to be the...
  16. limester

    Formatted Query Result?

    Hi, I am trying to return a formatted query result. For example: SELECT * FROM TBL1 This will give me a string of text that I would like to format with carriage returns and semi colons. Any help is greatly appreciated!
  17. limester

    How to format query output

    Hi, I have a column where data is seperated by a delimiter, in this case a '\' I am looking for a way to format the output of a query so that I can seperate the data held between the delimiter, for example, if I have the column: aaa\bbbb\cccccc\dddddd\eeeeeeee I would like to format it as...
  18. limester

    Stored Procedure Help.

    I am looking to create a stored procedure that will populate a text box depending on the result of a field. The field has many values and for each one it will require different text. To query for the field I will need to join another table: table1.field1 where table1.field2=table2.field2 If...
  19. limester

    Having problem with DATEDIFF

    Hi, I am trying to calculate a persons age using DATEDIFF. I have a column birthdate (ANSII format yyyy.mm.dd). This is my query that is failing: select datediff('year', birthdate, now()) from table1 where table1.column1 = 'value' Can anyone help me modify this to get the age (in years)...
  20. limester

    Data Import into Cell comment from text file import/query?

    Hi All, I have many text files that contain data from many workstations that I would like to Import into Excel as a cell comment due to its long worded format. I have prepared a directory called 'workstations' within this directory I created a batch that would connect to all workstations...

Part and Inventory Search

Back
Top