Anyone can point to the reason why first is converted while second one fail?

SELECT TRY_CONVERT(DATE,'2016/10/05')

:w00t:

SELECT TRY_CONVERT(DATE,'12/31/2010')

:hehe:

Naveen, a very good question. I played with this query and this is what I come up.

When you set @TrueValue = '' --- No space you get Null because there...

For People posting questions for QoTD, Please post questions assuming default schema.

Great example. I will definitely try to work your example tonite. Thanks for sharing it Vikas.

Can you provide some more information on this SSIS package, you are working on. Some of us can try to replicate it on our end.

Question: Is you different sheets in...

Hi Thanks for this great procedure. I try to learn as much as possible from you guys. My only question here is: If I have archive data base on a...