Thanks. I did what you said but what i'm trying to acomplish is to copy all table structure and objects from dbase(Tan) to dBase (Tany). Do I need to modify...

Thanks. I was able to fix the error and your suggestion was helpful.

Thanks again!

Good morning Lynn,

SSC had helped me in the past so I will never dismiss your credibility. The reason I said I will run your suggested query is because I'm still...

Thanks Wayne,

I'll keep you guys posted and sure do appreciate your efforts.

Hi Lynn,

I didn't dismiss your query. I will run it and let you know the outcome. I appreciate your effort.

Regards

Thanks Lynn,

But there is no column 'A' for active in the dbo.tablename, that is where my problem lies I need to write a new query refrencing this.

Thanks Lynn

Here is the an example of the end result:

Last name first name Status

Doe John ...

Also, I'm not allowed to update,alter any table in the master database from which the data is pulled. I hope you can help me.

Thanks for your response. I'm trying to make all the employees active in the output in flat file thereby writing a query to create a separate column with A as...

Thanks for your prompt response. I updated my question with what I'm trying to do. Here it is:

--==== daily query to pull data from database to flat file

SELECT

V_APPT_BASIC.PERSON_ID, V_APPT_BASIC.FIRST_NAME,...

I really do appreciate your help David... It's a primary key violation. Once i rewrite the query, if it bombs out again, I'll send you the error message.

Thanks again David..I lost the queries I wrote when my machine rebooted this morning. It would take me a little while to rewrite them and I'm entagled in other things...

Thanks David and Lynn..That's the thing I'm changing more than one column in that row. I may just insert a new record into the table instead of jumping through these...

I took off the IF before the EXISTS and still got an error message. Any guidance will be appreciated.

Ok, Thanks. I'll try it.