Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+Query\s+Question\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+Query\s+Question\s*$/: 6 ]

Total 6 documents matching your query.

1. SQL Query Question (score: 1): Author: Michael Moore <Michael_Moore AT VFC DOT COM>; Date: Fri, 13 Sep 2002 14:31:15 -0400; Well, Since I got an answer to my previous answer, it helped so much, now I have an additional question(s). I am pretty new at using SQL queries, so please bare with me.. Here is what I want to do: I; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2002-09/msg00532.html (12,176 bytes)
2. Re: SQL Query Question (score: 1): Author: "Seay, Paul" <seay_pd AT NAPTHEON DOT COM>; Date: Fri, 13 Sep 2002 15:10:06 -0400; select entity as "Node Name ", cast(sum(bytes/1024/1024) as decimal(10,3)) as "Total MB", substr(cast(min(start_time) as char(26)),1,19) as "Date/Time ", cast(substr(cast(max(end_time)-min(start_time; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2002-09/msg00536.html (12,916 bytes)
3. sql query question (score: 1): Author: Palmadesso Jack <Jack.Palmadesso AT SWPC.SIEMENS DOT COM>; Date: Thu, 6 Jul 2000 10:53:32 -0400; I'd like to do something similar. I have a large query I'd like put into a file. How can one redirect the output to a file? I keep getting invalid SQL token | everytime I use the pipe symbol. Can I r; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2000-07/msg00126.html (10,166 bytes)
4. Re: sql query question (score: 1): Author: "Cook, Dwight E" <cookde AT BP DOT COM>; Date: Thu, 6 Jul 2000 10:39:16 -0500; Now you are probably talking about within a dsmc and not a dsmadmc ('cause it works under dsmadmc) so to do a dsmc and capture its output do something like... eval nohup dsmc q sched -pass=xxxpswd >t; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2000-07/msg00136.html (12,841 bytes)
5. SQL query question (score: 1): Author: Cindy Ousley <cousley AT AMSOUTH DOT COM>; Date: Tue, 18 Apr 2000 15:43:09 -0500; I enter the following select command and get this result. select nodename,msgno,date_time,message as "Elapsed time" from actlog where nodename like 'TN%BR%' and msgno=4964 and date_time between '2000; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2000-04/msg00856.html (11,350 bytes)
6. Re: SQL query question (score: 1): Author: Andy Raibeck <Andrew_Raibeck AT TIVOLI DOT COM>; Date: Tue, 18 Apr 2000 14:04:51 -0700; Hi Cindy, How about using the "right()" function around the "message" column (the rest of the statement is fine): select nodename, msgno, date_time, right(message, 9) as "Elapsed time" from actlog wh; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2000-04/msg00858.html (11,901 bytes)

Current List: 1 - 6
Page: [1]