I am looking for the same thing but I think we can use only a Visio diagram as an image in SSRS report.

Thanks for the article, Andy. I have a project that needs to read the XML file and load it into JDE tables. In my SSIS package, I loaded the XML...

The other simple way is:

SELECT RIGHT(CONVERT(VARCHAR(11), GETDATE(), 106), 8)

This will give you the same format.