Jump to content
We've recently updated our Privacy Statement, available here ×

Errors passing parameters to SQL Server function


drummer54

Recommended Posts

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

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...