The ItemID would be the input parameter because it's the primary key that allows the item to be joined between the two tables in query. The output parameters should...

I typed in many variations of specifically what I was trying to do. But thanks for the great advice.

Just curious, but what does "google-fu" mean in your response?

This is what the client has requested. It would be greatly appreciated if you could help.

Once I've created user roles for the employees and managers, I'll be able to limit what each can do. I haven't had a chance to do that yet. ...

The reason why is because I would have to write 28 stored procedures which is much more time intensive and involving than I would like. I was hoping I...

Hi Chris M,

On your response below, why does the code start with a semicolon? Is SalesPerEmp functioning as a stored procedure? Thanks, RM

;

WITH SalesPerEmp AS (

SELECT

e.firstname...

Thank you for your help!

RM

I'm trying to create a function, not a new table.