Recent content by pflakes

I need to calculate the median value for two different columns. It is possible to do this all at once rather than calculate the median for the 1st, then the median for the 2nd? I'd like to simplify what I'm doing now if possible but haven't found a way to do it yet. I'm working in SQL 2005...

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...

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

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...

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