Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

StackOverflow_53575163

Language: Layout:
View schema
Absolute service time: 0,19 sec, absolute service time: 0,19 sec 
edit mode |  history  | discussion
Error(s), warning(s):
'CREATE FUNCTION' must be the first statement in a query batch.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near 'returns'.
Must declare the scalar variable "@root_id".
Incorrect syntax near ')'.
A RETURN statement with a return value cannot be used in this context.
'f_total_listings' is not a recognized built-in function name.