T-SQL & Xquery – changing literal value to use reference to none does not return result

I hope someone can help me: This column returns the value I require based on DTS:ObjectName=”vSQL_ASN” attribute within my xml: col.value(‘(//DTS:Variables/DTS:Variable[@DTS:ObjectName=**”vSQL_ASN”**]/DTS:VariableValue)[1]’, ‘VARCHAR(MAX)’) However when I replace ‘vSQL_ASN’ to use a look up from another xpath query that i know evaluates exactly to ‘v_SQl_ASN’ I get Null returned. col.value(‘(//DTS:Variables/DTS:Variable[@DTS:ObjectName = **substring((./properties/property[@name=”SelectStatement”])[1],9,string-length(substring((./properties/property[@name=”SelectStatement”])[1],8,50))-2)]/DTS:VariableValue**)[1]’, ‘VARCHAR(MAX)’) Can anyone please help…

Details

Nestjs Validation failed (numeric string is expected) inside controller’s nested route

I have a controller using @Controller(‘tasks’) decorator. Inside this controller, I have a route @Get(‘/week’), normally the request should go localhost:4000/tasks/week but it is returning a bad request: { “statusCode”: 400, “error”: “Bad Request”, “message”: “Validation failed (numeric string is expected)” } Below is my code: @Controller(‘tasks’) @UseGuards(AuthGuard()) export class TasksController { constructor(private tasksService: TasksService)…

Details