Let's back up a bit and take this one step at a time. The 3 part update is a very complicated concept and trying to pull it off without...

Out of curiosity, what does this table with 900 fields hold? (Or maybe a better question would be what doesn't it hold)

I know you can use parameters in Excel (or at least you could in older versions, not sure about the newer ones), but I can't remember quite how to do...

I appreciate the effort, but unfortunately that isn't quite what I need. The concept of creating the table and the inserts are perfect, but I need that for starting...

Does this setting also take care of using DTS to import spreadsheets in situations where you have a column that looks like this:

A

___________

A

AB

ABCD

ABCDE

ABCDEF

Or maybe the same thing with numbers, don't...

Magy,

In your original, you're looking for values between '2006-01-01' AND '2007-11-15' for 2006. Is there some significance to that?

I haven't read the one Chris mentioned, but I would recommend these:

http://www.amazon.co.uk/Microsoft-Server-T-SQL-Fundamentals-PRO-Developer/dp/0735626014/ref=pd_sim_b_7

http://www.amazon.co.uk/Inside-Microsoft-SQL-Server-2008/dp/0735626030/ref=pd_sim_b_3

http://www.amazon.co.uk/Inside-Microsoft-Server-2008-Pro-Developer/dp/0735626022/ref=pd_sim_b_3

That said, all of the books we just linked target SQL Server 2008. Although the fundamentals books will...

Nice to see you too Lynn.

Things have been fine, I've just been really busy. Too busy working to post during the day, too busy playing CoD4 to post at...

Check the article in my signature about crosstabs/pivots. It explains how to make a crosstab query which will work in 2000.

Also, you might want to take a peek at...

As Vijay said, sample data / table structure is helpful for things like this. (See the article in my signature on providing sample data for tips on how to do...

No need to apologize, I wasn't trying to give you a hard time, merely noting it.

What you should basically have is something like this:

CREATE TABLE A(

Field1 int,

Field2 datetime,

...

)

CREATE TABLE B(

Field1...

Are most of the records 2's?

Run this:

SELECT IntRateCode, COUNT(*)

FROM yourtable

GROUP BY IntRateCode

Post the result.

This is still very ambiguous. The article in my signature titled 'How to Provide Sample Data' explains how to make this a lot more clear for us, but I'll...

Are you attempting to use a 3 part update on a table variable that includes a SUM?

You can't do that: as the error message says, you can't use aggregate functions...

From what I've read, SSRS 2008 will run off of a 2005 database.