I have a set of values in one column like DeviceId1, DeviceId2, DeviceId3 etc.
My Sample input consists of one table with one column like below.

```
Device

DeviceId1
DeviceId2

```

Now for each value in this column I want to pass the DeviceId1 into a stored procedure which will return more values corresponding to each Input passed. And I want final result to be like this in a single table.

```
Device       DeviceParameter1FromSP   DeviceParameter2FromSP

DeviceId1    100                      200
DeviceId2    120                      222

```

What is best approach to get this result?
Note: Stored procedure can not be changed.
I have not tried anything yet as I am unable to think an approach.