Convert HEX values into Actual data in SQL SERVER : -

First create a table, you can create a temp table.

 Step 1.
CREATE TABLE #hex(
[hex_Value] [varbinary](max) NULL
)

Step 2.
Insert data into the table, Example
insert into #hex values(0x300008000F000000030000020015001B00536976754D79736F7265)

Step 3.
SELECT LTRIM(RTRIM(CONVERT(VARCHAR(max),REPLACE(hex_Value, 0x00, 0x20))))
FROM #hex

check the final result after converting the HEX values into actual format.