I want to run a SP (shown below)...
for every row in
SELECT * FROM mainDB WHERE X = 'hi'
(say for example this brings in 2000 rows)
feeding in 2 columns of variables...
@Product = (COLUMN1 of main select statement),
@AccountID = 'D6323759-1E95-4354-85A1-7040EA6F5FD8',
@ContractDate = (COLUMN2 of main select statement),
@StartDate = '20130510',
@EndDate = '20130510'
can someone point me in the right direction?
I see things online like PIVOT/CURSOR/ROWNEXT..