Extracting query from it's parent, SQLServer

/*
Q. How can i extract indivual query from it's parent?
A. You can extract indivual query from it's parent by using offset values.
When reading the script below, please note that while ISO has a zero-based offset 
the SUBSTRING function has a one-based offset.
*/
SELECT
DB_NAME(SqlText.[dbid]) AS [Database Name],
SqlText.text AS [Parent Query],
SUBSTRING
(
    SqlText.text,
    (ExecQStats.statement_start_offset/2)+1,
    (
        (
            CASE 
                WHEN ExecQStats.statement_end_offset=-1 THEN LEN(CONVERT(NVARCHAR(MAX),SqlText.text)*2) 
                ELSE ExecQStats.statement_end_offset 
            END
        ) - ExecQStats.statement_start_offset
    )/2+1
) AS [Indiviual Query]
FROM sys.dm_exec_query_stats AS ExecQStats
CROSS APPLY sys.dm_exec_sql_text(ExecQStats.sql_handle) AS SqlText