Code suggested was based on AdventureWorks database. OrderID is an identity column, therefore (and I checked) the maximum OrderID is associated with the latest order for each customer.

I looked...

First, are you applying both transaction log backups after you restore the full backup? Second, if you are restoring to the point in time of the second transaction log...

How about this:

select

CustomerID,

max(SalesOrderID)

from

Sales.SalesOrderHeader

group by

CustomerID

order by

CustomerID

😎

You could still convert to a string, use format code 112 instead of 101. It will give your date in yyyymmdd format, and will sort as you expect.

This will...

It would help if you could provide some test data, the DDL for the table(s), and the expected results. Just looking at the code, its hare to tell what...

Per processor licensing is also valid if you have a large internal user community that is accessing your database. If you purchased SQL Server 2000 or SQL Server 2005...

You are confusing the the names in the call below with the names of your parameters in the stored procedure definition. they are not the same.

exec mailsecurity @dbname,@emp,NULL,Admin output

exec...

Procedure mailsecurity is expecting 4 parameters, inthe following order:

@dbname, @name, @emp, @admin-2 (output)

Your call in PRC_GET_EMAIL_ADDRESS is only sending 3 parameters mapped to the expected parameters as follows:

@name to @dbname,...

In your second call with only two parameters, the second variable is mapped to the second variable in the stored procedure. If you are going to execute the stored...

I'm at a loss right now. I was hoping you were running x64 since, as far as I know, MS hasn't released 64 bit drivers for Access as of...

What version of SQL 2005 (x32 or x64)?

Simple recovery model, the transaction log is truncated when the data is checkpointed. In full recovery model, the transaction log is only truncated when a transaction log backup is...

It "Depends". What type of backup and what recovery model is the database using?

A full backup and differential backup do not truncate the transaction log. Enough of the...

I'm glad to have been of assistance, even though all I did was point you to Jeff's article. Be sure to post a thank you to Jeff as well...

Here is what would really help, provide us with the DDL for the tables, some sample data for the tables, and your expected results based on the sample data.

Jeff Moden...