Forgive me if you have a TRULY unique situation there and really do have to do what you're doing, but generally speaking I'd advise against what you're doing. Again GENERALLY...

I'm not 100% sure what you mean here - but I'm assuming the modelyear, make, series, VIC and bodystyle should be unique for any given VIN, should it? So grouping by them would be...

I too have gone through periods of working insane amounts, and I'm now in the position of having a family, and wanting a better life/work balance.

However, I think it's...

I haven't heard anyone saying this kind of stuff for a while now - make 'em do it the hard way - it's more educational. The last time was a Unix-fundamentalist...

The problem is that the 'myYear' field is a decimal type, and the YEAR() function gives an integer. If you'll only ever use a full year in the myYear field,...

In reply to Grasshopper "I'm not a regular at WTF, maybe I missed the point as to what they were poking fun at." I am a regular and sometimes the...

I think the comments on the WTF are missing the point mostly. There are very good reasons to look up dates in a table. I use it all the time...

It's not very clear what you're trying to do, but if you're aggregating data to get totals or just need to add a calculated week field into report data for...

OR....

More elegantly, you can have a function which parses the values, puts them in a table and returns the table, then you can do a single insert of that table...

Is this possible in reporting services? Or is this a 'normal' web page?

Personally, I've had so many problems with datetimes, both coding-wise and human error wise (I'm from the UK, and for those who don't know - 01/02/06 means 1st Feb 2006...