Search results for query: *

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

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?

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

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?

I'm writing a program which retrieves data from a 3rd party and inserts it into a sql database. The data provided has timestamps in GMT and I want to insert them with both the GMT time and Central time. I've got everything working right now but when happens when daylight savings ends...

As part of a procedure I've written, I'm querying a table, using the values to assemble a url and sending the url in an email. I've successfully concatenated the string I need for the url and it is being sent in the email. The problem I'm seeing in the body of the message is that the last 2...

Is there a simple way to truncate the current time to the minute using the getdate() function. I need to run a procedure every minute and make calculations on the previous minute -- ie. At 2:12 I need to calculate the values for >= 2:11 and < 2:12. getdate() is going to return something...

I'm currently working on a project where I'm running a procedure on an Oracle database and then need to insert the results into a MS SQL 2000 database. I've asked the DBA's to help out but they've never dealt with this either and it's really dragging my project down. If anyone has any...