collect form name for xform

Please login or create account to add a snippet.

Follow @TagMyCode

Language: SQL

Posted by: Trần Hải Quân

Added: May 14, 2013 7:00 AM

Modified: Jun 13, 2013 2:59 AM

Tags: episerver sql

SELECT R01.pkId ,
R01.String07 AS MailSubject ,
SUBSTRING(R01.String07, CHARINDEX('"', R01.String07) + 1, LEN(R01.String07) - 10 - CHARINDEX('"', R01.String07)) AS NewFormName
INTO #tmp
FROM dbo.tblSystemBigTable AS R01
-- INNER JOIN dbo.tblBigTableIdentity AS [Identity] ON R01.pkId = [Identity].pkId
WHERE ( R01.StoreName = 'XForms' ) AND ( R01.Row = 1 )
UPDATE t
SET t.String05=#tmp.NewFormName
FROM #tmp INNER JOIN dbo.tblSystemBigTable t ON #tmp.pkId = t.pkId
DROP TABLE #tmp