Vakula, I am using an ODBC for my linked AS400 server.  Make sure you have the following covered:

1)  iSeries Access is installed on your SQL Server (these are the necessary...

Yes, I would like that.  I haven't really used cursors so I would love to see how its done.

Thanks

Ryan

Quick question - do your x's, y's, xx's, and yy's represent numbers?  I'm assuming they do based on your pivot's structure.

If by chance you litteraly are referring to character data,...

Prasad,

Based on your statement "...highly transactional intensive and I run queries that insert millions of records to a table by retrieving from multiple tables and this process is under a...

I think this may require a cursor and Dynamic SQL - neither of which I am very familiar with.

Here is a solution similar to another currently active thread:

select desc,

 SUM(CASE WHEN ID...

Michelle,

If you can, I would try a DTS pull from the AS400 to SQL.  We have had VERY good luck with that.

Ryan

Felipe, I have had a similar problem before.  Make a note of the current query path as it is now.  The next time it is not working, run it again. ...

Are the two tables the exact same size?  Or, are they significantly different?  If they are different, then the different executions times on the query could be expected behavior.

Also, is...

What driver are you using?  Is it the IBM DB2 UDB for iSeries OLEDB Provider driver?

Have you verified that your current IBM iSeries Access for Windows service pack is current and...

Great!  Thanks.  RH

Thanks Jim.  I just sent you the address. RH

Trigger, do you feel that the WHERE's should give you two different results?  If so, how?

Actually, I found what I needed.  Because DBCC INDEXDEFRAG is an online operation, I'm sure that it was is happening through the default maintenance plan.  DBCC DBREINDEX is an off-line...

Well - I guess it's a timing thing.  The problem cleared up about 10 to 15 minutes after a re-linked the server.  Maybe this would have cleared up over time...

Matt, maybe I am misunderstanding.  Your schema is roughly:

Dispatch (1) -->  Consignees (Many)

Dispatch (1) --> Shippers (Many)

Shippers and Consignees both have foreign key relationship of Dispatch.ID

Right?

If  sprecifically ID,City,State,PhoneNum from shippers...