how to do this?

[codrgi]

i want to exec a stored procedure with the parameter thats inside a table somewhere, say i do this

 

 

    select @col = column from table
    exec storedprocedure @col

 

 

i want it to do the stored precedure for the whole table finding the parameter itself by using the select statement, not just the last row it finds, as when i do this it only does it for just one row, how do i go about doing this for each row it finds, that i ask it to select?

[fenway]

It doesn't matter where the parameter comes from... you need to pass it and sent to the SP.