Hi,

I receive a flat file that contains, among other info, a value for date.
This value is 10 char. long and a sample of what it could look like is
(CCYY-MM-DD):

2007-4-12
2006-12-31
2007-4-1 
2006-12-5

As you can see, the MM & DD values do not contain a leading zero for sigle
digit MM/DD. I need to load this info into a table in the following format
(using the above sample values):

2007-04-12
2006-12-31
2007-04-01
2006-12-05

Any idea how this can be done? TIA.

Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
JOIN Question...
create a sp from query output
Combine records to calculate