How about:

SELECT MAX(Datefield) as MostRecentDate, CategoryID

FROM Table

GROUP BY CategoryID

Or, did I miss something?

Also, why is a 10 GB log file considered to be huge? If the database is 30GB, a log file of 10 GB is not uncommon in a high...

I really like this statement:

Surely in this case, an empty string means that they don't have a cell phone, NULL means you don't know whether they have or not.

Nothing means...

I copied and pasted your code into SQL 2005. It worked fine.

Try this. Add the square brackets [] around all of your field names. See what happens

If you can't get to the original code, here are a few things to consider:

1. If this is a third-party app, you may be violating the licensing agreement.

2. Do...

Can you post the original insert statement/procedure that performs the first insert?

It's probably will be something like:

INSERT INTO Table (field, field,...)

VALUES(x, y, ...)

If x = 91 and y = 3...

You said:

I want a new record that takes all the data from from the recently inserted record where idcontrato =2 and eicanalid =91. And then give this new record a...

A trigger certainly does not seem to be the best method to use to accomplish what needs to be done.

Are you sure they are missing?

If there is a clustered index on another field, and you simply are doing a "SELECT * FROM Table", then you may not see the...

An educuated guess is that a dependant resource is not configured properly.

Thank You for your response. 

Actually, I know the answers to these problems, but I should have explained in the initial post that I need as much "ammunition" as possible...

Having had to work with times and dates many times, I recommend that you use a datetime field. 

What data type would you use for the time portion? 

If you...

I came up with a better(???) solution.  I started a trace that included the text data as part of the trace and dumped it to a table.

I then created a...

I actually started to do this, working through each stored procedure starting with the first one.  I then realized that there are 1050 different procedures that would need to be modified.

Thanks again!

I have been doing that, but its the same problem as doing a search on the code.  Prone to errors, and painfully time consuming.

Thanks!