Absoulty fantastic!

Mine ended up looking like this mess because I'm calculating a bunch of sales numbers first but your solution works flawlessly.

Thank you.

SELECT dbo.corda_main.salesman,

...

I'm sorry but I'm not following you.

I had a table with values for goals (stored with datatype [money]) and was dividing the sum of the values in other tables (stored with datatype [money]) by the value...

I'm going to use FLOAT. I've found out that doing division on MONEY gives incorrect results.

How do I update from one table to another matching on PrimaryKey?

There has got to be an easier way. I can do this in FileMaker by clicking a box on import.

Make sure the .mdf files are not read only.

Works like a charm. Thank you. Thank you. Wow there is so much to learn about SQL.

That's what I have done. 0 to 499 in one and 500 to 999 in another. It's ugly but it works. =)

I wish it where that simple.

Well 991 columns will work just fine. Strangely enough I don't have this problem using [int] NULL as a datatype. As far as I can tell [money] NULL is using...

The problem I had was that I am importing from an external source using flat files. Our external source stores entries with no date as 00-XXX-00. The 00-XXX-00 values would...

How can I import the date into the table and store it in a different format if I use datetime as the datatype?

I figured it out. My previous table had the date field set as varchar(255) and my current date field is set to datetime, changed it to varchar(255) and the dates...

That can't be right because even if I use:

SELECT CONVERT(CHAR(50), GETDATE(), 101)

->07/17/2006