Try this on for size and performance:
CREATE TABLE #Requested (
    Pkey Int,
    ParentId Int,
    [Status] Varchar(50),
    Datelogged DateTime
);
INSERT INTO #Requested
    (
    Pkey,
    ParentId,
    [Status],
    Datelogged
    )
    VALUES    (1, ...

Just sayin', but wouldn't the continued use of such a product create a dangerous dependency  that's probably worse than violation of naming standards or other needs that would normally dictate...

You probably need the value function for XML data on the end of the query, and possibly adding ,TYPE to the end of FOR XML PATH('').   I can't recall the...

That's easy to do using a string splitter, of which the best is at the end of the following article:

http://www.sqlservercentral.com/articles/72993/

Here's the code to do...