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

What Jeff is trying to say here, is that we may help you there as well. We earn a living at doing that kind of stuff and we may...

Jeff is just that good at tuning :hehe:.

Well that's a 5-10 yo PC over VPN connection, running windows 2003 server and SQL 2005 + VS 2005. The problem is that there's only 512 mB of ram....