Awesome job Tom.

I however have a suggestion for all those articles with 15 different code snippets. Could you include a download link where we can get the whole thing...

Are you sure about that one? Like I tested it and in this case exists is faster than in?

That looks like an order system.

What I did in mine that really improved performance was to create the PK as an int, but I also kept the order id as...

Reread the question's explaination.

The first parameter in the isnull function determines what data type will be returned. Since one of the column is varchar(1), then when that column is...

check out the sum and count functions on books online (sql sever's help files).

SELECT COUNT(*) AS Total FROM dbo.TableName

SELECT SUM(Amount) AS GrandTotal FROM dbo.TableName

You might also want to check out...

Books online is a great place to start... but not knowing the types of calculations you want to do, I can't really point you in the right direction.

What do you...

Create table states...

Insert into dbo.states (Columns list) values ('whatever needs to be here')

Create master table

Insert into master table (Select Columns List, ForeignKey From States from table1)

...

Insert into master table (Select...

One last thing to consider... what will you do when someone asks you to write a report that picks a subset of the data in any of the states (determined...

There's only 1 answer to that problem. Test both solutions, see which one performs the best, them implement that one.

Like I said 500 000 records is not a lot...

I sent an e-mail too, but got no replies as well.

P.S.

I wouldn't want to be stuck either at picking a town from a list of 10 000 names in a combo or listbox. I think you'd be better of...

With propper indexing 500 000 records is nothing to sweat at.

I have a report that pulls that from 400 000 rows and the 400 pages report is made in less...

I've also seen this error where there's a mismatch in the datatypes.

Hey Jeff I found the problem with the test machine... it's just crappy.

I reran the test with 10 000 rows (100 times less data), and it still ran only...

Some of us have lifes outside of SQL Jeff, maybe he went to bed :hehe:.