Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How can we optimize a query having TABLE VALUED function in SELECT? RE: How can we optimize a query having TABLE VALUED function in SELECT?

  • April 3, 2013 at 8:26 am

    #1603197

    Your function takes three parameters, yet in your query, you pass it four. Do you not get an error when you run the query?

    We may not be able to help you with performance without DDL and sample data, but if you could post an execution plan, we may be able to spot something obvious.

    John