drummer54 Posted April 11, 2014 Share 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. Link to comment Share on other sites More sharing options...
bolsover Posted April 12, 2014 Share Posted April 12, 2014 It would be helpful if you post the full query. Link to comment Share on other sites More sharing options...
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