I am trying to concatenate a custom string with a variable that is an int.
Investigation is pending for ['+ @investigationidout +']. When I hover the mouse pointer over the first
+ sign it says:
Incorrect syntax near '+'
Is this possible ?
I need to see something like:
Investigation is pending for 1234
EXEC sp_wf_create_notification @processid, @vactivityid, @vstepid, 1, @vidColumn, @vidColumnTable, @investigationidout, @owner, 'Pending Investigation', 'Investigation is pending for ['+ @investigationidout +'] ' @nextstepurl, @vstatus OUTPUT, @verror OUTPUT