I figured out the error in the Lookup process (configure error output and set to Ignore errors for values not in the lookup table such as NULLS). However now I...

GOT IT!!!!

There was other data beside blank spaces in the field where the date was expected. Sometimes there was also a zero ("0"). That would make my formula (LEN(TRIM(datefield)))> 0...

UPDATE - COMPLETED!:-)

First thanks to everyone who replied to this thread it was extremely helpful.

The solution appeared to be in tags I was using. Apparently "ROOT" is not a good...

Here is an update... Still not resolved however.

I am getting results back with an embedded hierarchy in XML format. Now I am getting a compile error OR only the Header...

These are all great suggestions. I found this article on this site by Robert Pearl.

http://www.sqlservercentral.com/articles/Administration/2953/

He has included a script along with a really great description of our...

Yeh. I kinda figured that there may be a little catch with format that is specific such as Adobe Acrobat. But I am more interested in the SQL for inserting...

We got it all worked out. Thanks to everyone who replied to this post.

Please allow me to add something else to this...

The columns will not change. This is not an example where the productno is changing. I have 3 Productno(s) and will never...

Thanks Steve.

One other thing. The server itself... When I login via Remote Desktop and launch Enterprise Manager/ Query Analyzer, I can authenticate via windows authentication (don't know if this helps)....

Thanks for the info, but I am running ONLY 2000 and have NO linked servers either to or from this server. It is a pretty basic setup. So far, we...

Sorry... Previous posting eliminated entries in the path...

Between Microsoft SQL Server\ and MSSQLServer is the named instance.

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\instance name\MSSQLServer\Parameters]

Just a tidbit of info... The path to the registry entry mentioned above is for "default" instances. For named instances use:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\\MSSQLServer\Parameters]

Stop SQL Server,

Move master(mdf+ldf),

Change the above path,

Start sqlserver...

Thanks for the info. The traceing the trace on DBCC events worked perfectly and I discovered who the culprit was. Upon investigation, it was an excel spreadsheet with macros that...

Thanks "Old Hand" 🙂

I set up another trace with DBCC events as the traced operations and am gathering the workstation, sql user, NT user, etc...

Tested it with a DBCC...

Hi Jay. This is my first posting/ reply, so please be gentle if this doesn't work for you...

Here is what I do to eliminate duplicates. If you can use just...