 |
| |
An error was encountered while trying to retreive the data: 'XML document could not be created because server memory is low. Use sp_xml_removedocument to release XML documents.
Could not find prepared statement with handle 0.
sp_xml_removedocument: The value supplied for parameter number 1 is invalid.
INSERT INTO #XModPagingData ([XModId])
SELECT t0.XModID FROM
(SELECT
DISTINCT xm.XModId, FormID
FROM
dbo.[KB_XMod_Modules] AS xm
WHERE xm.FormId = 5 AND xm.Approved = 1 AND (xm.DisplayDate <= 'Mar 13 2010 4:40PM') AND (xm.ExpiryDate > 'Mar 13 2010 4:40PM') ) As t0 INNER JOIN dbo.[KB_XMod_Modules] AS xm ON xm.xmodID = t0.xmodID WHERE 1 = 1
INSERT INTO #XModSortedPagingData ([XModId], Filler)
SELECT
xm.XModId, MIN(CAST(CAST(xi.[value] As nVarChar(4000)) As nvarchar))
FROM #XModPagingData AS t0
INNER JOIN dbo.[KB_XMod_Modules] AS xm ON t0.XModID = xm.XModID
LEFT OUTER JOIN dbo.[KB_XMod_Index] AS xi ON xi.XModID = xm.XModID AND xi.[key] = 'FunFact' AND xi.[mask] = 1
GROUP BY xm.XModID
ORDER BY
MIN(CAST(xi.[value] As nVarChar(4000))) ASC '
|
|
|
|
|
 |