drummer54 Posted April 11, 2014 Posted April 11, 2014 I'm trying to pass 2 parameters to a SQL Server function in a SQL join:join reports.dbo.get_data($P{uid}, $P{rid}) The first parameter displays this error: missing 'ON' at '('The second parameter displays this error: no viable alternative at input '$P{rid}'Also getting "missing EOF at '('" in the order by clause on this line:rtrim(e.LastName + ', ' + e.FirstName + ' ' + ISNULL(e.middlename, ''))I'm guessing it's something to do with the driver but, as is usually the case, can find no help.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now