Storing result set as a variable in a procedure

See more:

SQL-Server-2008R2

HI,

I have a stored procedure where i am using a Insert Select Statement to insert specific records.

Insert into Test.dbo.G_Record 
Select * from Test.dbo.InformationCurrent c
INNER JOIN Test.dbo.VendorInformation pr  (NOLOCK) ON c.MarketNumber = pr.MarketNumber AND c.FeeSchedule = pr.VendorFeeSchedule AND c.Specialty = pr.Specialty	
INNER JOIN Test.dbo.Translation s  (NOLOCK) ON c.Specialty = s.NMDB_Specialty
Where 
(c.ClientID = '287' AND pr.VendorProductIndicator IN ('SX','SY','SZ'))
OR  ( c.ClientID = '559' AND pr.VendorProductIndicator = 'D7' ) 

Now i have a new table Temp(ClientID,ProductIndicator) with data as follows

ClientID ProductIndicator
288 SX
288 SI
256 SJ
256 SY

Now i have to add these values to the above insert select statement's where condition like below statements.
(clientID='288' AND ProductIndicator IN('SX','SI')) OR
(clientID='256' AND ProductIndicator IN('SJ','SY'))

As similar to above lines have to be added to the exisiting Insert select query for any number of records in the new Temp table automatically without hard coding.

Thanks in advance...