Hi, I've recently step into speed optimization issue that I can't go any futher for few days. I'm doing export from database (Microsoft Sql Server 2008) to file for 10k (or generally big number) records, in every record there is a date that should be formatted, unfortunately I'm getting this date as string, looking like this: "Feb 11 2009 1:44PM" because I decrypt value from database with CONVERT(NVARCHAR,DECRYPTBYKEY(...)). I wonder if there is faster way to check is string variable is really a date, or maybe I can check that in sql query or somewhere else. Anyway I'm stuck, nothing comes to my head. Cheers
