Here are the results of logging since yesterday.  I expect a SignalWaitTime rollover soon after about 4.3E9.  The timing interval is 10 minutes.  The jump from 29628864 to 3239083520 (37...

NOT IN is also bad.  Perhaps trying a left join and testing for null in the where clause would be faster than using not exists.  If there are a lot of columns...

Thanks.  It's nice to know it's not just me - this time. 

I also noticed that a DTS package I saved from a client with SP4 would not open or run...

The data displays when I use LEFT(col, 800).  I thought about special characters, but using LEFT on the same data enables it to display.  In any case, why would they be...

Can the process producing the file add the delimiters for the missing fields?  Otherwise, if the record length is always less than 8000, the data could be loaded into a...

1) If you have file backups, you can use those to restore each db.  2) You can also "attach" each database using the mdf and ldf files in the Data...

It does appear the order is fine.  I did not worry about order because this is just the start.  The actual document is much uglier - as is most of the...

Thanks for the clues.  It now works - amazing.  A lot of work.  I did not work out the "order by" yet.  -Randy

Final result:

SET NOCOUNT ON

SELECT RTRIM(a.AddressId) as...

Groan.  Thanks for the replies.  I was hoping for a simple life. 

I'm writing the XML to validate against the GJXDM (Global Justice XML Document Model).  It determines the sequence. ...

I sure would appreciate any help with this, even if it is to know that it can't be done with FOR XML EXPLICIT. 

Did you check the EventLogs on each system?  Maybe there is a network hardware or configuration problem. 

You can drag a shortcut to the taskbar's "Quick Lauch" toolbar.  I normally use that in the start menu.  Right click and drag the shortcut or program to the toolbar...

A trigger is a stored procedure like T-SQL that executes in response to inserts, updates, or deletes.  It is not related to keys or indexes. 

Every table should have a...

It's also not impossible that a developer, after testing, forgot to remove a "top" in a select statement or a SET ROWCOUNT statement. 

If you got no results, I would expect resource limitation, batch size, bad design, etc.  However, since you are getting an incorrect result, I would expect a data or logic...