dynamic query

• Ghanta

  Hall of Fame

  Points: 3999

  More actions

  April 17, 2008 at 3:25 pm

  #71151

  I have to break dynamic query into two as it was more than 4000 characters long.

  I have to use Execute(@nsql_1 + ' ' + @nsql_2) now

  how can I use two parameters to use sp_executesql?

  EXECUTE @error = sp_executesql @nsql, N'@min_date SMALLDATETIME,@max_date SMALLDATETIME',@min_date,@max_date

  Thanks for help....

• Jeremy-475548

  Hall of Fame

  Points: 3035

  More actions

  April 17, 2008 at 7:42 pm

  #804076

  I don't think you can. Build your parameters inline with your sql, and use the straight EXEC command instead of sp_executesql.

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  April 17, 2008 at 11:10 pm

  #804098

  [font="Verdana"]

  Declare @sql VarChar(MAX)

  Set @sql = '{You whole select statement}'

  EXECUTE @error = sp_executesql @sql, N'@min_date SMALLDATETIME, @max_date SMALLDATETIME', @min_date,@max_date

  Mahesh

  [/font]

  MH-09-AM-8694

• Jeremy-475548

  Hall of Fame

  Points: 3035

  More actions

  April 18, 2008 at 5:42 am

  #804253

  Ah yes, varchar(Max). Sorry, I was still in SQL 2000 land...