There are a lot of good books out there. I'd hit Borders to start with and just start looking at them. I'll put together a list of books...

You may also want to read this article: http://www.sqlservercentral.com/articles/Best+Practices/61537/

It would help if you posted your code, provided the DDL for the tables involved, and some sample data.

😎

Also, it would help if you could provide the DDL for the tables and some sample data. This would allow us to test what we come up with.

This article...

I think I may see the problem. Here is the code as I have reformatted it;

SELECT TOP 100 PERCENT

dbo.CheckingAccountTransaction.CheckingAccountTransactionId,

dbo.CheckingAccountTransaction.CheckingAccountId,

...

I think there is a problem with your code. It looks like in the posted code you may be missing a '(' in the first subquery in your select...

I didn't even catch the misspelling of Full Text Indexes until I started reading these posts.

😎

I would also recommend buying a book on SSIS. Wroks has a very good book that would be helpful: Profession SQL Server Integration Services 2005 (I hope I got...

Try this:

create table #TestTable (

ItemID int,

StatusDate datetime,

Status varchar(6),

Description varchar(25)

)

insert into #TestTable (

...

He's Sergiy. Enough said about that.

Wrong because I use a correlated subquery or wrong because I didn't take into account you may have more than one order for a given day by a customer (I...

Sergiy,

I really don't care what you have to have to say. I am fully aware of all the things you mentioned, I worked for 11 years with a company...

To do it where OrderID may not be the max based on orderdate, this would work. It does not take into account if two orders are entered on the...

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

😎