Right first post so bear with me!
I have a query that I would like to turn into a function, the query needs to output multiple columns.
The output of this function would then be used in a select query.
So basically I want to select from table A a transid, pass this to the function which will then output a number of fields.
Now I know that I can create a table function but the problem with that is how do I pass multiple transid's into it?
Or do I need to use a scalar function? but then how do I return more than one value?!
Erm I hope that I've explained it ok! any help more than appreciated!