Yes, your code appears to assume that the row that was inserted is the one with the maximum PAT_ACCOUNT_MANAGER_ID. Even if that column had an identity property, that would...

I would guess that you're using different network libraries on the two OSes and that's responsible for the difference. Different settings will be used depending on your network library,...

Please will you post the CREATE TABLE and CREATE TRIGGER statements for the table and trigger?

Thanks

John

OPENXML is one way of doing it. There are others.

John

I believe so, but there's only one way to find out for sure. Do you have a test server?

John

You can check for yourself.

SELECT TOP 100 *

FROM dbo. LoadMedicationsGP

It should work.

John

SELECT

Price

FROM

PHistory

WHERE

Product_Reference = 100014

AND

Change_Date = (

SELECT

MAX(Change_Date)

FROM

PHistory

WHERE

Product_Reference = 100014

AND

Change_Date < 20070906

)

Of course, you may get into trouble if the price changes more than once on the same date.

John

SELECT TABLE_SCHEMA + '.' + TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES

John

Some vendors are happy for you to do this; some aren't. At the very least, you should monitor performance and, where necessary, tweak the indexing or suggest changes to...

3312K still isn't huge - only 414 pages. But best advice is to make sure every table has a clustered index, with exceptions to that rule clearly documented. ...

Well, a page is 8KB, so it's easy to calculate.

For large tables, you want fragmentation to be as low as possible. If you rebuild all the indexes on such...

Usually, just counting the rows will give you a feel for whether the table is small. If you look at the table properties in SSMS and go to the...

What size are the tables that are still red? You don't really need to worry too much about fragmentation on small tables - let's say 1000 pages or less.

John

Try using SUBSTRING. There is a good resource here.

John

Eirikur

Good points there. Hence, my new improved version 2. I've padded out TimeDecimal with another two zeros (that deals with the small numbers), then converted to time and...