As long as it's fixed now... Happy to almost help .

Can you post some sample data, the current results and the expected results. It will be hard to help you without that.

From the top of my head : Insert OFF HOURS in small batches of 500/1000 reports at the time... Should be done before the next day

Please do not cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=194708

I'm not expert in that domain... I'll let the others DBAs finish this one.

Surely possible but I will strongly advise against that. What re you trying to do exactly?

Can you post the expected output... I'm not sure I understand the question?

Good thing you tested those results Noeld .

Actually I think you'd be better off buying a book that shows you just that... Maybe someone knows a good ms access book that has some normalized designs??

Create table [cnetinfov3.2]

(

a varchar(10) not null

)

Select * from dbo.[cnetinfov3.2]

DROP TABLE [cnetinfov3.2]

Can you post the actual query with the table definition? There's a number of things that can be causing this error, which is self explaining btw.

Also you should always...

I can't imagine a situation where it is usefull to store incomplete (wrong) data. Do you have cases where the person doesn't know its DOB, or forgot the year??

The...

This could be the 2nd of a very long series of articles (doesn't have to be all of your little mishaps). Maybe we should start another discussion forum for...

ORDER BY 1 is not gonna be supported in Yukon... just to make sure you knew about this .

ok, My solution would be useless in this case, it was made to handle large files count, but since you have only 2 files to check you obviously don't need...