Thank You Greg,

That is perfect, I was looking thru the BOL, but had not come across this one. It worked perfect, gave me just the info that I need.

Thanks again

Andrew

Yes, the translog is growing, and the insert is going very slow. No triggers and no constraints on the table that the data is going in too.

Thanks

Andrew SQLDBA

Mine is currently set to 8192, the max that QA can have.

Thanks

Andrew SQLDBA

Thanks Darrell

That is a start.

Andrew

Thanks, I really appreciate it.

Have a good one

Andrew

Can you give me an example of the code that would create a 3 table join. The code that you sent me earlier worked great. I need to add one...

Thank You

That worked great. I now have another table to join in this one. I will work with it, to try and figure it out.

Thank You again

Have a good one

Andrew...

I have two different table variables, I am wanting to update one column in one table variable with the contents of the data in the second table variable.

I can select...

I cannot believe that, I have been sitting here way too long. Thanks for seeing that.

But hile I am here, Can I treat a table variable like a hard table?...

Just in general, I can take care of the ones that fall odd. Saturday is not a normal business day. Monday - friday is normal business days of teh week.

Thanks

Andrew...

Thanks,

Let me play around with that, putting in al this code that I have. I understand the logic, and greatly appreciate your assistance.

Andrew

SQLDBA

HI Jill

I think that I would find a different way to write that. And never, ever use a cursor in SQL. They take up way too must time and memory...

I would use BCP, it is the fastest way to read in a text file. Then i would recommend getting better equipment to be able to do what you need...

Thank you everyone. I checked out http://www.sqldts.com and that did the trick. Thanks again for the great advise on DTS. Please feel free to email me if you have...