For example:

1.
 Assume there is a MS SQL Table-Valued Function defined as
 CREATE FUNCTION dbo.ufnGetContactInformation(@ContactID int)
 RETURNS @retContactInformation TABLE
 (
  -- Columns returned by the function
  ContactID int PRIMARY KEY NOT NULL,
  FirstName nvarchar(50) NULL,
  LastName nvarchar(50) NULL,
  JobTitle nvarchar(50) NULL,
  ContactType nvarchar(50) NULL
 );...RETURN;
 END;

2.
 The following SQL can be used to report from the function:
  SELECT
  ContactID, FirstName, LastName, JobTitle, ContactType
  FROM dbo.ufnGetContactInformation(5)
 It needs to be saved to .SQL file.
 Note:
 - no semicolon at the end;
 - parameter @ContactID INT is temporarily used with hard-coded
 value 5, which will be substituted with parameter in the next
 steps

3.
 Create synonym for External SQL Script above and add Variable
 definition (VARIABLE NAME=&&CONTACTID) to the synonym:
 FILENAME=UFNGETCINFO, SUFFIX=SQLMSS , $
 VARIABLE NAME=&&CONTACTID,DEFAULT=1,$
  SEGMENT=UFNGETCINFO, SEGTYPE=S0, $
  FIELDNAME=CONTACTID, ALIAS=ContactID, USAGE=I11, ACTUAL=I4, $
  FIELDNAME=FIRSTNAME, ALIAS=FirstName, USAGE=A50V, ACTUAL=A50V,
  MISSING=ON, $
  FIELDNAME=LASTNAME, ALIAS=LastName, USAGE=A50V, ACTUAL=A50V,
  MISSING=ON, $
  FIELDNAME=JOBTITLE, ALIAS=JobTitle, USAGE=A50V, ACTUAL=A50V,
  MISSING=ON, $
FIELDNAME=CONTACTTYPE, ALIAS=ContactType, USAGE=A50V,
 ACTUAL=A50V,
  MISSING=ON, $

4.
 Add Variable to SQL Script FROM-clause
 dbo.ufnGetContactInformation(&&CONTACTID) and use TABLE to
 produce a report:
 -* using non-default parameter value, e.g. 5:
 -SET &&CONTACTID = 5;
 TABLE FILE UFNGETCINFO
 PRINT *
 END