January 13, 2020 at 12:31 pm
Hi All
I have a requirement where I am executing 2 ExecuteSQL task in parallel which calls the same proc. The proc has a parameter: @BatchSize
I want the first executeSQL task to run with value @BatchSize and wants the second task to execute with parameter @BatchSize*2.
How can this be achieved as ?*2 doesn't work.
thanks
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
January 13, 2020 at 12:37 pm
I assume you're doing something like this:
EXEC dbo.YourProcedure @BatchSize = @BatchSize * 2;
With a Stored Procedure you can't pass expressions as parameters, only variables or literals. If you want to use an expression you must first derive it and then pass that value:
SET @BatchSize = @BatchSize * 2
EXEC dbo.YourProcedure @BatchSize = @BatchSize;
If this isn't the problem, you need to explain in more detail what it is you're doing, the error/unexpected behaviour you're getting, and what you're expecting to happen.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 13, 2020 at 12:42 pm
How can this be achieved as ?*2 doesn't work.
With nearly 9000 points, you should be able to do better than this.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply