Thanks Lynn

I was over thinking that one by a long way. And you came up with a result that is so simple.

Thanks Buddy

Andrew SQLDBA

That report is merely running queries against the database box. All this data can be easily queried once you write the code. You can then schedule that in a SQL...

I am not clear on what you are calling "Data Collection Reports" or "Data Collection Utility" I know a Data Collection Repository as a database.

If you could clarify what you...

I had no problem executing that query and seeing the result.

This is the what I copied from your post.

SELECT

'StaffCat, ' + 'EXCONUM, ' +'UNIT Number, ' +'Staffcount' ...

Gail

Thank you for the clarification. I learned something new. I was taking my judgement from my experience years ago with PL-SQL.

Hope that you have a good day.

Andrew SQLDBA

[SQL] is a language, not an application or database server. [SQL Server] as with all other relational and non-relational databases systems use [SQL] as the language that is used to...

You will have to post that on an Oracle forum, this is a SQL Server forum. SQL and Oracle do not play well together.

Another thing, What are you doing allowing...

I always create them first, one to be able to set the directories where I want. I know.... I could do it all on the restore, just the way I...

You did not mention these are on you own network. So there will most likely not be a domain. I was giving you info on how to copy the file...

The most simple way would be a backup and restore. I am assuming the two boxes are on the same network, or in the same domain. Create a full backup,...

Thanks Gila

Greatly appreciate your time. You always have the answer to my odd type questions.

Andrew SQLDBA

You can use a LEFT JOIN, or MERGE. Either should be able to insert only the rows that are missing.

This is rather short since you did not provide DDL and...

Have you checked the package? Did something happen to the return variables that you set up? It also sounds like something has changed in the table, or you are getting...

Yes, I have already done all of that. I did choose a time with the least amount of connections. There is one that comes from a java source that is...

There are so many things that could be causing this issue. One, there is no Upgrade from one version of SQL to the next. Not sure what you did there....