If you check the code I posted, you'll see that I created a table, inserted some records, then added a column, and inserted additional records. I used the exact...

Elisabeth Rédei (11/3/2008)

---

Hi,

If you want a default value; use a Default getdate(), it you want to enforce a NOT NULL constraint; add a CHECK constraint. Or both.

You can add the...

I think we need more information regarding the process involved and what the job is supposed to do, and how it does it. As you have a trigger starting...

To answer this question, you should compare the execution plans of the two two queries. You might be surprised to see that both are doing a clustered index or...

How true....

I can't answer your question, but I did a test (code follows), and when I added the DateAdded column with a default, it was populated.

create table #Test(

...

I've been lurking on this topic, and I'd be interested in what the final outcome is also.

Not really. I need to know what are the data types of the columns referenced from each of the tables used in the query.

Please take a few minutes to...

Do a search on this site for Tally table. I think this will help you solve your problem.

Have to agree with steveb, use a default of getdate() fro the column.

Well, having the entire query is good, but we still need to know the data types of the columns since the problem you are having is a conversion problem.

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,'').