USEFUL SITES :
Write for Us
Error Message: Msg 2377, Level 16, State 1, Line 4 %sResult of '%ls' expression is statically 'empty'
Severity level: 16.
Description: This error message appears when in an Xquery the result of a for expression is statically empty.
Consequences: The T-SQL statement can be parsed, but causes the error at runtime.
Resolution: Errors of the Severity level 16 are generated by the user and are corrigible by the user. The statement cannot be run this way. The result of a for expression must contain 1 static member at least.
Versions: This error message was introduced with SQL Server 2005.
Example(s): DECLARE @xml xml; SET @xml = ''; SELECT @xml.query('for $a in(1, 2, 3), $b in (2, 3, 4), $c in () where $a lt $b return sum($a + $b)') as XML;
Remarks: In the above example we try to specify the for expression $c in (). This expression does not contain any static member and this raises the error.