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...

HTH.

Whereas Celko seems to be more Standard oriented .

are all those files in the same directory??

are the list of files to check for all on the server, or easily transferable?