Home Forums SQL Server 7,2000 T-SQL Function giving subquery returned more than 1 value, this is not permitted.....error RE: Function giving subquery returned more than 1 value, this is not permitted.....error

  • I know why because that @PayrollConfirmTable is a temporary one and thus i can't get result when I execute the table outside of the function. How can I make it as a separate table and recall from some where else of the application.