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: 
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

```
Is this what you're looking for?

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

```