Okay, That's what happens when you make a guess in the dark. What is the data type oc ca.account_established_date? Actually, what are the data types for all the...

paul.starr (11/3/2008)

---

does this pl/sql equal this tsql, it is giving me errors when i run it.

PL/SQL

select /*+ RULE */

...

You could add a job step that deletes the file after it is processed. There is a problem with that option as well, the job will most likly fail...

Off hand, no. You could modify the procedures to use isnull: isnull(string1,'') + isnull(string2,'').

And then make sure you have periodic transaction log backups running to keep the transaction log from growing so big again.

I have gotten side tracked by work and other issues. From my analysis, it appears the each fiscal quarter follows the following pattern 4 weeks, 5 weeks, 4 weeks....

Seth,

Looks like you went the same direction I was look at as well, you just beat me to the post. I checked out your code, and it seems solid...

To be sure, we aren't talking about 60 minute blocks based on the first call for a given case, corret? That is why the 2:30 and 3:00 calls are...

It is hard to provide you with the code you need since you haven't provided us with anything to really help you. Read the article below, it will so...

Could you provide us with the DDL of the table, some sample data, and the expected results? For guidance, read the article mentioned below.

shnex (10/31/2008)

---

and if i have an index on 2 columns....

I can't find this anywhere...

I will come with other examples ...later,because now I need a break

I believe you and I will...

If you change msdb from simple to full recovery model, run a full backup. The transaction log backup of msdb will continue to fail until a full backup is...

I'm going to point you right back to BOL. I have written a few scripts to build some tables based on other tables and everything I needed to know...

The model and msdb databases use the simple recovery model by default. For model, a periodic full backup is all the may be necessary. For msdb, you can...

You can either start looking at SMO for ways to do this, or start researching the system views. Some of the tables are sys.tables, sys.columns. Start with these...