Using variables in 'Execute SQL Task'

Question

Post reply

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')

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

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