outputDate = DateSerial(CType("20" & Left(InputDate,2),Integer),CType(Mid(InputDate,3,2),Integer),CType(Mid(InputDate,5,2),Integer))
Assuming all the dates are after 2000. Otherwise, you'll need logic for that too.
Dig deeper on .NET Development for SQL Server
Related Q&A from Greg Low
Copying stored procedures between databases on the same SQL Server 2005 can be done through scripting the stored procedures with this method.continue reading
Find how to save stored procedure output to the network drive via SQL Server Management Studio.continue reading
If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.