SQL insert into..select + add column when there are multiple rows being added

Question

I am trying to insert multiple rows into my TherapistRates table from my serviceLink table. I need to tack a therapistID onto each row. However, SQL is not allowing me to add a value when inserting multiple rows. How do I get around this?

Here is my query:

INSERT INTO TherapistRates (therapistID, serviceType)  
VALUES (@therapistID, (SELECT (serviceID) FROM serviceLink WHERE TherapistTypeID = @therapistID)

Answer 1

Why not:

insert into TheRapistRates (TherapistID, serviceType)
select TherapistTypeID , serviceID
from serviceLink
where TherapistTypeID = @TherapistID

NEW VERSION (from comment on other answers)

insert into TheRapistRates (TherapistID, serviceType)
select @TherapistID, serviceID
from serviceLink
where TherapistTypeID = @TherapistTypeID

Answer 2

Is this what you're looking for?

Insert  TherapistRates 
        (therapistID, serviceType)
Select  @TherapistId, ServiceId
From    ServiceLink
Where   TherapistTypeID = @TherapistTypeID