I got it right for the most horribly wrong reason. I'm still not familiar with some of the assumptions made in declarations.
I assumed this:
INSERT INTO #DATA VALUES('1 jan 2010 10:30')
Would error, since it didn't have a declared column list and there were two columns, and thus answered 0.
I have a date with the basics, it would seem. Apparently a very good question. :hehe:
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]