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

Raghavendra Mudugal (8/19/2014)

---

hmm, say you have a form of 10 text boxes, you enter a sequence of numbers, one in each box, you knew the start, you knew the end,...

Steve

Yes, I was being facetious about F5! But if it's the number of rows you're worried about, it's very easy to modify my test harness. I'm sure the...