SELECT content_title , — Get Start Date And Time – Start LEFT(REPLACE(REPLACE(CAST(content_html AS VARCHAR(250)), LEFT(CAST(content_html AS VARCHAR(250)), 116), ”), substring(REPLACE(CAST(content_html AS VARCHAR(250)), LEFT(CAST(content_html AS VARCHAR(250)), 116), ”), patindex(‘%</StartTime>%’, REPLACE(CAST(content_html AS VARCHAR(250)), LEFT(CAST(content_html AS VARCHAR(250)), 116), ”)), DATALENGTH(REPLACE(CAST(content_html AS VARCHAR(250)), LEFT(CAST(content_html AS VARCHAR(250)), 116), ”))), ”), 10) AS StartDate ,RIGHT(REPLACE(REPLACE(CAST(content_html AS…