...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)...
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...
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...
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)
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...
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...
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?
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.
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.
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...
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.
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...
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...
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...
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...
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...
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?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.