A the product lookup component you can pass through error rows (no product found) to a product destination table to create the product -> to a product lookup to get...

This is a nice feature introduced in SQL2008.

Here is how i got it!!!

select dateadd("d",'435365'-1250, cast (0 as datetime))

Hiren

Thought about answering True, because for me (in the UK) they will return the same value, but figured that the author was probably in the US so the answer was...

I thought the most active Forum Creators must have tested before putting it in the Question of the Day Section.

The Answer should be false. For those who reside in...

Completely agree to Kit!

Its always better to educate others with its pros and cons. Select * is advisable in certain scenarios but also harmful in some scenarios.

Good post although but practically not advisable!!!