Unable execute SQL Query via VC - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

krishnat
No customer Topic Starter

2014-03-24T13:00:04Z

Hi,

When I tried executing a SQL query through VC i am getting the following error

Error in SQL query: Must declare the scalar variable "@market".

Exception in Task: Must declare the scalar variable "@market".

Whereas I am able to execute the same query in query analyzer.

FYI - I have declared the @market variable (Declare @market varchar (500))

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Support
Official support

2014-03-25T07:49:13Z

Originally Posted by: krishnat

Hi,

When I tried executing a SQL query through VC i am getting the following error

Error in SQL query: Must declare the scalar variable "@market".

Exception in Task: Must declare the scalar variable "@market".

Whereas I am able to execute the same query in query analyzer.

FYI - I have declared the @market variable (Declare @market varchar (500))

Please attach screenshots. It sounds like you do not use Stored procedure tab in the SQL Task.

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!