Guys, did somebody mention this 😉 (valid only in SQL Server 2012):

-- Current date

DECLARE @d DATETIME = GETDATE();

SELECT FORMAT( @d, 'dd MMM yyyy', 'en-US' ) AS 'DateTime Result'

AFTER you pass XML into Stored Procedure. Plus XML native data type in SQL...

I would personally use XQuery - a first class citizen in T-SQL

IMHO loading XML documents is quite memory-hungry.

Cheers

IMHO this task would be better implemented in CLR UDF rather than in pure T-SQL.

CLR UDF easily allows to apply REGULAR EXPRESSIONS.

Just a thought.

Guys,

I must be missing a WOW factor here, but why do we need to re-invent the wheel?

The most ROBUST solution wiould be a SINGLE strongly typed XML parameter...