I am Creating SSRS reports using Vertica Data Source. I need to insert values to vertica physical table using SSRS input parameters. Build query like this:
INSERT INTO Employee VALUES (@GUID, @EmpNo, @EmpName);
While executing it thorows error:
ERROR: Syntax error at or near ","
----------------------------
[42601] ERROR: Syntax error at or near ","
Meanwhile, select query works fine with SSRS input parameters, query like this: select * from Employee
where GUID = @GUID.
Any help, why insert query does not work?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.