Why not use 2 derived tables and full join on the date?? That way you can always add more columns when needed. Maybe this is just me but...

The ONLY guarantee is to write them both for the insert and the select.

Precisely . I had my head hurt a long time over that one. I found out it was less trouble trying to...

Some compagnies have go live licenses (where the beta is used in production). I heard a number of ±40 licenses. The release date is November 7th 2K5.

In theory it would work... but you could lose object to object dependences. But if you're only after the table use then you're alright.

This is something that would be much easier to solve using a calendar table. Just fill a Tables with dates from 200? to 2020+ with a date column and...

He is right about that and rschaeferhig's tip is actually a best practice that you should follow all the time. However I don't really see how that could have...

Sure .

The Curse and Blessings of Dynamic SQL

Is the server using windows only authentication?

The order by can be benificial if you order in the table1 clustered index.

change to varchar(4) or like 'avi%'

The trigger will fire once for each update statement and update every line modified by the query.

I think that the answer will lie there. I doubt it's possible to cover 100% over the possible issues here but 99.99% may be possible

Just a taught... Could you keep the date (datetime so you have ms precision) of the insert instead and then maybe add an identity column so that you have a...

I like it too. As for Keneddy I wasn't born so that one's pretty easy for me. Who's gonna build the queries? How are they building them?