Just as Dave said,

that's what is a main difference between any database system and a flat file/excel spreadsheet.

SQL Server, or any other DataBase Management System, does not guarantee the order...

that won't work the way you think, unless the database you are using is using case sensitive collation...you've got to...

your explanation is too abstract...you did not clearly define the matrix and the possible values(at least for me), nor the actual format of the data that will come from the...

here's the proc I use to create the trace I use; note that it creates a view at the end so I can also see the results easily.

this runs till...

i assume you have them stored in a varchar column instead of in a datetime column?

ideally, everything should be the datetime datatype...

can you rebuild the table, and set the column...

that's what is a main difference between any database system and a flat file/excel spreadsheet.

SQL server, or any other DataBase Management System, does not guarantee the order of the data...

Like Roshan said, the INSERTED virtual table makes both your triggers cleaner and easier to read;

note how your trigger would not work if multiple rows get inserted...it would only move...

it's the shortcut SQL uses for data types; integer divided by integer yields an integer result.

multiply either the numerator or denominator by 1.0 and you'll get your 0.17

your welcome!

it...

i have already done something very similar...this code may help out, or just complicate matters...

it's a huge stack of updates to a temp table, so I could review the old...

you error message is not related to your (max) string, it's related to a specific varchar/char column in the sql statement you built...

if a column has a definition of a...

ahh i see what you are after...i think you'll end up finding that all the DMV's get set to zero whenever the server is stopped and started, though right?

so...

i think the original poster wanted a different database, not necessarily a different server, right?

a simple trigger like:

CREATE TRIGGER TR_MyTrigger On SomeTable

FOR UPDATE

AS

BEGIN

UPDATE MyAlias

SET col1 = INSERTED.col1,

col2=INSERTED.col2

...

FROM INSERTED

INNER...

jabba (6/30/2009)

---

My understanding is that the server side teace will not be retrospective and so will not achieve what I am looking for. I go back to my original question....

not enough information to help you; you can see how long a command took with a trace or by setting SET STATISTICS TIME ON , but not an estimated time,...