Search results for query: *

Hello- I have a Sql server 8.0 database which the default database has been deleted. I need to figure out how to change the default database so I can connect and repair everything. I have seen information all over the place for more recent versions of SQL Server but not 8.0. Thank you in advance

I have a table with 1.2 billion rows. This table tracks a users transaction and which device it used to complete the transaction. Not all transactions give us the device id so we are trying to fill in the gaps with the correct device id by building a tables which has date ranges that each...

Ok, Oracle guy here looking for some help. I have a proc that I wrote to clean up some data. ALTER PROC maint_rows @id varchar AS BEGIN BEGIN TRAN delete maint_table where entityid = @id COMMIT TRAN END This compiles and runs but after it completes, the record is still there...

I am looking at an old Access App and am way in over my head I am getting the error The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. When I look at the module I see there is a report trying to open which calls a query. When I try to...

I have a Gupta/Team Developer application that fell into my lap. I am looking for training or tutorials that may help me get up to speed. Does anyone have any suggestions?

I have a partitioned table with about 500 million rows. We need to add am artificial key to the table. What would you think would be the fastest way? I know I can just do it in a cursor but I would think that would take forever. Any suggestions?

Quick question for you crystal experts. (I am a database guy, not a Crystal guy) I am using Crystal 8.5 to generate a letter to my customers. I am getting the data from a SQL Server procedure. When I run the procedure, it returns 7 rows. The crystal report only generates to letters. I also...

OK, Ive been staring at this one for an hour and can't see where my screw up is. CREATE OR REPLACE FUNCTION DW.f_e164_dj (v_call varchar ) RETURN NUMBER IS v_COUNT NUMBER; v_1 varchar2(1); v_2 varchar2(2); v_3 varchar2(3); v_4 varchar2(4); v_e164code varchar2(10); v_short_code...

I am trying to create a fixed width file for another system to receive. I have it all written in SQL but when I run it the record truncates at 255 characters. Obviously I need to convert the output to some other type of datatype (text?) Can someone point me in the right direction? Thanks!

I am trying to insert into a partitioned table while specifying the partition name. The SQL looks like the following: v_partition := 'ERG_GMT_'||part.gmtmonthid; INSERT /*+ APPEND */ INTO dw.stg_erg_cdr partition (v_partition) ..... when this runs I get a partition does not exist error. I...

I have to update a partitioned table with about 80 million records. We have added a new column which has about 1250 different possible values. The value is derived by matching a substring of another field to a table. The substring can be either 1,2,3 or 4 characters in length so I have...

Im an Oracle guy looking for some help here. I have to go out to another server and FTP a file back to my UNIX box. I then use SQL*Loader to load the file into an Oracle table. Thats the easy part. The part that is messing me up is how to I find the files that I have not loaded yet? The file...

I need to write a script to help maintain indexes while doing our nightly ETL process. The following is what I came up with. I thought I would post it here for others to use and to be critiqued by some of my more experienced colleagues. A couple things to know. 1) I create a table called...

OK folks got another one for ya. I have been tuning an insert statement over a database link. The statement had a trigger that assigned a sequence to one of the columns and it took 40 minutes to run and then 9 minutes when I dropped the trigger. Now I need to add the sequence to my insert...

OK so I need to scheduler some procedures to run but Id like to run in multiple sessions. For example. I would like procedure A and procedure B run at the same time and run Procedure C once A and B complete. I know how to make procedure C wait for A and B to complete but how can I make...

I need some fuel for my fire here. Im at a site that is keeping their staging tables in a separate instance from their reporting tables on the same server. In their eyes, they are doing it for organizational purposes and don't think there are any performance impacts. The nightly processes...