Think about what you have, and what you need.

By grouping both fields, you have all of the unique combinations of the category and activity for the date.

You table probably contains...

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!