This article should be a must read. It doesn't apply to this post, but in the future you may ask for help where it does:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

😎

K Currie, You should read this article: http://www.sqlservercentral.com/articles/Best+Practices/61537/. It will help when asking for help as people can test their suggestions prior to posting them.

😎

Bob, EXCEPT and INTERSECT won't work here (if the post is in the correct forum) as this is SQL Server 7, 2000. EXCEPT and INTERSECT are new to SQL...

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...