Using variables in 'Execute SQL Task'

• Mister Ken

  SSChasing Mays

  Points: 659

  More actions

  January 11, 2011 at 11:59 am

  #232041

  I have a couple of variables, @dtQtrBeginDate and dtQtrEndDate.

  How would I use it in an insert statement that I have coded in the SQLStatement property?

  I'm using this statement, and I'm getting an error:

  INSERT INTO csuLog

  (vchUserName, dtQtrBeginDate, dtQtrEndDate, vchDescription)

  VALUES

  ('jsmith', @dtQtrBeginDate, @dtQtrEndDate, 'My Basic Description')

• WayneS

  SSC Guru

  Points: 95405

  More actions

  January 11, 2011 at 3:12 pm

  #1272116

  This BOL entry should answer your questions.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2