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 derfloh 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: *

  1. pflakes

    calculate multiple medians

    ...SELECT page_id, timestamp, measurement_a, measurement_b ROW_NUMBER() OVER(PARTITION BY page_id) ORDER BY measurement_a) AS RowNum, COUNT(*) OVER(PARTITION BY page_id) AS Cnt FROM statTable ) insert median_table SELECT page_id ,@starttime, slot_id, avg (measurement_a)...
  2. pflakes

    Database server not found

    We've recently begun using LMS 2.6. (Solaris) After getting up and running, we found we needed to increase the /opt/CSCOpx partition. That is the only change I can think of since the problem started. Now everytime I stop the daemons, I get the message below. I have run reinitdb.pl on Campus...
  3. pflakes

    Compare DTS Packages

    Recently I inherited a project from an employee who has left the company. Noone is aware of what this person was working on and we've discovered the DEV and Prod databases were not at all the same. After backing everything up, my DBA has compared and synch'ed up all the tables, views...
  4. pflakes

    Running stats for Last Month

    tommyboyau - Thanks for the help. I've worked it out with our developpers and we've got it up and running! We added an object called LAST MONTH which is defined as: DateAdd(m,-1,Convert(varchar(8),GetDate(),112))-Day(GetDate())+1 (SQL Server Database)
  5. pflakes

    Running stats for Last Month

    I'd like to run stats retrieving only Last Month's data using broadcast agent and run it on the first of the month. What I've come up with below works until January. In January 2006, it's going to look for December 2006. Is there some way to query for only last month's data? I'm struggling...
  6. pflakes

    FORALL & MERGE

    Is it possible to use a MERGE within the body of a FORALL statement? I'm trying to optimize a few things and replace some cursors with BULK COLLECT's. I need to maintain the merge statement due to the continual updates to the data. FORALL indx in rptid.FIRST.. rptid.LAST MERGE INTO...
  7. pflakes

    Delete to end of line

    That took care of the problem. Thanks for the help!
  8. pflakes

    Delete to end of line

    I'm working on a script in which I'm reading in a file, then searching for the first comma in each line - that I can do. What I want to do next is delete everything beginning with the comma to the end of the line. Is there a simple way to do this?
  9. pflakes

    Copy Table As

    Thank you for all the help - this works great. In our dev enviroment (which has much fewer records), the runtime dropped from 2+ minutes to 6 seconds. On prod this usually takes about 2 hours - I expect to see a dramatic difference there as well.
  10. pflakes

    Copy Table As

    By renaming this_monthrecords to last_monthrecords, won't the table this_monthrecords be gone? I do need to have that table. Data is loaded into it every 5 minutes.
  11. pflakes

    Copy Table As

    At the end of each month, I have a procedures which copies all the data from one table to another - I am currently doing this by using the following: DROP TABLE last_monthrecords CREATE TABLE last_monthrecords as select .... from this_monthrecords It works but because of the number of...
  12. pflakes

    DB Function - Interpreting ip addresses

    inet_aton converts the ip address - stored as a varchar to an integer --- 192.168.100.1 would be converted to some integer. You could convert the subnet mask as well, do some 'network math'. Then use inet-ntoa and convert it back to string so the address is readable again.
  13. pflakes

    DB Function - Interpreting ip addresses

    An example of an ip address is 192.168.100.1 For the project I'm working on, you need to understand ip addressing and subnet masks - I don't have just one issue I'm trying to tackle - which is why I'm trying to find either a built-in procedure or someone who's done work with addressing. At...
  14. pflakes

    DB Function - Interpreting ip addresses

    Mysql has a built-in function - inet_aton - which can interpret ip addresses and convert them to a numeric value. Is there any equivalent in Oracle? Or does anyone have any suggetions? Currently in our database we store each octet in a different column. I'd like to get away from this if...
  15. pflakes

    update using the sum of 2 records

    Thank you! After a little work to eliminate some nulls, it's working just as I'd hoped.
  16. pflakes

    update using the sum of 2 records

    The basic idea behind what I'm trying to do is -- update bits of 'reporta' by setting it to the sum of bits of 'reporta' and 'reportb' where the timestamps of reporta and reportb match. The bits of reportb should remain untouched. Here's what I'm trying - I understand why it's not working...
  17. pflakes

    Update multiple tables

    I have multiple tables with the same column and would like to update the value in all of them as efficiently as possible. I am writing this into a procedure but for ease of reading here's the idea behind what I would like. Is there a way to do something like this? update table1, table2...
  18. pflakes

    cwconfig - no response

    I have 2 servers running CiscoWorks. I'm using cwconfig to backup the configs to a file. On one server everything works fine. When I run the same command on the other server, cwconfig returns immediately and no action is taken. I can run cwconfig with any parameter: cwconfig -help cwconfig...
  19. pflakes

    OV 6.2 and Exceed 9.0

    Company policy is forcing everyone to upgrade to Exceed 9.0. We only have a handful of people using OV and the first of them have just had their Exceed upgraded. Now he is having problems with NNM. Has anyone used OV with Exceed 9.0? Did it work or were there problems?
  20. pflakes

    Advice on CiscoWorks as network management tool

    In the brief period of time I've worked with it, CW seems to always require patches. Recently some of our staff went to Cisco and had a tour. They don't even use CW in-house. They've written their own applcation. I think it says a lot when a vendor doesn't even use their own product...

Part and Inventory Search

Back
Top