Error while executing sp_get_query_template

• GA_SQL

  Hall of Fame

  Points: 3166

  More actions

  November 14, 2017 at 2:32 am

  #326261

  Inside the sp_get_query_template
  I have Some declaration parameters , used in the query
  i have SELECT Statement with the union of another SELECT Statement

  Msg 10523, Level 16, State 3, Procedure sp_get_query_template, Line 1 [Batch Start Line 0]
  Cannot generate query template because @querytext does not contain a valid single query.

  Please help me in this to resolve..

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  November 14, 2017 at 3:58 am

  #1967931

  Post the code, please.

  I imagine it's going wrong because you have DECLARE statements in your query text.  You should only include the actual query.

  John