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

function used in cte

Language: Layout:
View schema
Absolute service time: 0,23 sec, absolute service time: 0,23 sec 
edit mode |  history  | discussion
Error(s), warning(s):
'CREATE FUNCTION' must be the first statement in a query batch.
Must declare the scalar variable "@datefrom".
Incorrect syntax near the keyword 'then'.
Incorrect syntax near the keyword 'then'.
A RETURN statement with a return value cannot be used in this context.
   task_id (No column name) early_end_date target_work_qty
1 286519 11 2018-08-24 16:00 192
2 286519 12 2018-08-24 16:00 192
3 286519 13 2018-08-24 16:00 192
4 286519 14 2018-08-24 16:00 192
5 286519 15 2018-08-24 16:00 192
6 286519 16 2018-08-24 16:00 192
7 286519 17 2018-08-24 16:00 192
8 286519 18 2018-08-24 16:00 192
9 286519 19 2018-08-24 16:00 192
10 286519 20 2018-08-24 16:00 192
11 286519 21 2018-08-24 16:00 192
12 286519 22 2018-08-24 16:00 192
13 286519 23 2018-08-24 16:00 192
14 286519 24 2018-08-24 16:00 192

    
                
λ
.NET NoSQL database for rapid development