Stack Overflow for Teams A private, secure home for your team’s questions and answers. M9 1a8 8 0 1 0 0 16A8 8 bitcoin 999 bottle 0 0 9 1zm. I have a function that takes 2 parameters and return a table.
Is it possible to use this function in a select and show the 3 columns that it returns? 3 from Person a OUTER APPLY dbo. I have assumed the column names are col1, col2, col3 for illustration. You use CROSS APPLY when the function must return 1 or more rows to retain the Person record. Use OUTER APPLY to keep the Person record even if the function results in no rows. Passport- it doesn’t seem, that it is returning a table.